Database Management System

• Database Concepts and Architecture
  • Introduction to Database
  • Database Users and Administrator
  • Data Models, Schemas, and Instances
  • Three-Schema Architecture and Data Independence
  • Database Languages and Interfaces
  • The Database System Environment
  • Centralized and Client/Server Architectures for DBMSs
  • Classification of Database Management Systems
• Data Modelling Using Entity-Relational Model and Relational Model
  • Introduction to Entity-Relational Model and Relational Model
  • Entity, Entity Types and Entity Sets
  • Attributes and Types of Attributes
  • Keys in DBMS
  • Relationship Types and Relationship Sets
  • Structural Constraints in ER
  • Concepts of Generalization and Specialization
• The Relational Algebra and Relational Calculus
  • Introduction
  • Unary Relational Operations
  • Relational Algebra Operations from Set Theory
  • Binary Relational Operations
  • Additional Relational Operations
  • The Tuple and Domain Relational Calculus
• Database Normalization
  • Introduction to Normalization
  • Introduction to Functional Dependency
  • Introduction to Decomposition
• SQL
  • Introduction to SQL
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
• Transaction Processing, Concurrency Control and Recovery Techniques
  • Introduction to Transaction Processing
  • Serializability
  • Introduction to Concurrency Control
  • Concurrency Control Techniques
  • Introduction to Database Recovery
  • Recovery Based on Deferred Update
  • Recovery Technique Based on Immediate Update
  • Shadow Paging
  • Database Backup and Recovery from Catastrophic Failures
• Advanced Topics
  • Database Performance Tuning
  • Database Security
  • Concept of Parallel and Distributed Databases
  • Concept of Data Warehousing and Data Mining
  • Big Data and NoSQL Databases
• Model Question Solution – DBMS