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