Back close

Course Detail

Course Name Database Management Systems
Course Code 18CA203
Program M. C. A., M. C. A. ( Offered at Mysuru Campus )
Semester One
Credits Four
Year Taught 2018
Degree Postgraduate (PG)
School School of Arts and Sciences, School of Engineering
Campus Kochi, Mysuru, Amritapuri


Introduction and the Relational Model: Introduction to DBMS- Data Models. Structure of Relational Databases- Relational Algebra Operations. SQL: Background- SQL Data Types and Schemas- Integrity Constraints– Data Definition- Basic Structure of SQL Queries- Set Operations- Aggregate Functions- Null Values.

Database Design: Overview of the Design Process- The Entity-Relationship Model– Constraints – Entity-Relationship Diagrams. Database Design– The E-R Model– Constraints- E-R Diagrams- Design Issues- Weak Entity Sets – Extended E-R Features– E-R Reduction to Relational Schemas. SQL: Nested Sub Queries- Complex Queries- Views- Join Relations – Authorization – Functions and Procedural Constructs. Relational Database Design: Features of Good Relational Designs- Atomic Domains and 1NF- Decomposition using Functional Dependencies (2NF) – 3NF, 4NF, BCNF- Functional Dependency Theory- Decomposition using Multi-valued Dependencies– PJNF and DKNF. Introduction to Transaction Management: Transactions-Concept- State-Atomicity and Durability- Concurrent Executions- Lock Based Protocols – Introduction to Deadlock Handling.

Query Evaluation and Optimization.

Text Books

  1. Silberschatz A, Korth H.F. and Sudharshan.S, “Database System Concepts”, Sixth Edition, Tata McGraw-Hill Publishing Company Limited, 2010.
  2. Elmasri.R and Navathe.S.B, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2010.
  3. Date C.J, “An Introduction to Database Systems”, Eighth Edition, Addison Wesley, 2003. (For SQL related topics).
  4. Ramakrishnan.R. andGehrke.J, “Database Management Systems”, Third Edition,Tata McGraw-Hill, 2003.

DISCLAIMER: The appearance of external links on this web site does not constitute endorsement by the School of Biotechnology/Amrita Vishwa Vidyapeetham or the information, products or services contained therein. For other than authorized activities, the Amrita Vishwa Vidyapeetham does not exercise any editorial control over the information you may find at these locations. These links are provided consistent with the stated purpose of this web site.

Admissions Apply Now