BIIT
| Data Base Management System Course for All Classes |
||
|---|---|---|
| Sr. No. | Topic | Hours |
| 1 | Introduction: Characteristics of database approach, data models, DBMS architecture and data independence. | 5 |
| 2 | E-R Modeling: Entity types, Entity set, attribute and key, relationships, relation types, roles and structural constraints, weak entities, enhanced E-R and object modeling, Sub classes; Super classes, inheritance, specialization and generalization. | 5 |
| 3 | File Organization: Indexed sequential access files; implementation using B & B++ trees, hashing, hashing functions, collision resolution, extendible hashing, dynamic hashing approach implementation and performance. | 5 |
| 4 | Relational Data Model: Relational model concepts, relational constraints, relational algebra | 5 |
| 5 | EER and ER to relational mapping: Data base design using EER to relational language. | 5 |
| 6 | Data Normalization: Functional Dependencies, Normal form up to 3rd normal form. | 5 |
| 7 | Concurrency Control: Transaction processing, locking techniques and associated, database recovery, security and authorization. Recovery Techniques, Database Security | 5 |
| 8 | Structured Query Language: SQL queries, programming using SQL. | 7 |
| Total Hours | 42 | |
