Database Management Systems Theory:

 CMSDSC509T/CMSMIN704T/CMSCOR404T:

Database Management Systems Theory: 45 Lectures

1. Introduction (4 Lectures)

Characteristics of database approach, data models, database system architecture and data

independence.

2. Entity Relationship(ER) Modeling (5 Lectures)

 Entity types, relationships, constraints.

3. Relation data model (15 Lectures)

Relational model concepts, relational constraints, relational algebra, SQL queries.

4. Database design (12 Lectures)

Mapping ER/EER model to relational database, functional dependencies,

Lossless decomposition, Normal forms (up to BCNF).

5. Transaction Processing (3 Lectures)

ACID properties, concurrency control.

6. File Structure and Indexing (6 Lectures)

Operations on files, File of Unordered and ordered records, overview of File organizations,

Indexing structures for files( Primary index, secondary index, clustering index), Multilevel

indexing using B and B+ trees.

Text Books

1. R. Elmasri, S.B. Navathe, Fundamentals of Database Systems 6th Edition, Pearson Education, 2010.

2. R. Ramakrishanan, J. Gehrke, Database Management Systems 3rd Edition, McGraw-Hill, 2002.

Books Recommended:

1. A. Silberschatz, H.F. Korth, S. Sudarshan, Database System Concepts 6th Edition, McGraw Hill,

2010.

2. R. Elmasri, S.B. Navathe Database Systems Models, Languages, Design and application

Programming, 6th Edition, Pearson Education, 2013.