munotes®
Sign in
Home / Syllabus / B.E. (Artificial Intelligence and Data Science) / SY BE AI and DS / Semester 4 / Database Management System

B.E. (Artificial Intelligence and Data Science) Database Management System Syllabus - Mumbai University 2026

This is the SY BE AI and DS syllabus under NEP 2020, in force from the academic year 2025-26. The third and fourth years of this degree are still taught on the earlier CBCS REV-2019 'C' Scheme, because the University has published no NEP syllabus for Semesters V to VIII of any engineering branch.

Database Management System.pdf
Semester 4 · SY BE AI and DS · NEP 2020

Loading syllabus...

Syllabus for Database Management System

Semester 4 · SY BE AI and DS · NEP 2020

Module 0: Prerequisite

  • Basic knowledge of Data structure, Fundamentals of computer system

Module I: Introduction to Database and Data Modeling 08 hours

  • 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 05 hours

  • 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(∪),Differe nce (−),CartesianProduct(×),Join(W), 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) 10 hours

  • 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 5 hours

  • 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 7 hours

  • 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 4 hours

  • 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, 7thEdition, 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

Reference Books

  • 1 Peter Rob and Carlos Coronel, Database Systems Design, Implementation and Management, Thomson Learning, 5thEdition.
  • 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

Online References

  • Sr. No. Website Name
  • 1 NPTEL Lecture Series: Database Management system By Prof. Partha Pratim Das, Prof. Samiran Chattopadhyay | IIT Kharagpur
  • 2 https://www.classcentral.com/course/swayam-database-management-system-9914
  • 3 https://www.mooc-list.com/tags/dbms
  • 4 W3Schools: SQL tutorials

Reproduced from the University of Mumbai syllabus for B.E. (Artificial Intelligence and Data Science), item 6.20 (N), under NEP 2020, in force from the academic year 2025-26. Wording, module numbering and hours are as printed in that syllabus.

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 B.E. Artificial Intelligence and Data Science - First Year, Semester I and II - NEP 2020 - Item 7.7 (R-A) NEP 2020, Semesters I and II, in force from 2024-25 Read full PDF Read
PDF B.E. Artificial Intelligence and Data Science - Second Year, Semester III and IV - NEP 2020 - Item 6.20 (N) NEP 2020, Semesters III and IV, in force from 2025-26 Read full PDF Read
PDF B.E. Artificial Intelligence and Data Science - Third Year, Semester V and VI - CBCS REV-2019 C Scheme - Item 6.42 (R) CBCS REV-2019 'C' Scheme, Semesters V and VI, in force from 2022-23 Read full PDF Read
PDF B.E. Artificial Intelligence and Data Science - Fourth Year, Semester VII and VIII - CBCS REV-2019 C Scheme - Item 6.12 (N) CBCS REV-2019 'C' Scheme, Semesters VII and VIII, in force from 2023-24 Read full PDF Read
Report or request
Done!