0% found this document useful (0 votes)
28 views12 pages

LPU DBMS Section K23EP Student Data

The document contains details about students from LPU - Lovely Professional University who participated in various sessions on topics related to SQL and database management systems. It includes the student name, username, team name, college name, topics covered in each session, session name, component used and other details like session type, date and number of problems solved. The sessions covered topics ranging from data definition language, data manipulation language, transaction control, views, aggregation functions, subqueries and more.

Uploaded by

kartikevergreen6
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
28 views12 pages

LPU DBMS Section K23EP Student Data

The document contains details about students from LPU - Lovely Professional University who participated in various sessions on topics related to SQL and database management systems. It includes the student name, username, team name, college name, topics covered in each session, session name, component used and other details like session type, date and number of problems solved. The sessions covered topics ranging from data definition language, data manipulation language, transaction control, views, aggregation functions, subqueries and more.

Uploaded by

kartikevergreen6
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

SNo Name Username Team Name College Name

1 12302841 12302841 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University


2 12303398 12303398 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
3 12303858 12303858 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
4 12303872 12303872 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
5 12303872 12303872 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
6 12303872 12303872 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
7 12304463 12304463 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
8 12304537 12304537 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
9 12305131 12305131 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
10 12305131 12305131 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
11 12305131 12305131 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
12 12306057 12306057 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
13 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
14 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
15 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
16 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
17 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
18 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
19 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
20 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
21 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
22 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
23 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
24 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
25 Harsh Nag 12307324 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
26 12307385 12307385 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
27 12307385 12307385 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
28 12307385 12307385 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
29 12307385 12307385 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
30 12307385 12307385 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
31 12308628 12308628 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
32 12308662 12308662 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
33 12311591 12311591 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
34 12311591 12311591 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
35 12311591 12311591 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
36 12311591 12311591 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
37 12311591 12311591 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
38 12319658 12319658 LPU_DBMS_SECTION_K23EP LPU - Lovely Professional University
Topics
Week2 - Data Manipulation Language
Week2 - Data Manipulation Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Definition Language
Week2 - Data Definition Language
Week2 - Data Manipulation Language
Week2 - Data Definition Language
Week3 - SQL Restricted and Sorted Data
Week3 - Aggregated Data Using the Group Functions
Week2 - Data Control and Transaction Control Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Definition Language
Week2 - Data Definition Language
Week2 - Data Manipulation Language
Week2 - Data Control and Transaction Control Language
Week5 - Views
Week5 - Views
Week5 - Display Data from Multiple Tables
Week3 - SQL Restricted and Sorted Data
Week3 - Aggregated Data Using the Group Functions
Week4 - Usage of Single-Row Functions to Customize Output
Week5 - Usage of Subqueries to Solve Queries
Week5 - Set Operators
Week5 - Introduction to Relational databases, Relational Algebra and Keys
Week5 - Introduction to Relational databases, Relational Algebra and Keys
Week2 - Data Definition Language
Week2 - Data Manipulation Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Manipulation Language
Week2 - Data Definition Language
Week2 - Data Manipulation Language
Week2 - Data Definition Language
Week2 - Data Manipulation Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Definition Language
Session Name Component Name
Data Manipulation Language (DML Statements)-Quiz quiz
Data Manipulation Language (DML Statements)-Quiz quiz
Data Control and Transaction Control Language / Explore quiz
DDL Statements - Query Writing dbmsComponent
DDL Statements - Query Writing dbmsComponent
Data Manipulation Language (DML Statements)-Quiz quiz
DDL Statements - Query Writing dbmsComponent
Restricted and Stored Data - Quiz quiz
Aggregate Functions - Query Writing dbmsComponent
Data Control and Transaction Control Language / Analyze quiz
Data Control and Transaction Control Language / Assess quiz
DDL Statements - Query Writing dbmsComponent
DDL Statements - Query Writing dbmsComponent
Data Manipulation Language (DML Statements)-Quiz quiz
Data Control and Transaction Control Language / Explore quiz
Views / Explore quiz
Views / Analyze quiz
Display Data from Multiple Tables - Quiz quiz
Restricted and Stored Data - Quiz quiz
Aggregate Functions - Quiz quiz
Usage of Single-Row Functions to Customize Output - Quiz quiz
Usage of Subqueries to Solve Queries- Quiz quiz
Set Operators - Quiz quiz
Introduction to Relational databases, Relational Algebra and Keys / Explore quiz
Introduction to Relational databases, Relational Algebra and Keys / Analyze quiz
DDL Statements - Quiz quiz
Data Manipulation Language (DML Statements)-Query Writiing dbmsComponent
Data Control and Transaction Control Language / Explore quiz
Data Control and Transaction Control Language / Analyze quiz
Data Control and Transaction Control Language / Assess quiz
Data Manipulation Language (DML Statements)-Query Writiing dbmsComponent
DDL Statements - Query Writing dbmsComponent
Data Manipulation Language (DML Statements)-Query Writiing dbmsComponent
DDL Statements - Quiz quiz
Data Manipulation Language (DML Statements)-Quiz quiz
Data Control and Transaction Control Language / Explore quiz
Data Control and Transaction Control Language / Analyze quiz
DDL Statements - Quiz quiz
Session Type Solved Date Problem Solved Count
i-Explore 18-02-2024 15
i-Explore 10-02-2024 15
i-Explore 17-02-2024 10
i-Design 18-02-2024 6
i-Assess 18-02-2024 2
i-Explore 18-02-2024 15
i-Assess 17-02-2024 1
i-Explore 17-02-2024 1
i-Design 18-02-2024 6
i-Analyse 18-02-2024 10
i-Assess 18-02-2024 9
i-Assess 10-02-2024 1
i-Design 11-02-2024 5
i-Explore 11-02-2024 15
i-Explore 11-02-2024 10
i-Explore 18-02-2024 16
i-Analyse 18-02-2024 13
i-Explore 18-02-2024 20
i-Explore 18-02-2024 17
i-Explore 18-02-2024 17
i-Explore 18-02-2024 20
i-Explore 18-02-2024 20
i-Explore 18-02-2024 10
i-Explore 18-02-2024 14
i-Analyse 18-02-2024 13
i-Explore 10-02-2024 15
i-Assess 17-02-2024 2
i-Explore 17-02-2024 10
i-Analyse 17-02-2024 10
i-Assess 17-02-2024 9
i-Design 18-02-2024 1
i-Design 11-02-2024 5
i-Design 17-02-2024 6
i-Explore 17-02-2024 15
i-Explore 17-02-2024 15
i-Explore 17-02-2024 10
i-Analyse 17-02-2024 10
i-Explore 11-02-2024 15
18-02-2024
S No Name Week2
Username
-Week2
Data
Week3
Manipulation
- Data
- Aggregated
Definition
Language(quiz)
Week2
Data
Language(dbmsComponent)
- Using
Data Control
the Group
andFunctions(dbmsComponent)
Transaction
Week5
Week5Control
- -Display
Views(quiz)
Language(quiz)
Week3
Data -from
SQL Multiple
Restricted
Tables(quiz)
and Sorted Data(quiz)
1 12302841 12302841 15 0 0 0 0 0 0
2 12303398 12303398 0 0 0 0 0 0 0
3 12303858 12303858 0 0 0 0 0 0 0
4 12303872 12303872 15 0 8 0 0 0 0
5 12304463 12304463 0 0 0 0 0 0 0
6 12304537 12304537 0 0 0 0 0 0 0
7 12305131 12305131 0 0 0 6 0 19 0
8 12306057 12306057 0 0 0 0 0 0 0
9 Harsh Nag12307324 0 0 0 0 17 0 29
10 12307385 12307385 0 0 0 0 0 0 0
11 12308628 12308628 0 1 0 0 0 0 0
12 12308662 12308662 0 0 0 0 0 0 0
13 12311591 12311591 0 0 0 0 0 0 0
14 12319658 12319658 0 0 0 0 0 0 0
18-02-2024 10-02-2024 17
Aggregated
Week4 - Usage
Data
ofUsing
Single-Row
Week5
the Group
- Usage
Functions
Week5
Functions(quiz)
of Subqueries
-to
Introduction
Customize
Week5to -Solve
Output(quiz)
Set
to Relational
Week2
Operators(quiz)
Queries(quiz)
- Data
databases,
Manipulation
Week2
Relational
-Week2
Language(dbmsComponent)
DataAlgebra
Manipulation
- Dataand
Definition
Keys(quiz)
Week2
Language(quiz)
Week2
Language(dbmsComponent)
- Data
- Data
Definition
Control and
Language(quiz)
Transaction Control Language(qu
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 15 0 0 0
0 0 0 0 0 0 0 0 0 10
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 1 0 0
20 17 20 20 10 27 0 0 0 0
0 0 0 0 0 0 0 0 15 29
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 20
0 0 0 0 0 0 0 0 0 0
17-02-2024 11-02-2024
2 - Data Definition
Week3 -Week2
Language(dbmsComponent)
SQL Restricted
- Data Manipulation
and Sorted
Week2Data(quiz)
Language(dbmsComponent)
- Data
Week2
Definition
-Week2
DataLanguage(quiz)
Manipulation
- Data Definition
Week2
Language(quiz)
Week2
Language(dbmsComponent)
- Data
- Data
Manipulation
Control and
Week2
Language(quiz)
Transaction
- Data Definition
Control Language(quiz)
Language(quiz)
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0 0
0 0 1 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 5 0 15 10
0 0 0 2 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 5 0 0 0
0 15 0 6 15 0 0 0 0
0 0 0 0 0 0 15 0 0
anguage(quiz)
Week2 - Data Manipulation Language
Week2 - Data Control and Transaction Control Language
Week2 - Data Definiti
S No Name Username quiz dbmsComponent quiz dbmsComponent
1 12302841 12302841 15 15 0 8 0 29 0
2 12303398 12303398 15 15 0 8 0 29 0
3 12303858 12303858 0 15 0 8 10 29 0
4 12303872 12303872 15 15 0 8 0 29 8
5 12304463 12304463 0 15 0 8 0 29 1
6 12304537 12304537 0 15 0 8 0 29 0
7 12305131 12305131 0 15 0 8 19 29 0
8 12306057 12306057 0 15 0 8 0 29 1
9 Harsh Nag 12307324 15 15 0 8 10 29 5
10 12307385 12307385 0 15 2 8 29 29 0
11 12308628 12308628 0 15 1 8 0 29 0
12 12308662 12308662 0 15 0 8 0 29 5
13 12311591 12311591 15 15 6 8 20 29 0
14 12319658 12319658 0 15 0 8 0 29 0
Week2 - Data Definition Language Week3 - SQL Restricted and Sorted
Week3
Data- Aggregated Data Using the Group Functions Week5 - Views
dbmsComponent quiz quiz dbmsComponent quiz quiz
8 0 15 0 17 0 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 0 15 1 17 0 24 0 17 0
8 0 15 0 17 6 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 0 15 17 17 0 24 17 17 29
8 15 15 0 17 0 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 0 15 0 17 0 24 0 17 0
8 15 15 0 17 0 24 0 17 0
8 15 15 0 17 0 24 0 17 0
Week5 - Views
Week5 - Display Data
Week4from
- Usage
Multiple
of Single-Row
Tables Functions
Week5to- Usage
Customize
of Subqueries
Output to SolveWeek5
Queries- Set
Introduction
Operatorsto Relational databases, Relational Al
quiz quiz quiz quiz quiz quiz
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 20 20 20 20 20 20 10 10 27
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
29 0 20 0 20 0 20 0 10 0
o Relational databases, Relational Algebra and Keys
quiz Total
34 15
34 15
34 10
34 23
34 1
34 1
34 25
34 1
34 190
34 46
34 1
34 5
34 56
34 15

You might also like