munotes®
Sign in
Home / Syllabus / B.E. (Computer Engineering) / Second Year CE / Semester 4 / Database Management System

B.E. (Computer Engineering) Database Management System Syllabus - Mumbai University 2026

The University has moved this degree onto NEP 2020 one year at a time. The first and second years are NEP 2020 syllabi; the third and fourth years are still examined on the REV-2019 'C' Scheme, which is what the University sets for them this year.

Database-Management-System.pdf
Semester 4 · Second Year CE · 3 credits

Loading syllabus...

Syllabus for Database Management System

Semester 4 · Second Year CE · 3 credits

Module 0: Prerequisite

  • Basic knowledge of Data structure, Fundamentals of computer system

Module I: Introduction to Database and Data Modeling

  • Introduction: Definitions and application, Characteristics of databases, DBMS architecture, ACID Properties The Entity-Relationship (ER) Model : Entity types: Weak and strong entity sets, Entity sets, Types of Attributes, Keys, Relationship constraints: Cardinality and Participation, Extended Entity-Relationship (EER) Model: Generalization, Specialization and Aggregation Self-learning Topics: Design an ER model for any real time case study.

Module II: Relational Model and Relational Algebra

  • Introduction to the Relational Model, relational schema and concept of keys. Mapping the ER and EER Model to the Relational Model, Relational Algebra- operators (Selection(σ),Projection(π),Union(∪),Difference (−),CartesianProduct(×),Join(𝔚), Intersection (∩),Rename (ρ)), Relational Algebra Queries Self-learning Topics: Practice writing queries to perform common database tasks (e.g., selecting data, joining tables

Module III: Structured Query Language (SQL)

  • Overview of SQL, Data Definition Commands, Integrity constraints: key constraints, Domain Constraints, Referential integrity, check constraints, Data Manipulation commands, Data Control commands, Transaction Control Commands. aggregate function-group by, having, order by, joins, Nested and complex queries, Views in SQL, Set and string operations, Triggers, Introduction to Pl/SQL Block Structure Self-learning Topics: LeetCode (SQL practice problems), HackerRank (SQL challenges)

Module IV: Database Normalization

  • Pitfalls in relational database designs, Concept of normalization, Function Dependencies, FD closure, First Normal Form, 2NF, 3NF, BCNF, 4NF. Self-learning Topics: Consider any real time application and normalization upto 3NF/BCNF

Module V: Transaction Management and Concurrency Control

  • Transaction concept, Transaction states, Concurrent Executions, Serializability-Conflict and View, Concurrency Control: Lock-based, Timestamp-based protocols, Recovery System: log-based recovery, Introduction to Deadlock handling Self-learning Topics: SQL challenges related to transactions and concurrency

Module VI: Introduction to Modern databases

  • Recent trends in the industry, Introduction of Cloud Database, Introduction of Distributed Database, Introduction to NOSQL Database and Object-Oriented Databases Self-learning Topics: Learn about emerging database technologies. Explore different NoSQL types. Learn how object-oriented programming concepts like objects and inheritance are applied to database management systems .

Text Books

  • 1 Elmasri and Navathe, Fundamentals of Database Systems, 7thEdition, Pearson Education
  • 2 Korth, Slberchatz, Sudarshan, Database System Concepts, 7th Edition, McGraw Hill
  • 3 Raghu Ramkrishnan and Johannes Gehrke, Database Management Systems, TMH
  • 4 RajkumarBuyya, Christian Vecchiola, S ThamaraiSelvi, “Mastering Cloud Computing”, Tata McGraw-Hill Education
  • 1 Peter Rob and Carlos Coronel, Database Systems Design, Implementation and Management, Thomson Learning, 5th Edition.
  • 2 Dr. P.S. Deshpande, SQL and PL/SQL for Oracle 10g, Black Book, Dreamtech Press.
  • 3 G. K. Gupta, Database Management Systems, McGraw Hill, 2012

Reproduced from the University of Mumbai syllabus for B.E. (Computer Engineering) under NEP 2020, in force from the academic year 2025-26. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF 7.9 (R-A) B.E. (Computer Engineering) Sem I & II (Revised, NEP 2020) NEP 2020 syllabus Read full PDF Read
PDF 6.24 (N) B.E. (Computer Engineering) Sem III & IV (NEP 2020) NEP 2020 syllabus Read full PDF Read
PDF 6.15 B.E. (Computer Engineering) Third Year, Sem V & VI (REV-2019 'C' Scheme) REV-2019 'C' Scheme syllabus Read full PDF Read
PDF 6.41 (R) B.E. (Computer Engineering) Fourth Year, Sem VII & VIII (REV-2019 'C' Scheme) REV-2019 'C' Scheme syllabus Read full PDF Read
Report or request
Done!