Week - 1 |
Introduction: Basic consepts of DBMS. |
Week - 2 |
Data models, schemas, and instances. DBMS architecture. |
Week - 3 |
Data modeling using Entity-Relationship model. Examples. |
Week - 4 |
Record storage and file organization methods. |
Week - 5 |
Operations on files. Hashing techniques. |
Week - 6 |
Operations on files. Hashing techniques. |
Week - 7 |
Relational model concepts and Relationel algebra. |
Week - 8 |
The structure of SQL. Data definition, constrains, and schema changes in SQL. |
Week - 9 |
Creating queries in SQL. Examples. |
Week - 10 |
Functional dependecies and normalization for relational DBs. |
Week - 11 |
Functional dependecies and normalization for relational DBs. |
Week - 12 |
Query processing and transaction processing concepts. |
Week - 13 |
Query processing. |
Week - 14 |
Distributed databases and Client-Server architecture. |