Database Management System

Database, Database Management System, Database Users, and Benefits of Databases;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 DatabaseManagement Systems.

Using High-Level Conceptual Data Models for Database Design; Entity Types, EntitySets, Attributes, and Keys; Relationship Types, Relationship Sets, Roles, and StructuralConstraints; Weak Entity Types; ER Diagrams, Naming Conventions, and Design Issues;Relationship Types of Degree Higher Than Two; Concepts of Specialization andGeneralization; Constraints and Characteristics of Specialization and Generalization;Converting ER Schema to Relational Schema; Structure of the Relational Database.

Data Definition and Data Types; Specifying Constraints; Basic Retrieval Queries;Complex Retrieval Queries; INSERT, DELETE, and UPDATE Statements; Views

Informal Design Guidelines for Relational Schemas; Functional Dependencies; NormalForms Based on Primary Keys; General Definitions of Second and Third Normal Forms;Boyce-Codd Normal Form; Multivalued Dependency and Fourth Normal Form;Properties of Relational Decomposition.

Introduction to Transaction Processing; Transaction and System Concepts; DesirableProperties of Transactions; Serializable Schedule; Two-Phase Locking and Timestamp Ordering Concurrency Control Techniques.

Recovery Concepts; NO-UNDO/REDO Recovery Based on Deferred Update; RecoveryTechnique Based on Immediate Update; Shadow Paging; Database Backup and Recoveryfrom Catastrophic Failures.

Database Performance Tuning; Database Security; Concept of Parallel and Distributed Databases; Concept of Data Warehousing and Data Mining, BigData, and NoSQL databases.