Database Management System syllabus

Database Management System

• 1 Database Concepts and Architecture (5 LHs)

  • Databases, DBMS, users and benefits
  • Data models, schemas and instances
  • Three-schema architecture and data independence
  • Database languages, interfaces and system environment
  • Centralized and client/server DBMS architectures; DBMS classification
• 2 Data Modeling Using Entity-Relational Model and Relational Model (10 LHs)

  • Conceptual data models for database design
  • Entity types, sets, attributes and keys
  • Relationship types, sets, roles and structural constraints
  • Weak entities and ER diagrams
  • Higher-degree relationships; specialization and generalization
  • ER-to-relational schema conversion and relational database structure
• 3 SQL (12 LHs)

  • Data definition, data types and constraints
  • Basic and complex retrieval queries
  • INSERT, DELETE and UPDATE statements
  • Views
• 4 Relational Database Design (10 LHs)

  • Informal relational schema design guidelines
  • Functional dependencies
  • Normal forms based on primary keys; second and third normal forms
  • Boyce-Codd Normal Form
  • Properties of relational decomposition
• 5 Transaction Processing and Concurrency Control, and Recovery (7 LHs)

  • Transaction and system concepts
  • Desirable transaction properties
  • Serializable schedules
  • Two-phase locking and timestamp ordering
• 6 Database Recovery Techniques (4 LHs)

  • Recovery concepts
  • NO-UNDO/REDO recovery based on deferred update
  • Recovery based on immediate update
  • Shadow paging
  • Backup and recovery from catastrophic failures
• 7 Laboratory Works

  • Create databases and tables with SQL
  • Insert, delete and update data
  • Write SELECT queries