Syllabus
|
Course Code: MCA-20-23 Course Name: Advanced Data Base Systems |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | Database Systems Concepts and Architecture: Schema and Instances, DBMS architecture and Data Independence, Database languages and Interfaces, DBMS Functions and Component Modules. Entity Relationship Model: Entity Types, Entity Sets, Attributes & keys, Relationships Types & Instances, Roles and Structural Constraints, E-R Diagrams, Design of an E-R Database Schema. The Enhanced Entity-Relationship (EER) Model: Subclasses, Super classes, Inheritance, Specialization and Generalization. |
|
| 2 | SQL: Data Definition and Data Types, DDL, DML, and DCL, 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 Database Design: Functional Dependencies, Decomposition, Normal Forms Based on Primary Keys- (1NF, 2NF, 3NF, BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain Key Normal Form. |
|
| 3 | Query Processing and Optimization, Transaction Processing: Introduction to Transaction Processing, Transaction and System Concepts, Desirable Properties of Transactions, Concurrency Control Techniques: Two-Phase Locking Techniques, Timestamp Ordering, Serializability. Database Backup and Recovery: Recovery facilities, Recovery Techniques. |
|
| 4 | Databases for Advance Applications: Architecture for Parallel Database and Distributed Database, Active Database Concept and Triggers, Temporal Databases Concepts, Spatial and Multimedia Databases, Deductive Databases, Geographical Information System, Mobile Databases, Web Databases, XML Schema, Object- Based Databases, OLTP Vs. OLAP. |
|
