Unit 1
Syllabus of DBMS
Unit 1
Introduction: Database System Concepts and Architecture: Three - Schema Architecture and Data Independence.
Enhanced Entity Relationship Model: Introduction to ER Model, Enhanced ER tools, Subclasses, Super class, and Inheritance, Specialization and Generalization, Constraints and Characteristics of Specialization and Generalization, Converting EER diagram to tables.
Introduction to Relational Model: Relational Algebra Operations, Basic Queries
Unit 2:
Query Processing, Optimization & Database Tuning: Heuristics for Query Optimizations, Measures of Query Cost, Evaluation of Expression, Transformation of Relational Expressions, Physical Database Design In Relational Databases, Factors that Influence Physical Database Design, Physical Database Design Decisions, Database Tuning In Relational Systems.
Functional dependency theory and normalization: Functional Dependencies and normal forms based on functional dependencies, Multi value dependency and 4NF,Join Dependency and 5NF
Unit 3:
SQL Advanced concepts: Basic SQL Queries: DDL, DML, and DCL, Join Operations, Views & Queries in SQL, Specifying Constraints & Indexes in SQL, Assertion and views, PL/SQL: Architecture of PL/SQL, Basic Elements of PL/SQL, PL/SQL Transactions, Cursors, Triggers and stored procedures, Embedded SQL, dynamic SQL, Advanced Features of SQL
Unit 4:
Transaction Management and Recovery: Advanced feature of Transactions, Enhanced Lock Based and timestamp based Protocols, Multiple Granularity, Multi-version Schemes, Deadlock Handling, Weak Levels of Consistency, Recovery and Atomicity, Recovery with Concurrent Transaction, Buffer Management, Advanced Recovery Techniques
Database Security :Levels of database security, Access control, Multilevel security.
Unit 5:
Parallel and Distributed Databases Introduction to Parallel Databases: Architectures For Parallel Databases, Parallel Query Evaluation
Introduction to Distributed Databases: Centralised versus non centralized Databases, Homogeneous and Heterogeneous DDBMS and their comparison, Functions and Architecture, Distributed database design, Query processing in DDBMS, Distributed concurrency management, Deadlock management