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 10
12.
Week 10
Stored Procedurer and Views
File
Introduction to PL/SQL
File
Mark as done
Introduction to PL/SQL
PL/SQL Example and Stored Procedure
File
Mark as done
PL/SQL Example and Stored Procedure
Trigger, Rollback, Savepoint etc
File
Mark as done
Trigger, Rollback, Savepoint etc
DBMS, 3rd Quiz, PC-A
Assignment
Restricted
Not available unless: You belong to
PC-A
DBMS, 3rd Quiz, PC-B
Assignment
Restricted
Not available unless: You belong to
PC-B
DBMS, PC-A, New Class, (09-08-2020)
Lesson
Restricted
Not available unless: You belong to
PC-A
DBMS, PC-A, New Class, (09-08-2020)
https://drive.google.com/file/d/1YJ7ZlXu2elokvptJP5XVFjm1HXFjQkeI/view?usp=sharing
DBMS, PC-B, New Class, (09-08-2020)
Lesson
Restricted
Not available unless: You belong to
PC-B
DBMS, PC-B, New Class, (09-08-2020)
https://drive.google.com/file/d/1HaZWa3pgSPINJ2_EpVMGfJCowYtyo0xE/view?usp=sharing
DBMS, PC-A, New Class, (16-08-2020)
Lesson
Restricted
Not available unless: You belong to
PC-A
DBMS, PC-A, New Class, (16-08-2020)
https://drive.google.com/file/d/1mDnLgTv0D9Fwj4pYM-jKlEZKgFWVkjQM/view?usp=sharing
DBMS, PC-B, New Class, (16-08-2020)
Lesson
Restricted
Not available unless: You belong to
PC-B
DBMS, PC-B, New Class, (16-08-2020)
https://drive.google.com/file/d/1l6uxEw8f5xliSDAcVrsUQ-YmwoaAp8I4/view?usp=sharing
DBMS, PC-A, New Class, 17-08-2020
Lesson
Restricted
Not available unless: You belong to
PC-A
DBMS, PC-A, New Class, 17-08-2020
https://drive.google.com/file/d/1DkQwgPBLMfYxrUM7qdq73LAkrMJ_Tios/view?usp=sharing
General
Course Summary and Objectives
Course Introduction
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Mid Term Week (Week 7)
Week 8
Week 9
Week 11 (Final Examination)
Week 12
Week 13
Week 14
◄
Week 9
Week 11 (Final ...
►