munotes®
Sign in
Home / Syllabus / B.E Artificial Intelligence and Machine Learning / Second Year AI ML / Semester 4 / Database Management System

B.E Artificial Intelligence and Machine Learning Database Management System Syllabus - Mumbai University

This is the Second Year AI-ML syllabus under NEP 2020, in force from the academic year 2025-26. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Database-Management-System.pdf
Semester 4 · Second Year AI-ML · 3 credits · 100 marks

Loading syllabus...

Syllabus for Database Management System

Semester 4 · Second Year AI-ML · 3 credits · 100 marks

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 Managementand 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. (Artificial Intelligence and Machine Learning) 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.8 (R-A) B.E. (Artificial Intelligence and Machine Learning) Sem I & II (Revised, NEP 2020) NEP 2020 syllabus Read full PDF Read
PDF 6.21 (N) B.E. (Artificial Intelligence and Machine Learning) Sem III & IV (NEP 2020) NEP 2020 syllabus Read full PDF Read
PDF 6.42 (R) B.E. (Artificial Intelligence and Machine Learning) Third Year, Sem V & VI (REV-2019 'C' Scheme) REV-2019 'C' Scheme syllabus Read full PDF Read
PDF B.E. (Artificial Intelligence and Machine Learning) Fourth Year, Sem VII & VIII (REV-2019 'C' Scheme) REV-2019 'C' Scheme syllabus Read full PDF Read
Report or request
Done!