File systems versus Database systems – Data Models – DBMS Architecture – Data Independence – Data Modeling using Entity – Relationship Model –E-R Modeling.
Relational Model Concepts – Relational Algebra – SQL – Basic Queries – Complex SQL Queries – Views – Constraints.
Dependencies – Non-loss Decomposition – First, Second, Third Normal Forms, – Boyce/Codd Normal Form – Multi-valued Dependencies and Fourth Normal Form – Join Dependencies and Fifth Normal Form.
Complex Queries, Triggers, Views, and Schema Modification More Complex SQL Retrieval Queries, Specifying Constraints as Assertions and Actions as Triggers, Views (Virtual Tables) in SQL, Schema Change Statements in SQL.
Definition of NOSQL- NOSQL Storage Architecture, CRUD operations with MongoDB, Querying, Modifying and Managing NOSQL Data stores, Indexing and ordering datasets
Reference Book:
1. C. J. Date, “An Introduction to Database Systemsâ€, Seventh Edition, Addison Wesley, 1997. 2. Abraham Silberschatz, Henry. F. Korth and S. Sudharshan, “Database system Conceptsâ€, Third Edition, Tata McGraw Hill, 1997. 3. Hector Garcia- Molina, Jeffrey D Jennifer widom, “Database Systems – The complete bookâ€, Pearson Education, 2nd edition, 2008.
Text Book:
1. Raghu RamaKrishnan and Johannes Gehrke, “Database Management Systemsâ€, McGraw Hill International Editions, 2000. 2. Author Shakuntala Gupta Edward, NavinSabharwal, “Practical MongoDB, Architecture, Developing and Administrating MongoDBâ€, Apress, 2015
