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
Module 1: Introduction to DBMS; Relational Database Concepts
10 hoursThe 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
- Database systems and their purpose
- Database system structure and data models
- The relational model and Codd's rules
- Relational algebra
- SQL: DDL and DML
- Views, indexes, DCL and TCL
- Keys in the relational model
- Integrity constraints
Module 2: Database Design and ER Modeling; Normalization Techniques
10 hoursEntities, 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
- The ER model
- Extended ER features and mapping ER diagrams to tables
- Functional dependencies
- Normalisation: 1NF, 2NF, 3NF and BCNF
- 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 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).