Database Management Systems Theory:

 CMSDSC509T/CMSMIN704T/CMSCOR404T:

Database Management Systems Theory: 45 Lectures

1. Introduction (4 Lectures)

Characteristics of database approach,

 data models  CLICK, 

database system architecture CLICK

and  data independence. CLICK

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

 Entity types, relationships, CLICK

 constraints. CLICK

3. Relation data model (15 Lectures)

Relational model concepts, 

relational constraints, 

relational algebra, CLICK

SQL queries. CLICK

4. Database design (12 Lectures)

Mapping ER/EER model to relational database,  CLICK

functional dependencies, CLICK

Lossless decomposition,  CLICK

Normal forms (up to BCNF). CLICK

5. Transaction Processing (3 Lectures)

ACID properties,  CLICK

concurrency control.CLICK

6. File Structure and Indexing (6 Lectures)

Operations on files, CLICK

 File of Unordered and ordered records, CLICK

overview of File organizations,

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

Multilevel indexing using B and B+ trees. CLICK

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.