DATABASE DESIGN AND MANAGEMENT

320 224

First Edition :July 2023

ISBN :978-93-95254-96-0

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.

 

 

Reviews

There are no reviews yet.

Be the first to review “DATABASE DESIGN AND MANAGEMENT”

Your email address will not be published. Required fields are marked *