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 2
4.
Week 2
Level of Abstraction, Data Models, Database Languages
File
The PPT file is enclosed here
For more knowledge about Database Model and Abstraction, check out the following video
watch
Check on the link below to provide what you actually learned on today's class
https://www.menti.com/8vq2ai9udt
Dive Deep Into Relational Model
File
Lecture Objectives:
Discuss all details relational DB Model.
Intuition for Relational Database
The following video will give you the concept of why actually we need a Relational Database. We will drive deep into our class.
watch
A deeper knowledge of keys in RDBMS
This video will give you more precise knowledge about Super Key, Candidate Key and Primary Key (
MUST WATCH
)
watch
DBMS, PC-A, New Class (2020-05-31)
Lesson
Restricted
Not available unless: You belong to
PC-A
Class Recording of 31st May, 2020
https://drive.google.com/file/d/1Y-qeFvq1scuG-8H2L7zZsuyuYygdyljz/view?usp=sharing
DBMS, PC-A, New Class, (2020-06-01)
Lesson
Restricted
Not available unless: You belong to
PC-A
Class Recording of 1st June, 2020
https://drive.google.com/file/d/1zA3GPAcdnNho88wWME_wINUt3vYpVg0W/view?usp=sharing
DBMS, PC-B, New Class(02-06-2020)
Lesson
Restricted
Not available unless: You belong to
PC-B
Class Recording of 2nd June, 2020
https://drive.google.com/file/d/1UUWaLAsQRfO_SXAzuDN1p9MCylKrcqme/view?usp=sharing
DBMS, PC-B, New Class (2020-05-31)
Lesson
Restricted
Not available unless: You belong to
PC-B
Class Recording of 31st May, 2020
https://drive.google.com/file/d/1Eu6k-xk2jo8CpUPojiAk7FXhGQwTzOjo/view?usp=sharing
Simple Quiz on RDBMS for PC-A (01-06-2020)
Restricted
Not available unless: You belong to
PC-A
Simple Quiz on RDBMS for PC-B (02-06-2020)
Restricted
Not available unless: You belong to
PC-B
General
Course Summary and Objectives
Course Introduction
Week 1
Week 3
Week 4
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 1
Week 3
►