Syllabus
|
Course Code: MS-20-12 Course Name: Advanced Database Systems |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | Database System Concepts and Architecture: Three - Schema Architecture and Data Independence, Entity Relationship Model: Entity Types, Entity Sets, Attributes & keys, Relationships Types & instances ER Diagrams, Naming conventions and Design Issues. Relational Model Constraints, Enhanced Entity Relationship Model: Subclasses, Super classes, Inheritance, Specialization and Generalization. |
|
| 2 | SQL: Data Definition and Data Types, DDL, DML, and DCL, Join Operations, Views & Queries in SQL, Specifying Constraints & Indexes in SQL. PL/SQL: Architecture of PL/SQL, Basic Elements of PL/SQL, PL/SQL Transactions, Cursors and Triggers. Relational Algebra: Unary and Binary Relational Operations |
|
| 3 | Functional Dependencies, Normal Forms Based on Primary Keys- (1NF, 2NF, 3NF, BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain Key Normal Form. Query Processing and Optimization, Introduction to Transaction Processing, and Desirable Properties of Transactions, Concurrency Control Techniques, Database Backup and Recovery. |
|
| 4 | Overview Object Oriented Database Model, Databases for Advance Applications: Architecture for Parallel Database and Distributed Database, Active Database Concept and Triggers, Temporal Databases Concepts, Spatial and Multimedia Databases, Geographical Information System, Mobile Databases, Web Databases, XML Schema, XML Query |
|
