Purpose of Database System -– Views of data – Data models, Database Management system - Threeschema 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 StudiesOracle: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-Installing and Set up, 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. 4 S.K.Singh, “Database Systems Concepts, Design and Applications”, First Edition,Pearson Education, 2009.(Unit I,II,V)
Text Book:
1 Abraham Silberschatz, Henry F. Korth, S. Sudharshan, ―Database System Conceptsǁ, Sixth Edition, Tata McGraw Hill, 2011. 2. RamezElmasri, Shamkant B. Navathe, ―Fundamentals of Database Systemsǁ, Sixth Edition, Pearson Education, 2011.