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
Report
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 1
3.
Week 1
Introduction to Database Management System
File
Lecture Objectives:
Database Introduction, Database History, Flat File Database, Data and Information, Database Application
The PPT file is attached for better understanding. Also, you can check the attached video.
watch
2nd Class, PC-A, Recorded
URL
Restricted
Not available unless: You belong to
PC-A
2nd Class, PC-B, Recorded
URL
Restricted
Not available unless: You belong to
PC-B
Purpose of Database System
File
Lecture Objectives:
Problems in Conventional File Processing System, Difficulty in accessing data, Integrity problems, Atomicity problems, Security problems
What have I Learned
Quiz
Relational Model in DBMS
File
Lecture Objectives:
Relational Model? Relational Model Concept, Relational Integrity Constraints, Operation in Relational Model
watch
Forum Discussion about pros and cons of Conventional File Processing System
General
Course Summary and Objectives
Course Introduction
Week 2
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
◄
Course Introduc...
Week 2
►