Course: Database Management System Theory & Lab (Fall 2024)

Section outline

Select section Welcome Database Management System

Welcome Database Management System

Collapse all Expand all
WELCOME LETTER

Dear Students

Welcome to the course of Database Management System , I, Dristi Saha, am here to guide you every step of the way. In this course, you'll gain the knowledge and skills needed to design, implement, and manage databases that are essential to today's data-driven world.

We'll explore fundamental concepts, from data models and SQL. Whether you're aspiring to be a database administrator, data analyst, or software developer, this course will provide you with the tools to succeed.

Get ready for a journey through the heart of data management—where you'll learn to structure, store, and retrieve data efficiently and securely. Your active participation, curiosity, and dedication will be key to mastering the material.

I look forward to an engaging and productive Fall-2023 semester with all of you!

Course Instructor

Name

Dristi Saha
Designation

Lecturer, Daffodil International University
Room Number

AB04 -726
Email

dristisaha.cse@diu.edu.bd
Contact No

+880-1932836825
- Select activity Announcements
  
  Announcements Forum
Select section Course Summary and Objectives

Course Summary and Objectives
- Select activity Course Rationale DBMS refers to an introductor...
  
  Course Rationale
  
  DBMS refers to an introductory course for understanding the fundamental concepts, principles, and techniques of database management systems. DBMS aims at the design, implementation and maintenance of relational databases, as well as various database models, query languages, normalization techniques, and database administration.
- Select activity Course Objective: Gain a foundational understan...
  
  Course Objective:
  
  Gain a foundational understanding of database management systems, including data models, normalization principles, and relational algebra.
  Develop proficiency in SQL for data manipulation, querying, and database schema definition.
  Learn to design and implement efficient relational databases using normalization techniques and proper schema design principles.
  Understand database security concepts and implement measures such as authentication, authorization, encryption, and auditing to protect data integrity and confidentiality.
  Explore advanced topics such as distributed databases, NoSQL databases, and data warehousing to understand emerging trends and technologies in the field.
- Select activity Course OutcomeCO1 : demonstrate a comprehensi...
  
  Course Outcome
  CO1 : demonstrate a comprehensive understanding of fundamental database management concepts, including the relational data model, normalization techniques, and SQL basics
  CO2: design, implement and optimize relational databases, incorporating advanced SQL queries, indexing techniques and query optimization strategies.
  CO3 understand and analyze security measures, distributed database architectures and emerging trends in database management, demonstrating an understanding of the broader context and challenges in the field.
- Select activity OBE Course outline
  
  OBE Course outline File
- Select activity Course Assessment:Final grade in each course will ...
  
  Course Assessment:
  Final grade in each course will be given on the basis of performance in class attendance, in-
  course examinations, assignments, midterm test and final examination is shown in Table.
- Select activity Text Book Database System Con...
  
  Text Book
  
  Database System Concept, Silbertz, Korth and Sudarshan
- Select activity Reference Book Fundamentals o...
  
  Reference Book
  
  Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.
- Select activity Course Content (ALL Slides) ...
  
  Course Content (ALL Slides)
- Select activity Course Slides (MID)
  
  Course Slides (MID) File
  
  Students must
  
  View
- Select activity Course Slides(Final)
  
  Course Slides(Final) File
  
  Students must
  
  View
- Select activity Database Security
  
  Database Security File
  
  Students must
  
  View
- Select activity NoSQL(Extra)
  
  NoSQL(Extra) File
  
  Students must
  
  View
Select section Topic 2

Topic 2
Class Feedback
- Select activity Class Feedback on Normalization
  
  Class Feedback on Normalization Assignment
  
  Opened: Sunday, 8 September 2024, 12:00 AM
  
  Due: Sunday, 8 September 2024, 11:59 PM
  
  Not available unless: You belong to 61_L
- Select activity Class Feedback on Normalization
  
  Class Feedback on Normalization Assignment
  
  Opened: Sunday, 8 September 2024, 12:00 AM
  
  Due: Sunday, 8 September 2024, 11:59 PM
  
  Not available unless: You belong to 61_K
Select section Topic 3

Topic 3
- Select activity Semester Schedule
  
  Semester Schedule
Select section Topic 4

Topic 4
Lesson 1
Learning Objectives:
Database Introduction, Database History, Flat File Database, Data and Information, Database Application
Problems in Conventional File Processing System, Difficulty in accessing data, Integrity problems, Atomicity problems, Security problems

Introduction to Database Management System
PDF(2.1MB) Purpose of Database System
- Select activity L1:Assessment your Leaning: What have I Learned?
  
  L1:Assessment your Leaning: What have I Learned? Quiz
  
  Students must
  
  View
  
  Receive a grade
- Select activity Click here for Feedback 
  
  Click here for Feedback
- Select activity Lesson 2Learning Objectives: Relational M...
  
  Lesson 2
  Learning Objectives:
  
  Relational Model in DBMS File;
- Select activity Relational_Model
  
  Relational_Model File
- Select activity L2:Assessment your Leaning: What have I Learned about Relational Model?
  
  L2:Assessment your Leaning: What have I Learned about Relational Model? Quiz
  
  Opened: Saturday, 4 January 2025, 2:35 PM
  
  Students must
  
  View
  
  Receive a grade
- Select activity Forum Discussion : Career on Database Management System
  
  Forum Discussion : Career on Database Management System
  
  Students must
  
  View
  
  Make forum posts: 1
- Select activity Click here for Feedback  (copy)
  
  Click here for Feedback
- Select activity Class Feedback
  
  Class Feedback Assignment
  
  Opened: Tuesday, 27 August 2024, 2:00 PM
  
  Due: Tuesday, 27 August 2024, 5:00 PM
  
  Not available unless: You belong to 61_L
- Select activity ER NotationData Isolation Property in DBMS with Ex...
  
  ER Notation
  Data Isolation Property in DBMS with Example
Select section Topic 5

Topic 5
- Select activity Lesson 3Learning Objectives: Data Models,...
  
  Lesson 3
  Learning Objectives:
  
  Data Models, Schemes & Instances,
  
  DBMS Vs RDBMS, ACID Properties.
  
  Two Tier Architecture, Three Tier Architecture
  
  Lecture Content: Level of Abstraction, Data Models, Database Languages
  
  Lecture Content: Database Architecture
  
  Video Lecture
- Select activity Quiz: Assessment of learning On level of Abstraction and Architecture of Database
  
  Quiz: Assessment of learning On level of Abstraction and Architecture of Database
  
  Opened: Wednesday, 8 January 2025, 1:06 AM
  
  Students must
  
  View
  
  Receive a grade
- Select activity Lesson 4Learning Objectives: Di...
  
  Lesson 4
  Learning Objectives:
  
  Discuss all types of keys in relational DB Model, Design, Entities, attributes and Entity sets, Relationships and Types of Attributes
  
  Lecture Content
  
  Lecture Content: Types of Keys in Relational ModelFile
  
  Lecture Content: Entity Relationship (ER) ModelFile
- Select activity 10 Minutes Practice [Click Here]
  
  10 Minutes Practice [Click Here] URL
- Select activity Use LucidChart to implement your 10 Minutes Work
  
  Use LucidChart to implement your 10 Minutes Work URL
- Select activity Click here for Feedback  (copy) (copy) (copy)
  
  Click here for Feedback
- Select activity ER Diagram week 2 (Slide 2)
  
  ER Diagram week 2 (Slide 2) File
Select section Topic 6

Topic 6
- Select activity Lesson 5Learning Objectives:Relationship sets, Car...
  
  Lesson 5
  Learning Objectives:
  Relationship sets, Cardinality
  of Relationships, Strong and
  Weak Entity Sets
  Lecture content:
  Er Basic
  ER BASIC 2
- Select activity Lecture Content: ER to Schema Mapping (Video Lesson)
  
  Lecture Content: ER to Schema Mapping (Video Lesson) URL
- Select activity Write your Feedback after every live class &n... (copy)
  
  Click Here for Feedback
- Select activity Lesson 6Learning Objectives:Relationship sets, Car...
  
  Lesson 6
  Learning Objectives:
  Relationship sets, Cardinality
  of Relationships, Strong and
  Weak Entity Sets
  Lecture Content
  ER to Schema 1
  ER to Schema 2
  ER to Schema 3
- Select activity Lecture Content: ER to Schema Mapping (Video Lesson) (copy)
  
  Lecture Content: ER to Schema Mapping (Video Lesson) (copy) URL
- Select activity Five Minutes Practice
  
  Five Minutes Practice File
- Select activity Write your Feedback after every live class &n...
  
  Click Here for Feedback
Select section Topic 7

Topic 7
- Select activity Lesson 7Learning Objectives: Part...
  
  Lesson 7
  Learning Objectives:
  
  Participation Constraints,
  
  Specialization, Generalization
  
  and Aggregation
  
  Lecture Content:
  
  Hand Note on Relational Algebra.pdf
  
  Relational Algebra 1 Example.pdf
  
  Relational Algebra 2 Example.pdf
  
  Relational Algebra 3 Example.pdf
  Video Lecture:
- Select activity Write your Feedback after every live class &n... (copy)
  
  Click Here for Feedback
- Select activity Lesson 8Learning Objectives:The Basic Parts of Spe...
  
  Lesson 8
  Learning Objectives:
  The Basic Parts of Speech in
  SQL,
  Commands,
  Cartesian Product, Cross product Natural join in Relational Algebra and SQL
- Select activity Lecture Content: Basic SQL Queries (P-1)
  
  Lecture Content: Basic SQL Queries (P-1) File
- Select activity Assessment of Leaning : What have I learned
  
  Assessment of Leaning : What have I learned Quiz
- Select activity Ask any question about sql operation
  
  Ask any question about sql operation Forum
- Select activity Write your Feedback after every live class &n... (copy) (copy)
  
  Click Here for Feedback
- Select activity natural join vs inner join
  
  natural join vs inner join URL
  
  Students must
  
  View
- Select activity Natural Join
  
  Natural Join URL
  
  Students must
  
  View
Select section Topic 8

Topic 8
- Select activity Lesson 9Learning Objectives: Join and join clas...
  
  Lesson 9
  Learning Objectives:
  
  Join and join classification?
  Natural and self join with example
  
  Click here to get resource
- Select activity Write your Feedback after every live class &n...
  
  Write your Feedback after every live class
  Click Here for Feedback
- Select activity Lesson 10Learning Objectives: Natual Join...
  
  Lesson 10
  Learning Objectives:
  
  Natual Join and Subqueries
  
  Subqueries lecture content
- Select activity Database SQL: Sub Queries Question
  
  Database SQL: Sub Queries Question Interactive Content
  
  Students must
  
  View
- Select activity Write your Feedback after every live class &n... (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
Select section Mid term Week

Mid term Week
Daffodil International University
Department of Computer Science and Engineering
MIDTERM EXAM

Topics:
Introduction to Database
Basics of Database Articheture and properties
Relational MOdel
Schema Diagram
SQL Operations
JOin and Subqueries
Select section Week 8

Week 8
- Select activity Lesson: 15 Normalization Types of no...
  
  Lesson: 15
  
  Normalization
  
  Types of normalization
  
  Normalization of example
  
  Normalization docs
  
  Normalization PPT
  
  Normalization of Database
  
  What is Normalization? 1NF, 2NF, 3NF, BCNF Database Example
- Select activity Write your Feedback after every live class &n... (copy) (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
- Select activity Database Transaction
  
  Database Transaction File
  
  Students must
  
  View
  
  Lesson: 16
  Lecture Objectives:
  Transaction Operation in Database
- Select activity Lecture Video:
  
  Lecture Video:
- Select activity Database Transaction part 1
  
  Database Transaction part 1 File
- Select activity Database Transaction part 2
  
  Database Transaction part 2 File
- Select activity Write your Feedback after every live class &n... (copy) (copy) (copy) (copy) (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
Select section Week Nine(9)

Week Nine(9)
- Select activity Lesson: 17 Learning Objectives: ...
  
  Lesson: 17
  
  Learning Objectives:
  
  ACID Properties
  
  Transaction details
  
  Commit
  
  Rollback
  
  savepoint
  
  Lecture Content
- Select activity Write your Feedback after every live class &n... (copy) (copy) (copy) (copy) (copy) (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
Select section Topic 12

Topic 12
- Select activity Lesson: 13Learning Objectives:  ...
  
  Lesson: 13
  Learning Objectives:
  
  States of Transaction
  
  Deadlock types
  
  Working Mechanism of PC
  
  Numeric Functions,
  
  Lecture Content
  
  Video Content
- Select activity Click here for Feedback  (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy)
  
  Click here for Feedback
- Select activity Lesson: 14Learning Objectives:  ...
  
  Lesson: 14
  Learning Objectives:
  
  Introduction to nested queries
  
  Lecture Content
  Lecture Content
  
  Video Content
- Select activity Click here for Feedback  (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy) (copy)
  
  Click here for Feedback
Select section Week 8

Week 8
- Select activity Subqueries in DBMS
  
  Subqueries in DBMS File
  
  Lecture Objectives:
  1. Deadlock in database
- Select activity Lecture Video:
  
  Lecture Video:
- Select activity Write your Feedback after every live class &n... (copy) (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
Select section Week 10

Week 10
- Select activity Database CRUD OperationLecture  Objective:&nb...
  
  Students must
  
  Mark as done
  
  Database CRUD Operation
  
  Lecture Objective:
  Insert
  Delete
  update
- Select activity Lecture Video:
  
  Lecture Video:
- Select activity Write your Feedback after every live class &n... (copy) (copy) (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
Select section Week 13

Week 13
- Select activity Trigger in Database
  
  Trigger in Database File
  
  Lecture Objectives
  What is DB Trigger? Trigger Syntax, Explanation of Trigger Syntax, Trigger Example
- Select activity Lecture Video:
  
  Lecture Video:
- Select activity Write your Feedback after every live class &n... (copy) (copy) (copy) (copy) (copy) (copy)
  
  Write your Feedback after every live class
  Click Here for Feedback
Select section Week 14

Week 14
- Select activity Label
- Select activity Demo quiz
  
  Demo quiz
Select section Topic 17

Topic 17
Assignment
Assignment must be hand written. No output is needed. Just write commands
- Select activity Assignment (61-K)
  
  Assignment (61-K)
  
  Opened: Tuesday, 17 December 2024, 12:00 AM
  
  Due: Saturday, 21 December 2024, 11:59 PM
  
  Students must
  
  View
  
  Make a submission
- Select activity Assignment (61_L)
  
  Assignment (61_L)
  
  Opened: Tuesday, 17 December 2024, 12:00 AM
  
  Due: Saturday, 21 December 2024, 11:59 PM
  
  Students must
  
  View
  
  Make a submission
- Select activity Assignment file dbms
  
  Assignment file dbms
  
  Students must
  
  View
Select section LAB

LAB
Database Management System Lab
Select section Mark Distribution

Mark Distribution
Marks Distribution
Select section Lab Week 1

Lab Week 1
WEEK ONE
- Select activity Tool Installation
  
  Tool Installation URL
  
  Students must
  
  Mark as done
- Select activity SQL Data Type
  
  SQL Data Type File
  
  Students must
  
  View
Select section Lab Week 2

Lab Week 2
WEEK TWO
Learning Outcome:
Learn about the fundamental elements of relational database management systems.
Learn How to create database, table,
Insert values, show table data.
Rename table name.
Drop table and database.
- Select activity DDL(TFS)
  
  DDL(TFS) File
  
  Students must
  
  View
- Select activity Lab 2
  
  Lab 2 File
  
  Students must
  
  View
Select section Lab Week 3

Lab Week 3
WEEK THREE

Learning Objective:

Distinct

Limit

where clause

Arithmetic operator

Between

Update

Alter table (Add column, Drop column, Modify datatype, change column Name)

Truncate

Logical operators: And, Or, Not, In, Like
- Select activity DML 1
  
  DML 1 File
  
  Students must
  
  View
- Select activity DML 2
  
  DML 2 File
  
  Students must
  
  View
- Select activity Lab 3
  
  Lab 3 File
  
  Students must
  
  View
Select section Topic 23

Topic 23
WEEK FOUR
Learning Objective:
Aggregate Function: Max, Min, Sum, Avg, Count
Group by
Having
Order by
- Select activity Aggregate Function
  
  Aggregate Function File
  
  Students must
  
  View
Select section Topic 24

Topic 24
WEEK FIVE
Learning Objective:
Table Joining
Inner Join
Left Join
Right Join
Full Join
- Select activity Join Doc 1
  
  Join Doc 1 File
  
  Students must
  
  View
- Select activity Join DOC 2
  
  Join DOC 2 File
  
  Students must
  
  View
- Select activity Join Lab Task
  
  Join Lab Task Assignment
  
  Students must
  
  View
  
  Make a submission
Select section Topic 25

Topic 25
WEEK SIX
Learning Objective:
Sub query
Nested Query on Joining
Union/ Union All
Intersect,Minus
- Select activity Data of Slide 6
  
  Data of Slide 6 URL
  
  Students must
  
  View
  
  Bank Database
  branch (branch_name, branch_city, assets)
  
  customer (customer_name, customer_street, customer_city)
  
  loan (loan_number, branch_name, amount)
  
  borrower (customer_name, loan_number)
  
  account (account_number, branch_name, balance)
  
  depositor (customer_name, account_number)
Select section Topic 26

Topic 26
WEEK SEVEN
Learning Objective:
Joining query practice
Domain Constraints in Relations
Primary Key, Foreign Key
Unique, Not Null
Check, Default
Select section Topic 27

Topic 27
WEEK EIGHT
Learning Objective:
Trigger
SQL view
Stored Procedure
- Select activity Stored Procedure File
  
  Stored Procedure File
  
  Students must
  
  View
- Select activity Trigger File
  
  Trigger File
  
  Students must
  
  View
- Select activity Triggers In DBMS | MySQL Triggers With Examples
  
  Students must
  
  Mark as done
- Select activity Practice Stored Procedure
  
  Practice Stored Procedure File
  
  Students must
  
  View
Select section Topic 28

Topic 28
WEEK NINE
- Select activity View Practice Doc
  
  View Practice Doc File
  
  Students must
  
  View
- Select activity Trigger-2
  
  Trigger-2 File
  
  Students must
  
  View
- Select activity Trigger-1
  
  Trigger-1 File
  
  Students must
  
  View
Select section Topic 29

Topic 29
LAB & Project Report
- Select activity Lab Report Format
  
  Lab Report Format File
- Select activity Project Report Format
  
  Project Report Format File
Select section Topic 30

Topic 30
PROJECT EVALUATION
- Select activity Project Report Submission (61-K)
  
  Project Report Submission (61-K) Assignment
  
  Opened: Tuesday, 26 November 2024, 12:00 AM
  
  Due: Monday, 30 December 2024, 11:00 AM
  
  Not available unless: You belong to 61_K
- Select activity Project Report Submission (61-L)
  
  Project Report Submission (61-L) Assignment
  
  Opened: Tuesday, 26 November 2024, 12:00 AM
  
  Due: Monday, 30 December 2024, 11:00 AM
  
  Not available unless: You belong to 61_L
Select section Topic 31

Topic 31
Lab Report Evaluation
- Select activity DBMS Lab Experiment List
  
  DBMS Lab Experiment List File
  
  Students must
  
  View
- Select activity Lab Report Submission (61-K)
  
  Lab Report Submission (61-K) Assignment
  
  Opened: Tuesday, 26 November 2024, 12:00 AM
  
  Due: Sunday, 15 December 2024, 11:59 PM
  
  Not available unless: You belong to 61_K
- Select activity Lab Report Submission (61_L)
  
  Lab Report Submission (61_L) Assignment
  
  Opened: Tuesday, 26 November 2024, 12:00 AM
  
  Due: Sunday, 15 December 2024, 11:59 PM
  
  Not available unless: You belong to 61_L
Select section Topic 32

Topic 32
- Select activity DB Lab Evaluation
  
  DB Lab Evaluation File
  
  Students must
  
  View
- Select activity Lab Evaluation(K2)
  
  Lab Evaluation(K2) Assignment
  
  Opened: Thursday, 5 December 2024, 10:00 AM
  
  Due: Thursday, 5 December 2024, 11:10 AM
  
  Not available unless: You belong to 61_K


		Name		Dristi Saha
		Designation		Lecturer, Daffodil International University
		Room Number		AB04 -726
		Email		dristisaha.cse@diu.edu.bd
		Contact No		+880-1932836825

Welcome Database Management System

Announcements

Course Summary and Objectives

OBE Course outline

Course Slides (MID)

Course Slides(Final)

Database Security

NoSQL(Extra)

Topic 2

Topic 3

Topic 4

L1:Assessment your Leaning: What have I Learned?

Relational_Model

L2:Assessment your Leaning: What have I Learned about Relational Model?

Forum Discussion : Career on Database Management System

Topic 5

Quiz: Assessment of learning On level of Abstraction and Architecture of Database

10 Minutes Practice [Click Here]

Use LucidChart to implement your 10 Minutes Work

ER Diagram week 2 (Slide 2)

Topic 6

Lecture Content: ER to Schema Mapping (Video Lesson)

Lecture Content: ER to Schema Mapping (Video Lesson) (copy)

Five Minutes Practice

Topic 7

Lecture Content: Basic SQL Queries (P-1)

Assessment of Leaning : What have I learned

Ask any question about sql operation

natural join vs inner join

Natural Join

Topic 8

Database SQL: Sub Queries Question

Mid term Week

Week 8

Database Transaction

Database Transaction part 1

Database Transaction part 2

Week Nine(9)

Topic 12

Week 8

Subqueries in DBMS

Week 10

Week 13

Trigger in Database

Week 14

Demo quiz

Topic 17

Assignment (61-K)

Assignment (61_L)

Assignment file dbms

Lab Week 1

Tool Installation

SQL Data Type

Lab Week 2

DDL(TFS)

Lab 2

Lab Week 3

DML 1

DML 2

Lab 3

Topic 23

Aggregate Function

Topic 24

Join Doc 1

Join DOC 2

Join Lab Task

Topic 25

Data of Slide 6

Topic 27

Stored Procedure File

Trigger File

Practice Stored Procedure

Topic 28

View Practice Doc

Trigger-2

Trigger-1

Topic 29

Lab Report Format

Project Report Format

Topic 30

Course Instructor

Name

Dristi Saha
Designation

Lecturer, Daffodil International University
Room Number

AB04 -726
Email

dristisaha.cse@diu.edu.bd
Contact No

+880-1932836825