BAMU TY Computer syllabus

BAMU · Third Year B.E./B.Tech Computer Science and Engineering · 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

    The purpose and advantages of a DBMS, data models, database users, schema and instance 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

  2. Module 2: Database Design and ER Modeling; Normalization Techniques

    10 hours

    Entities, attributes, relationships and cardinality, ER diagrams for library-management and college-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

  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 compared with NoSQL.

    Examined in the 60-mark end-semester paper

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