DIU-BLC
Database Management System Theory and Lab SSH(Fall-2020)
0%
Previous
Database Normalization
General
Announcements
Welcome to DBMS Class
Course Summary and Objectives
OBE Course outline
Lab Docs
DBMS Project List
Week 1
Introduction to Database Management System
Purpose of Database System
Relational Model in DBMS
What have I Learned
Forum Discussion about pros and cons of Conventional File Processing System
Class (03/10/2020) (PC-A)
Class (03/10/2020) (PC-B)
LAB-1 (06/10/2020)
Feedback (Lab-1 (06-10-2020))
Discussion about Lab-1
Lab Class-1 (06-10-2020)
Week 2
Level of Abstraction, Data Models, Database Languages
Database Architecture
Types of Keys in Relational Model
Entity Relationship (ER) Model
10 Minutes Practice [Click Here]
Use LucidChart to implement your 10 Minutes Work
Assignment-1 (Draw ER Diagram of your favourite sport team)
Feedback (05-10-2020)
Class (05-10-2020) PC-A
Lab-2 (12-10-2020) (PC-B)
Feedback (Lab-2) (PC-A & PC-B)
Lab-2 (PC-A)
Quiz-1
Week 3
ER to Schema Mapping
Er to schema mapping
ERD
ERD_exercise_1
ERD_exercise_2
ERD_exercise_3
ER to Schema Mapping (Video Lesson)
Class: 12-10-2020 (PC-A)
Class: 12-10-2020 (PC-B)
Feedback (12-10-2020) (PC-A & PC-B)
Class (17-10-2020) (PC-A)
Feedback (17-10-2020) (PC-A & PC-B)
Review Assignment (class: 17-10-2020) (PC-A & PC-B)
Discussion about ERD to relational schema mapping
Class (17-10-2020) PC-B
Relational Algebra
Five Minutes Practice
Discussion (Relational Algebra)
Feedback (19-10-2020) (PC-A & PC-B)
Class (19-10-2020) (PC-A)
Class (19-10-2020) (PC-B)
Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B)
Lab Class-3 (19-10-2020) (PC-B)
Lab Class-3 (PC-A) (20-10-2020)
Week 4
Basic SQL Queries (P-1)
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1)
Discussion
Class (27-10-2020) (SQL-1)
Week 5
Class: 12-10-2020 (PC-A)
Join Operation in DBMS
Database Join Operation with Example
SQL Join 10 Minutes Practice
Discussion regarding SQL Join Operation
Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation)
Class (27-10-2020) (SQL-2)
Week 6
SQL queries in Database
Basic SQL Queries (P-2)
Discussion about SQL queries
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2)
Class (27-10-2020) (SQL-3)
Week 7
SQL Queries
Numeric Functions, Date & Time Functions File
class (31-10-2020) (PC-A)
Week 8
Subqueries in DBMS
Subqueries in DBMS
class (31-10-2020) (PC-B)
Midterm Week (Week 9)
Previous Semester's Midterm Examination Question
Week 10
Stored Procedurer and Views
Feedback (stored procedure) (pc-a & pc-b)
Discussion
Class (22-11-2020) (pc-a)
Week 11
Database Normalization
Feedback (normalization) (pc-a & pc-b)
Discussion
class (23-11-2020) pc-a
class (normalization) pc-b
Feedback (LAB-23-11-2020) (pc-a & pc-b)
LAB 23-11-2020 (PC-B)
Lab-24/11/2020 (pc-a)
Week 12
Database Transaction
Database Transaction
Feedback (28-11-2020) (PC-A & PC-B)
Discussion (pc-a and pc-b)
transaction (28-11-2020) PC-A
transaction (28-11-2020) (pc-b)
Database transaction part-2
Week 13
Trigger in Database
SQL Injection
class 30-11-2020 (pc-b)
class 30-11-2020 PC-A
ra review class (7-12-2020) (pc-b)
ra review class 7-12-2020 pc-a
12-12-2020 (pc-b)
12-12-2020 pc-a
lab 14-12-2020
Week 14
Previous Semester's Final Examination Question
Assignment
Presentation
MID TERM EXAM Fall-2020
Quiz-3
Next
DIU-BLC
Side panel
Guidelines
For Teachers
For Students
Search
Close
Search
Toggle search input
Log in
Username
Password
Remember username
Forgot Password?
Log in
Create new account
Course Overview
Sections
General
1
Announcements
Forum
Welcome to DBMS Class
Forum
Course Summary and Objectives
2
OBE Course outline
File
Lab Docs
URL
DBMS Project List
File
Week 1
3
Introduction to Database Management System
File
Purpose of Database System
File
Relational Model in DBMS
File
What have I Learned
Quiz
Forum Discussion about pros and cons of Conventional File Processing System
Class (03/10/2020) (PC-A)
URL
Class (03/10/2020) (PC-B)
URL
LAB-1 (06/10/2020)
URL
Feedback (Lab-1 (06-10-2020))
Choice
Discussion about Lab-1
Forum
Lab Class-1 (06-10-2020)
URL
Week 2
4
Level of Abstraction, Data Models, Database Languages
File
Database Architecture
File
Types of Keys in Relational Model
File
Entity Relationship (ER) Model
File
10 Minutes Practice [Click Here]
URL
Use LucidChart to implement your 10 Minutes Work
URL
Assignment-1 (Draw ER Diagram of your favourite sport team)
Feedback (05-10-2020)
Choice
Class (05-10-2020) PC-A
URL
Lab-2 (12-10-2020) (PC-B)
URL
Feedback (Lab-2) (PC-A & PC-B)
Choice
Lab-2 (PC-A)
URL
Quiz-1
5
Week 3
6
ER to Schema Mapping
File
Er to schema mapping
File
ERD
File
ERD_exercise_1
File
ERD_exercise_2
File
ERD_exercise_3
File
ER to Schema Mapping (Video Lesson)
URL
Class: 12-10-2020 (PC-A)
URL
Class: 12-10-2020 (PC-B)
URL
Feedback (12-10-2020) (PC-A & PC-B)
Choice
Class (17-10-2020) (PC-A)
URL
Feedback (17-10-2020) (PC-A & PC-B)
Choice
Review Assignment (class: 17-10-2020) (PC-A & PC-B)
Discussion about ERD to relational schema mapping
Forum
Class (17-10-2020) PC-B
URL
Relational Algebra
File
Five Minutes Practice
File
Discussion (Relational Algebra)
Forum
Feedback (19-10-2020) (PC-A & PC-B)
Choice
Class (19-10-2020) (PC-A)
URL
Class (19-10-2020) (PC-B)
URL
Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B)
Choice
Lab Class-3 (19-10-2020) (PC-B)
URL
Lab Class-3 (PC-A) (20-10-2020)
URL
Week 4
7
Basic SQL Queries (P-1)
File
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1)
Choice
Discussion
Forum
Class (27-10-2020) (SQL-1)
URL
Week 5
8
Class: 12-10-2020 (PC-A)
URL
Join Operation in DBMS
File
Database Join Operation with Example
URL
SQL Join 10 Minutes Practice
Quiz
Discussion regarding SQL Join Operation
Forum
Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation)
Choice
Class (27-10-2020) (SQL-2)
URL
Week 6
9
SQL queries in Database
URL
Basic SQL Queries (P-2)
File
Discussion about SQL queries
Forum
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2)
Choice
Class (27-10-2020) (SQL-3)
URL
Week 7
10
SQL Queries
File
Numeric Functions, Date & Time Functions File
URL
class (31-10-2020) (PC-A)
URL
Week 8
11
Subqueries in DBMS
File
Subqueries in DBMS
File
class (31-10-2020) (PC-B)
URL
Midterm Week (Week 9)
12
Previous Semester's Midterm Examination Question
File
Week 10
13
Stored Procedurer and Views
File
Feedback (stored procedure) (pc-a & pc-b)
Choice
Discussion
Forum
Class (22-11-2020) (pc-a)
URL
Week 11
14
Database Normalization
File
Feedback (normalization) (pc-a & pc-b)
Choice
Discussion
Forum
class (23-11-2020) pc-a
URL
class (normalization) pc-b
URL
Feedback (LAB-23-11-2020) (pc-a & pc-b)
Choice
LAB 23-11-2020 (PC-B)
URL
Lab-24/11/2020 (pc-a)
URL
Week 12
15
Database Transaction
File
Database Transaction
File
Feedback (28-11-2020) (PC-A & PC-B)
Choice
Discussion (pc-a and pc-b)
Forum
transaction (28-11-2020) PC-A
URL
transaction (28-11-2020) (pc-b)
URL
Database transaction part-2
File
Week 13
16
Trigger in Database
File
SQL Injection
URL
class 30-11-2020 (pc-b)
URL
class 30-11-2020 PC-A
URL
ra review class (7-12-2020) (pc-b)
URL
ra review class 7-12-2020 pc-a
URL
12-12-2020 (pc-b)
URL
12-12-2020 pc-a
URL
lab 14-12-2020
URL
Week 14
17
Previous Semester's Final Examination Question
File
Assignment
18
Presentation
19
MID TERM EXAM Fall-2020
20
Quiz-3
21
Skip to main content
Database Management System Theory and Lab SSH(Fall-2020)
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Fall 20
CSE311+CSE312(SSH-203)
Week 11
Database Normalization
Database Normalization
Lecture Objectives:
First Normal Form, Second Normal Form, Third Normal Form
Click
Normalization.pptx
link to view the file.
Previous Activity
Jump to...
Jump to...
Announcements
Welcome to DBMS Class
OBE Course outline
Lab Docs
DBMS Project List
Introduction to Database Management System
Purpose of Database System
Relational Model in DBMS
What have I Learned
Forum Discussion about pros and cons of Conventional File Processing System
Class (03/10/2020) (PC-A)
Class (03/10/2020) (PC-B)
LAB-1 (06/10/2020)
Feedback (Lab-1 (06-10-2020))
Discussion about Lab-1
Lab Class-1 (06-10-2020)
Level of Abstraction, Data Models, Database Languages
Database Architecture
Types of Keys in Relational Model
Entity Relationship (ER) Model
10 Minutes Practice [Click Here]
Use LucidChart to implement your 10 Minutes Work
Assignment-1 (Draw ER Diagram of your favourite sport team)
Feedback (05-10-2020)
Class (05-10-2020) PC-A
Lab-2 (12-10-2020) (PC-B)
Feedback (Lab-2) (PC-A & PC-B)
Lab-2 (PC-A)
ER to Schema Mapping
Er to schema mapping
ERD
ERD_exercise_1
ERD_exercise_2
ERD_exercise_3
ER to Schema Mapping (Video Lesson)
Class: 12-10-2020 (PC-A)
Class: 12-10-2020 (PC-B)
Feedback (12-10-2020) (PC-A & PC-B)
Class (17-10-2020) (PC-A)
Feedback (17-10-2020) (PC-A & PC-B)
Review Assignment (class: 17-10-2020) (PC-A & PC-B)
Discussion about ERD to relational schema mapping
Class (17-10-2020) PC-B
Relational Algebra
Five Minutes Practice
Discussion (Relational Algebra)
Feedback (19-10-2020) (PC-A & PC-B)
Class (19-10-2020) (PC-A)
Class (19-10-2020) (PC-B)
Feedback-Class (19-10-2020) Lab-3 (PC-A & PC-B)
Lab Class-3 (19-10-2020) (PC-B)
Lab Class-3 (PC-A) (20-10-2020)
Basic SQL Queries (P-1)
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-1)
Discussion
Class (27-10-2020) (SQL-1)
Class: 12-10-2020 (PC-A)
Join Operation in DBMS
Database Join Operation with Example
SQL Join 10 Minutes Practice
Discussion regarding SQL Join Operation
Feedback (27-10-2020) (PC-A & PC-B) (SQL Join operation)
Class (27-10-2020) (SQL-2)
SQL queries in Database
Basic SQL Queries (P-2)
Discussion about SQL queries
Feedback (27-10-2020) (PC-A & PC-B) (Basic SQL Queries-2)
Class (27-10-2020) (SQL-3)
SQL Queries
Numeric Functions, Date & Time Functions File
class (31-10-2020) (PC-A)
Subqueries in DBMS
Subqueries in DBMS
class (31-10-2020) (PC-B)
Previous Semester's Midterm Examination Question
Stored Procedurer and Views
Feedback (stored procedure) (pc-a & pc-b)
Discussion
Class (22-11-2020) (pc-a)
Feedback (normalization) (pc-a & pc-b)
Discussion
class (23-11-2020) pc-a
class (normalization) pc-b
Feedback (LAB-23-11-2020) (pc-a & pc-b)
LAB 23-11-2020 (PC-B)
Lab-24/11/2020 (pc-a)
Database Transaction
Database Transaction
Feedback (28-11-2020) (PC-A & PC-B)
Discussion (pc-a and pc-b)
transaction (28-11-2020) PC-A
transaction (28-11-2020) (pc-b)
Database transaction part-2
Trigger in Database
SQL Injection
class 30-11-2020 (pc-b)
class 30-11-2020 PC-A
ra review class (7-12-2020) (pc-b)
ra review class 7-12-2020 pc-a
12-12-2020 (pc-b)
12-12-2020 pc-a
lab 14-12-2020
Previous Semester's Final Examination Question
Next Activity