The course covers different concepts of database management systems including databasesystem concepts and architecture, ER diagram, relational model, SQL, normalization, transactionprocessing, concurrency control, and database recovery. This course also covers some advancedconcepts of databases such as performance tuning, security, parallel and distributed database,data warehousing, data mining and bigdata.

The main objective of this course is to introduce different concepts of database, data modeling with ER diagram, features SQL, normalization, transaction processing, concurrency control, database recovery and some advanced database topics.

Unit 1: Database Concepts and Architecture 4 LHs
Database, Database Management System, Database Users, and Benefits of Databases;Data Models, Schemas, and Instances; Three-Schema Architecture and DataIndependence; Database Languages and Interfaces; the Database System Environment;Centralized and Client/Server Architectures for DBMSs; Classification of DatabaseManagement Systems.

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

 Unit 3: SQL    12 LHs
Data Definition and Data Types; Specifying Constraints; Basic Retrieval Queries;Complex Retrieval Queries; INSERT, DELETE, and UPDATE Statements; Views.

Unit 4: Relational Database Design 8 LHs
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.

Unit 5: Transaction Processing and Concurrency Control, and Recovery 8 LHs
Introduction to Transaction Processing; Transaction and System Concepts; DesirableProperties of Transactions; Serializable Schedule; Two-Phase Locking and TimestampOrdering Concurrency Control Techniques.

Unit 6: Database Recovery Techniques 4 LHs
Recovery Concepts; NO-UNDO/REDO Recovery Based on Deferred Update; RecoveryTechnique Based on Immediate Update; Shadow Paging; Database Backup and Recovery
from Catastrophic Failures.

Unit 7: Advanced Topics 4 LHs
Database Performance Tuning; Database Security; Concept of Parallel and Distributed Databases;Concept of Data Warehousing and Data Mining, BigData, and NoSQL databases.