UNIT I : CONCEPTUAL DATA MODELLING

Database environment -Database  system development lifecycle -Requirements collection -Database design -Entity -Relationship model -Enhanced -Er model -UML class diagrams .

UNIT  II: RELATIONAL MODEL AND SQL

Relational model concepts -Integrity constraints -SQL Data manipulation -SQL Data definition -Views -SQL programming .

UNIT III: RELATIONAL DATABASE DESIGN AND NORMALIZATION

ER and EER -to -Relational mapping -Update anomalies _Functional dependences -Inference rules -Minimal cover -properties of relational decomposition -Normalization (upto BCNF).

UNIT IV TRANSACTION MANAGEMENT

Transaction concepts -Properties -Schedules -Serializability -Concurrency Control -Two -Phase Iocking techniques.

UNIT V: OBJECT RELATIONAL AND NO-SQL DATABASES

Mapping EER to ODB schema -Object identifier -reference type -rowtype -UDts-Subtypes and supertype -user defined routined -Collection type -object query Language ; No-SQL :CAP theorem -Document -based : MongoDB data and CRUD operations; Column -based :Hbase date model and CRUD Operations.