BAMU · Third Year B.E./B.Tech Information Technology · NEP 2020
Database Management System
PCCT-1 · Semester V · 3 credits · CIA 40 + SEE 60
Module 1: Introduction to DBMS; Relational Database Concepts
10 hoursPurpose, 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
Module 2: Database Design and ER Modelling; Normalisation Techniques
10 hoursEntities, 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
Module 3: Advanced SQL and PL/SQL; Introduction to NoSQL Databases
10 hoursJoins, 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).