UNIT 1:
Purpose of Database System
Three-schema architecture of DBMS, Components of DBMS
Entity –Relationship Model
motivation, entities, entity types, attributes, relationships
E/R diagram notations, Examples
Purpose of Database System
UNIT 2:
keys, referential integrity and foreign keys
Relational Algebra - SQL fundamentals
- Introduction, data definition in SQL, table, key and foreign key definitions
Advanced SQL features -Embedded SQL- Dynamic SQL
CASE Studies- Oracle:Database Design and Querying Tools
UNIT 3:
First, Second, Third Normal Forms
Dependencies and Normal forms
, Dependency Preservation-Boyce/Codd Normal Form
Multivalued Dependencies and Fourth Normal Form
UNIT 4:
ACID Properties – Schedules
Need for Concurrency – Locking Protocols
UNIT 5:
Static Hashing – Dynamic Hashing
Query Processing Overview
File organization-Indexing and Hashing
Indexing and ordering CASE Studies- Oracle,DB2: Storage and Indexing
