UNIT 1:
Views of data , Data models
Purpose of Database System
Database Management system , Three schema architecture of DBMS
Database Management system , Three schema architecture of DBMS
Entity Relationship Model
Conceptual data modeling - motivation
Entities, entity types, attributes
Entities, entity types, attributes
Relationships, relationship types
UNIT 2:
Relational Data Model , keys, referential integrity and foreign keys
SQL fundamentals , Introduction
data definition in SQL, table, key and foreign key definitions, update behaviors
Views, Tiggers, Joins, Constraints, Stored Procedure
UNIT 3:
Dependencies and Normal forms
Armstrong's axioms for FD's
closure of a set of FD's
minimal covers,Nonloss decomposition
UNIT 4:
Transaction Concepts – ACID Properties
Transaction Concepts – ACID Properties
Schedules – Serializability
Schedules – Serializability
Concurrency Control – Need for Concurrency
Deadlock – Transaction Recovery
UNIT 5:
Data Storage and Indexes – RAID
Data Storage and Indexes – RAID
File organization-Indexing and Hashing –Ordered Indices
Static Hashing – Dynamic Hashing
Query Processing Overview
Algorithm for sorting basics of MongoDB
Algorithm for selection basics of MongoDB