BAMU · Third Year B.E./B.Tech Artificial Intelligence and Machine Learning · NEP 2020
Database Management System
PCCT-1 · Semester V · 3 credits · CIA 40 + SEE 60
Module 1: Introduction to DBMS; Relational Database Concepts
15 hoursPurpose and advantages of a DBMS, data models, database users, architecture, schemas, instances and the three-level architecture; the relational model, relational algebra (select, project, join, union), SQL DDL, DML, DCL and TCL, constraints and keys.
Examined in the 60-mark end-semester paper
- Purpose of a DBMS
- DBMS architecture and data models
- Three-schema architecture, schemas and instances
- Relational model and Codd's rules
- Relational algebra
- DDL, DML, DCL and TCL
- Integrity constraints
Module 2: Database Design and ER Modelling; Normalisation
15 hoursEntities, attributes, relationships and cardinality, ER diagrams for a library and a college admission system, mapping ER models to relations; functional dependency, 1NF, 2NF, 3NF and BCNF, lossless join and dependency preservation.
Examined in the 60-mark end-semester paper
- ER model and ER diagrams
- Converting ER diagrams to tables
- Functional dependencies
- Normalisation: 1NF to BCNF
- Lossless join and dependency preservation
Module 3: Advanced SQL and PL/SQL; Introduction to NoSQL
15 hoursJoins, subqueries, aggregate functions, GROUP BY and HAVING, views, indexes, procedures, functions, triggers and exception handling; the need for NoSQL, its types, MongoDB architecture and CRUD, and SQL versus NoSQL.
Examined in the 60-mark end-semester paper
- Joins and views
- Nested queries
- Aggregate functions and set operations
- PL/SQL procedures and functions
- Triggers
- NoSQL database types
- MongoDB CRUD and aggregation
- ACID versus BASE
Module contents are summarised from the official BAMU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Marathwada University (BAMU).