| Course Code: CS302MH Course Name: Database Systems Prerequisites: Nil Syllabus: Pre-requisites: NIL Data Models: Data models with emphasis on the relational model; Algebra: Relational algebra; SQL: Basic SQL queries, constraints,Intermediate SQL queries; Database Desing: Database design with E-R model, From E-R model to relational database design; Relational Database Desing: Functional Dependencies, Normalization; Database application development: Stored procedures. Textbook: 1. R. Ramakrishnan and J. Gehrke, Database Management Systems, 3/e, McGraw Hill, 2003. 2. Hector Garcia-Molina Jeffrey and D. Ullman Jennifer Widom, Database Management Systems - The Complete Book, Pearson Prentice Hall, Second Edition. 3. Abraham Silberschatz, Henry F. Korth, S. Sudarshan , Database System Concepts,, Seventh Edition, McGraw Hill, Indian Edition 2021. |