Syllabus Database Design and Management - (AD3391) UNIT I CONCEPTUAL DATA MODELING Database environment - Database system development lifecycle - Requirements collection - Database design - Entity-Relationship model - Enhanced-ER model - UML class diagrams. (Chapter - 1) UNIT II RELATIONAL MODEL AND SQL Relational model concepts - Integrity constraints - SQL Data manipulation - SQL Data definition - Views - SQL programming. (Chapter - 2) UNIT III RELATIONAL DATABASE DESIGN AND NORMALIZATION ER and EER-to-Relational mapping - Update anomalies - Functional dependencies - Inference rules - Minimal cover - Properties of relational decomposition - Normalization (upto BCNF). (Chapter - 3) UNIT IV TRANSACTION MANAGEMENT Transaction concepts - properties - Schedules - Serializability - Concurrency Control - Two-phase locking techniques. (Chapter - 4) UNIT V OBJECT RELATIONAL AND NO-SQL DATABASES Mapping EER to ODB schema - Object identifier - reference types - rowtypes - UDTs - Subtypes and supertypes - user-defined routines - Collection types - Object Query Language; No-SQL: CAP theorem - Document-based: MongoDB data model and CRUD operations; Column-based: Hbase data model and CRUD operations. (Chapter - 5)
