DIU-BLC
Database Management System (Summer 2021)
0%
Previous
Course data
General
Announcements
Course Summary and Objectives
Outline
Notice Board
Announcement
Courses Introduction
Course Introductory Video
Week 1
Week 2
Lecture 1.1: Introduction to Database Management System (Video)
Lecture 1.2: Purpose of DBMS System (Video)
Lecture 1.1: Introduction to Database Management System (Slide)
Lecture 1.2: Purpose of DBMS System (Slide)
Week 3
Lecture 2.1: Relational Model in DBMS (Video)
Lecture 2.2: Database Architecture (Video)
Lecture 2.1: Relational Model in DBMS (Slide)
Lecture 2.2: Database Architecture (Slide)
Forum Discussion about pros and cons of Conventional File Processing System
Lecture 3.1: Data Abstraction (Video)
Lecture 3.2: Relational DBMS -Keys(Video)
Lecture 3.1: Data Abstraction (Slide)
Lecture 3.1: Relational DBMS -Keys(slide)
Week 4
Lecture 4: ER model (Slide)
Week 5
Scenario to ERD Conversion Example (Slide)-1
Exercise on Scenario to ERD Conversion (Slide)-2
Exercise On ERD model
Use LucidChart to implement your work in 10 Minutes
Assignment 1
Assignment 1
ERD symbol Learning
ERD symbol Learning
Week 6
ERD to Relational Schema Conversion (Slide)
ER to Schema Mapping (PDF)
Quiz 1
Presentation
Presentation1
Week 7
Relational Algebra part 1
Relational Algebra Part 2
Week 8
Mid Syllabus
Sample exam script
Midterm Question Summer 2021
Week 9
Transaction Part 1
Transaction Part 1 Video
Transaction Part 1 SQL (video)
Transaction Part 2
Assignment 2
Overall Course Design Feedback
Week 10
DBMS Normalization (Video Lecture)
Normalization part 1
Normalization Part 2
Normalization Part 3
Normalization exercise
Week 11
Stored Procedure (Video Lecture)
DBMS Trigger (Video Lecture)
Stored Procedure and views
Trigger in Database
Week 12
Quiz 2 Question
Week 13
Final Exam Answer Script Template
Final Exam question Summer 2021
Google Form for Final exam answer script Submission
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
Site Navigation
CSE 311 (RUH-212)
Home
Skip to main content
To operate the Blended Learning Center(BLC) at optimal level, maintenance will be performed every day at 8:30 AM and at 5:00 PM regularly which can take up to 30 minutes. Please consider scheduling your activity in the BLC platform accordingly.
Course info
Home
Courses
DIU
Faculty of Science and Information Technology
Computer Science and Engineering
CSE Summer 2021
CSE 311 (RUH-212)
Summary
Database Management System (Summer 2021)
Teacher:
Rubaiya Hafiz
Skill Level
:
Beginner