3 Review(s)

UNIT I CONCEPTUAL DATA MODELINGDatabase 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 SQLRelational model concepts - Integrity constraints - SQL Data manipulation - SQL Data definition - Views - SQL programming. (Chapter - 2)UNIT IIIRELATIONAL DATABASE DESIGN AND NORMALIZATIONER 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 MANAGEMENTTransaction concepts - properties - Schedules - Serializability - Concurrency Control - Two-phase locking techniques. (Chapter - 4)UNIT V OBJECT RELATIONAL AND NO-SQL DATABASESMapping 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)