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 5
7.
Week 5
Basic SQL
File
Mark as done
Basic SQL
Download the attached file for this lesson.
Here we will learn all the basic and intermediates of SQL. Also check the lab files
Also a video is embedded for better understanding the CRUD operation
watch
Basic SQL Practice
URL
Mark as done
Basic SQL
Practice
DBMS, PC-A, New Class, (21-06-2020)
Lesson
Restricted
Not available unless: You belong to
PC-A
DBMS, PC-A, New Class, (21-06-2020)
https://drive.google.com/file/d/1Y-qeFvq1scuG-8H2L7zZsuyuYygdyljz/view?usp=sharing
DBMS, PC-A, New Class, (22-06-2020)
Lesson
Mark as done
DBMS, PC-A, New Class, (22-06-2020)
https://drive.google.com/file/d/12Mkq500oNpBscnVTBpzcs7QCbvCyGOBP/view?usp=sharing
DBMS, PC-B, New Class, (21-06-2020)
Lesson
Restricted
Not available unless: You belong to
PC-B
DBMS, PC-B, New Class, (21-06-2020)
https://drive.google.com/file/d/1Ew8_W4S0hlXbCU65CnokSo1XmxAffTv7/view?usp=sharing
DBMS, PC-B, New Class, (23-06-2020)
Lesson
Mark as done
DBMS, PC-B, New Class, (23-06-2020)
https://drive.google.com/file/d/1NCYmgDQYuu4Q4WMcVkt2JvRj9VAvVWv4/view?usp=sharing
First Quiz PC-A 1
Restricted
Not available unless:
You belong to
PC-A
You belong to
(Missing group)
10 mins for Answering All Questions and 10 mins for Submitting the quiz answers
First Quiz PC-A 2
Restricted
Not available unless:
You belong to
PC-A
You belong to
(Missing group)
10 mins for Answering All Questions and 10 mins for Submitting the quiz answers
First Quiz PC-A 3
Restricted
Not available unless:
You belong to
PC-A
You belong to
(Missing group)
10 mins for Answering All Questions and 10 mins for Submitting the quiz answers
First Quiz PC-B 1
Restricted
Not available unless:
You belong to
PC-B
You belong to
(Missing group)
10 mins for Answering All Questions and 10 mins for Submitting the quiz answers
First Quiz PC-B 2
Restricted
Not available unless:
You belong to
PC-B
You belong to
(Missing group)
10 mins for Answering All Questions and 10 mins for Submitting the quiz answers
First Quiz PC-B 3
Restricted
Not available unless:
You belong to
PC-B
You belong to
(Missing group)
10 mins for Answering All Questions and 10 mins for Submitting the quiz answers
PC-A 1 ERD
Assignment
Restricted
Not available unless:
You belong to
PC-A
You belong to
(Missing group)
PC-A 2 ERD
Assignment
Restricted
Not available unless:
You belong to
PC-A
You belong to
(Missing group)
PC-A 3 ERD
Assignment
Restricted
Not available unless:
You belong to
PC-A
You belong to
(Missing group)
PC-B 1 ERD
Assignment
Restricted
Not available unless:
You belong to
PC-B
You belong to
(Missing group)
PC-B 2 ERD
Assignment
Restricted
Not available unless:
You belong to
PC-B
You belong to
(Missing group)
PC-B 3 ERD
Assignment
Restricted
Not available unless:
You belong to
PC-B
You belong to
(Missing group)
General
Course Summary and Objectives
Course Introduction
Week 1
Week 2
Week 3
Week 4
Week 6
Mid Term Week (Week 7)
Week 8
Week 9
Week 10
Week 11 (Final Examination)
Week 12
Week 13
Week 14
◄
Week 4
Week 6
►