Syllabus
|
Course Code: MT-CSE-20-13 Course Name: Elective- I - (iv) 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, Constraints and characteristics of 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: Query Processing, Query Decomposition, Stages of Query Processing, Query Tree, Using Heuristics in Query Optimization, Semantic Query 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 | Object Model: Overview of Object-Oriented concepts, Object identity, Object structure, Type constructors, Databases for Advance Applications: Architecture for Parallel Database, I/O Parallelism, Interquery Parallelism, Intraquery Parallelism, Active Database Concept, Temporal Databases Concepts, Spatial and Multimedia Databases, XML Schema, XQuery and Approaches for XML query processing. | |
