B.E Artificial Intelligence and Machine Learning Database Management System Lab 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.
Loading syllabus...
Syllabus for Database Management System Lab
Module 1
- Identify the case study and detail statement of problem. Design an Entity Relationship (ER) / Extended Entity-Relationship (EER) Model.
Module 2: Mapping ER/EER to Relational schema model.
Module 3
- Create a database using Data Definition Language (DDL) and apply integrity constraints for the specified System
Module 4: Apply DML Commands for the specified system
Module 5: Perform Simple queries, string manipulation operations and aggregate functions.
Module 6: Implement various Join operations.
Module 7: Perform Nested and Complex queries
Module 8: Perform DCL and TCL commands
Module 9: Implement procedure and functions
Module 10: Implementation of Views and Triggers.
Module 11: Implementation and demonstration of Transaction and Concurrency control techniques using locks.
Module 12: Mini project (Design simple GUI and Backend Connectivity)
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.