Text book:
UNIT 1:
Purpose of Database system
Data models, Database Management system
Threeschema architecture of DBMS
E/R diagram notations, Examples
motivation, entities, entity types, attributes, relationships, relationship types
UNIT 2:
Relational Data Model - keys, referential integrity and foreign keys
Relational Data Model - keys, referential integrity and foreign keys
SQL fundamentals- Introduction
SQL fundamentals- Introduction
Oracle:Database Design and Querying Tools; SQL Variations and Extensions
UNIT 3:
Dependencies and Normal forms
minimal covers-Non- loss decomposition
First,Second,Third Normal Forms
UNIT 4:
Transaction Concepts – ACID Properties
Schedules – Serializability
Concurrency Control – Need for Concurrency
Deadlock – Transaction Recovery
UNIT 5:
Data Storage and Indexes – RAID
File organization-Indexing and Hashing –Ordered Indices
MongoDB-Installing and Set up