DIU-BLC
Database Management System (Summer 20)
0%
Previous
Course data
General
Announcements
Welcome to DBMS Class
Social forum
Course Summary and Objectives
OBE Course outline
Course Introduction
Welcome to the course!
Week 1
Introduction to Database Management System
Purpose of Database System
What have I Learned
Relational Model in DBMS
Forum Discussion about pros and cons of Conventional File Processing System
Week 2
Level of Abstraction, Data Models, Database Languages
Dive Deep Into Relational Model
Week 3
DBMS, PC-B, New Class, (09-06-2020)
Entity Relationship (ER) Model
Use LucidChart to implement your 10 Minutes Work
10 Minutes Practice [Click Here]
ER to Schema Mapping
ER to Schema Mapping (Video Lesson)
Week 4
How to convert ER Diagram to Schema Diagram
DBMS, PC-A, New Class, (14-06-2020)
DBMS, PC-A, New Class, (15-06-2020)
DBMS, PC-B, New Class, (14-06-2020)
DBMS, PC-B, New Class, (16-06-2020)
Week 5
Basic SQL
Basic SQL Practice
DBMS, PC-A, New Class, (22-06-2020)
DBMS, PC-B, New Class, (23-06-2020)
Week 6
Like Operator
SQL queries in Database
50 SQl Query Practicer
Subquery Understanding
Discussion about SQL queries
DBMS, PC-A, New Class, (28-06-2020)
DBMS, PC-A, New Class, (29-06-2020)
DBMS, PC-B, New Class, (28-06-2020)
DBMS, PC-B, New Class, (30-06-2020)
Mid Term Week (Week 7)
Online Exam Response Submission Template
Online Exam Guideline
Week 8
More on Subqueries
Join Operation
Database Normalization
Database Normalization (Video Contents)
Queries on Week 8
Week 9
Week 10
Stored Procedurer and Views
Introduction to PL/SQL
PL/SQL Example and Stored Procedure
Trigger, Rollback, Savepoint etc
Week 11 (Final Examination)
Exam Guidelines
Answer Script Template
Final Exam Question
Week 12
Week 13
Week 14
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 Content
1.
General
2.
Course Summary and Objectives
3.
Course Introduction
4.
Week 1
5.
Week 2
6.
Week 3
7.
Week 4
8.
Week 5
9.
Week 6
10.
Mid Term Week (Week 7)
11.
Week 8
12.
Week 9
13.
Week 10
14.
Week 11 (Final Examination)
Site Navigation
CSE 311 (SMP-202)
Home
Calendar
Skip to main content
Database Management System (Summer 20)
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Summer 20
CSE 311 (SMP-202)
Week 4
6.
Week 4
How to convert ER Diagram to Schema Diagram
Lesson
Mark as done
How to convert ER Diagram to Schema Diagram
This video will give you a hint how to convert ER Diagram to Shema Diagram.
More details are provided in the ppt slide of ER Diagram
watch
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-A
Restricted
Not available unless: You belong to
PC-A
Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Summary statistics should be modeled as derived attributes.
Use
https://app.diagrams.net/
{It is for draw.io website} to draw your ER Diagram
Assignment-1 (Draw ER Diagram of your favourite sport team)_PC-B
Restricted
Not available unless: You belong to
PC-B
Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player statistics for each match. Summary statistics should be modeled as derived attributes.
User
https://app.diagrams.net/
{It is for draw.io} to create your ER Diagram
DBMS, PC-A, New Class, (14-06-2020)
Lesson
DBMS, PC-A, New Class, (14-06-2020)
https://drive.google.com/file/d/1Fe6EjdjnyI2hvA633CKk3xyEsJ9FB06s/view?usp=sharing
DBMS, PC-A, New Class, (15-06-2020)
Lesson
DBMS, PC-A, New Class, (15-06-2020)
https://drive.google.com/file/d/1Fe6EjdjnyI2hvA633CKk3xyEsJ9FB06s/view?usp=sharing
DBMS, PC-B, New Class, (14-06-2020)
Lesson
DBMS, PC-B, New Class, (14-06-2020)
https://drive.google.com/file/d/1vBh7avmTWVzRCpu3fLqtpTJHid2yzfdm/view?usp=sharing
DBMS, PC-B, New Class, (16-06-2020)
Lesson
DBMS, PC-B, New Class, (16-06-2020)
https://drive.google.com/file/d/1hH9OGCv7QU0EvRgruTRkwsLkwFocq7Vc/view?usp=sharing
General
Course Summary and Objectives
Course Introduction
Week 1
Week 2
Week 3
Week 5
Week 6
Mid Term Week (Week 7)
Week 8
Week 9
Week 10
Week 11 (Final Examination)
Week 12
Week 13
Week 14
◄
Week 3
Week 5
►