Purpose of Database System -– Views of data – Data models, Database Management system - Three-schema architecture of DBMS, Components of DBMS. Entity –Relationship Model - Conceptual data modeling - motivation, entities, entity types, attributes, relationships, relationship types, E/R diagram notations, Examples.
Relational Data Model - keys, referential integrity and foreign keys, Relational Algebra - SQL fundamentals- Introduction, data definition in SQL, table, key and foreign key definitions, update behaviors-Intermediate SQL-Advanced SQL features -Embedded SQL- Dynamic SQL, CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions.
Dependencies and Normal forms - Functional Dependencies, Armstrong's axioms for FD's, closure of a set of FD's, minimal covers- Non- loss decomposition-First, Second, Third Normal Forms, Dependency Preservation-Boyce/Codd Normal Form-Multivalued Dependencies and Fourth Normal Form- Join Dependencies and Fifth Normal Form.
Transaction Concepts – ACID Properties – Schedules – Serializability – Concurrency Control – Need for Concurrency – Locking Protocols – Two Phase Locking – Deadlock – Transaction Recovery – Save Points – Isolation Levels – SQL Facilities for Concurrency and Recovery.
Data Storage and Indexes – RAID- File organization-Indexing and Hashing –Ordered Indices – B+ tree Index Files – B tree Index Files – Static Hashing – Dynamic Hashing. Query Processing Overview. MongoDB, Database creation and manipulation, Indexing and ordering,CASE Studies- Oracle,DB2: Storage and Indexing.
Reference Book:
1.C.J.Date, A.Kannan, S.Swamynathan, ―An Introduction to Database Systems, Eighth Edition, Pearson Education, 2006. 2.Raghu Ramakrishnan, ―Database Management Systems‖, Fourth Edition, McGraw-Hill College Publications, 2015. 3.G.K.Gupta,”Database Management Systems, Tata McGraw Hill, 2011.
Text Book:
1.Abraham Silberschatz, Henry F. Korth, S. Sudharshan, - Database System Concepts‖, Sixth Edition, Tata McGraw Hill, 2011. 2.Ramez Elmasri, Shamkant B. Navathe, ―Fundamentals of Database Systems, Sixth Edition, Pearson Education, 2011.