CS403 : Database Management Systems

Course Overview

Course Synopsis

CS403 offers students an introduction to the design and programming of database systems. In particular, the students will cover the ER (entity-relationship) approach to data modeling, the relational model of database management systems (DBMSs) and the use of query languages such as SQL. They will also cover relational algebra and the use of SQL in a programming environment and briefly touch upon query processing and role of transaction management.

Course Learning Outcomes

At the end of this course, you should be able to:

  • State the importance of DBMS and explain how DBMS is better than traditional File Processing Systems.
  • Analyze the basic structure of Database and Recognize the different views of the database.
  • Draw and Investigate Data Flow and Entity Relationship Diagrams
  • List Relational Data Models and Relational Algebra Operators
  • Use and Experiment common SQL Statements
  • Explain the terms Transaction Processing and Concurrency Control


Course Calendar

TopicLectureResourcePage
Introduction1Handouts9-16
Advantages of DBMS and its User2Handouts17-30
Database Architecture3, 4Handouts31-49
Detailed Diagrams and Database Design5Handouts50-62
Detailed DFD Diagrams6Handouts63-69
Entity-Relationship Data Model7Handouts70-79
Key and its different types8Handouts80-84
Relationships9Handouts85-90
Cardinality and Roles in Relationships10Handouts91-99
Extended Entity Relationship Diagram11Handouts100-109
Assignment No. 1
Practice Session of ER Data Model12Handouts110-117
E-R Diagram13Handouts118-123
Logical Database Design14Handouts124-131
Relations Keys15Handouts132-139
Cardinality Constraints16Handouts140-147
Relational Algebra17Handouts148-156
Quiz No. 1
Joins18Handouts157-163
Functional Dependancy & Normalization19Handouts164-168
Normalization20Handouts169-175
Normalization Summary21Handouts176-182
Data Volume and Usage Analysis22Handouts183-186
Mid term Examination
Physical Records and Denormalization23Handouts187-190
Partitioning, Replication and Structured Query Language (SQL)24Handouts191-195
Data Types and Rules of the Format25Handouts196-200
Data Definition Language (DDL)26Handouts201-205
Data Manipulation Language27Handouts206-209
Insert and Select Statements28Handouts210-214
Assignment No. 2
Where Clause and Operators (Not, Between, IN, Like)29Handouts215-219
Order By Clause, Having Clause, Functions30Handouts220-225
Joins31Handouts226-237
Application Programs32, 33Handouts238-254
Data Storage Concepts34Handouts255-259
File Organizations35Handouts260-264
Graded Discussion Board
Hashing36Handouts265-269
Indexes37, 38Handouts270-279
Quiz No. 2
Views39, 40, 41Handouts280-292
Transaction42Handouts293-301
Database Recovery43Handouts302-309
Concurrency Control44Handouts310-317
Locking45Handouts318-324
Final Term Examination
Note: This is tentative schedule and subject to change.
 
 
Back to Top