BAMU TY IT syllabus

BAMU · Third Year B.E./B.Tech Information Technology · 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

    10 hours

    Purpose, characteristics and advantages of DBMS, data models, users, architecture, schemas and instances, and the three-level architecture; the relational model, relational algebra (select, project, join, union), SQL basics, DDL, DML, DCL and TCL commands, constraints and keys.

    Examined in the 60-mark end-semester paper

    • DBMS versus file processing systems
    • Data abstraction and data independence
    • DBMS architecture and database languages
    • Relational model concepts and constraints
    • Relational algebra
    • SQL DDL and constraints
    • SQL DML and SELECT queries
    • Keys and constraints
  2. Module 2: Database Design and ER Modelling; Normalisation Techniques

    10 hours

    Entities, attributes, relationships and cardinality, ER diagrams for library and admission systems, and mapping ER models to relations; functional dependencies, 1NF, 2NF, 3NF and BCNF, lossless joins and dependency preservation.

    Examined in the 60-mark end-semester paper

    • ER model and ER diagrams
    • EER model and mapping to tables
    • Functional dependencies
    • Normal forms: 1NF, 2NF and 3NF
    • Boyce–Codd normal form
    • Lossless join and dependency preservation
  3. Module 3: Advanced SQL and PL/SQL; Introduction to NoSQL Databases

    10 hours

    Joins, subqueries, aggregate functions, GROUP BY and HAVING, views, indexes, procedures, functions, triggers and exception handling; the need for and types of NoSQL databases, MongoDB architecture and CRUD operations, and SQL versus NoSQL.

    Examined in the 60-mark end-semester paper

    • Joins
    • Subqueries and set operations
    • Aggregate functions, GROUP BY and HAVING
    • Views and indexes
    • Stored procedures, functions and triggers
    • NoSQL databases and their types
    • MongoDB basics

Module contents are summarised from the official BAMU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Marathwada University (BAMU).