Historical perspective - Files versus database systems - Architecture - E-R model - Security and Integrity - Data models.
The relation - Keys - Constraints - Relational algebra and Calculus - Queries - Programming and triggers.
Disks and Files - file organizations - Indexing - Tree structured indexing - Hash Based indexing.
External sorting - Query evaluation - Query optimization - Schema refinement and normalization - Physical database design and tuning – Concurrency control.
Definition of NOSQL- NOSQL Storage Architecture, CRUD operations with MongoDB, Querying, Modifying andManaging NOSQL Data stores, Indexing and ordering datasets
Reference Book:
1.Ramez Elmasri, Shamkant B Navathe, “Fundamentals of database systems”, Pearson Education, 5th edition, 2009. (Unit I) 2.Ganesh Chandra Deka, “NoSQL: Database for Storage and Retrieval of Data in Cloud”, CRC Process, 2017 (Unit V)
Text Book:
1.Raghu RamaKrishnan and Johannes Gehrke, “Database Management Systems”, McGraw Hill International Editions, 2000. (Unit I, II, III, IV & V) 2.C. J. Date, “An Introduction to Database Systems”, Seventh Edition, Addison Wesley, 1997. (Unit I & II) 3.Abraham Silberschatz, Henry. F. Korth and S. Sudharshan, “Database system Concepts”, Third Edition, Tata McGraw Hill, 1997. (Unit III, IV & V)
