CMSACOR10T: Database Management Systems Theory: 60 Lectures 1. Introduction (6 Lectures) Characteristics of database approach, data models, database system architecture and data
independence. 2. Entity Relationship(ER) Modeling (8 Lectures) Entity types, relationships, constraints. 3. Relation data model (20 Lectures) Relational model concepts, relational constraints, relational algebra, SQLqueries 4. Database design (15 Lectures) Mapping ER/EER model to relational database, functional dependencies,Lossless decomposition, Normal forms (upto BCNF). 5. Transaction Processing (3 Lectures) ACID properties, concurrency control 6. File Structure and Indexing (8 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.
independence. 2. Entity Relationship(ER) Modeling (8 Lectures) Entity types, relationships, constraints. 3. Relation data model (20 Lectures) Relational model concepts, relational constraints, relational algebra, SQLqueries 4. Database design (15 Lectures) Mapping ER/EER model to relational database, functional dependencies,Lossless decomposition, Normal forms (upto BCNF). 5. Transaction Processing (3 Lectures) ACID properties, concurrency control 6. File Structure and Indexing (8 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.
No comments:
Post a Comment