BAMU TY AI & DS syllabus

BAMU · Third Year B.E./B.Tech Artificial Intelligence and Data Science · NEP 2020

Database Management System

PCCT-1 · Semester V · 3 credits · CIA 40 + SEE 60

All notes for this subject
  1. Module 1: Introduction to DBMS; Relational Database Concepts

    15 hours

    Purpose 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
  2. Module 2: Database Design and ER Modelling; Normalisation

    15 hours

    Entities, 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
  3. Module 3: Advanced SQL and PL/SQL; Introduction to NoSQL

    15 hours

    Joins, 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).