DIU-BLC
Database Management System (Summer 2021)
0%
Previous
Course data
General
Announcements
Welcome to DBMS Theory and LAB Class
Course Summary and Objectives
OBE Course outline
Course Introduction
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
Quiz-1
Level of Abstraction, Data Models, Database Languages
Database Architecture
Types of Keys in Relational Model
Entity Relationship (ER) Model
10 Minutes Practice [Click Here]
Use LucidChart to implement your 10 Minutes Work
Week 3
Submit your project ER:
ER to Schema Mapping
ER to Schema Mapping (Video Lesson)
Assignment-2 (ER to Schema Mapping)
Relational Algebra
Five Minutes Practice
Homework (Relational Algebra)
Week 4
Basic SQL Queries (P-1)
Assignment-3 (Create Database and Relation)
Week 5
Join Operation in DBMS
Database Join Operation with Example
SQL Join 10 Minutes Practice
Discussion regarding SQL Join Operation
Week 6
SQL queries in Database
Basic SQL Queries (P-2)
Discussion about SQL queries
Week 7
SQL Queries
Numeric Functions, Date & Time Functions File
Week 8
Subqueries in DBMS
Subqueries in DBMS
Midterm Week (Week 9)
MIDTERM Exam [Submit your hand written script by 4PM as Section_ID_CSE311]
Week 10
Stored Procedurer and Views
Week 11
Database Normalization
Week 12
Database Transaction
Database Transaction
Week 13
Trigger in Database
SQL Injection
Lab Final (Submit .txt file by 6:30PM)
SUBMIT YOUR PROJECT AS GUIDED
SUBMIT YOUR FINAL ASSIGNMENT AS GUIDED
Week 14
Final Exam
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 (FAH-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 (FAH-212)
Summary
Database Management System (Summer 2021)
Teacher:
Faisal Ahmed
Skill Level
:
Beginner