Database Management System (BIT254CO)
DBMS architecture, relational model, SQL, normalization, database security, and transaction/query processing.
Unit 1: Introduction
Unit 2: Database System Concepts and Architecture (E-R model)
Unit 3: Relational Model
Unit 4: SQL (incl. PL/SQL)
Unit 5: Integrity Constraints
Unit 6: Normalization (1NF-5NF, BCNF)
Unit 7: Database Security
Unit 8: Transaction and Query Processing (ACID, concurrency, WAL)
Unit 9: Backup and Recovery