DBATU · Third Year B.Tech Information Technology · NEP 2020
Database Management System
26AF1246PC503 · Semester V · 3 credits · Continuous assessment 20 + mid-semester 20 + end-semester 60
Unit 1: Introduction and Data Modelling
8 hoursAdvantages of a DBMS over file processing; data abstraction, models and independence; the components and structure of a DBMS; entities, attributes, relationships, constraints and keys; E-R diagrams.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- DBMS versus file processing systems
- Data abstraction and data independence
- DBMS architecture and database languages
- ER model and ER diagrams
- Keys and constraints
Unit 2: Relational Model and SQL I
8 hoursAttributes and domains; integrity and referential constraints; schema diagrams; relational algebra and tuple and domain relational calculus; SQL data types and literals; DDL for creating, altering and dropping tables.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Relational model concepts and constraints
- Relational algebra
- Relational calculus
- SQL DDL and constraints
Unit 3: Views and SQL II
8 hoursCreating, dropping and updating views; DML and the SELECT query; set operations, joins and predicates; aggregates; nested queries; insert, update and delete; dynamic SQL and stored procedures; query by example.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Views and indexes
- SQL DML and SELECT queries
- Joins
- Aggregate functions, GROUP BY and HAVING
- Subqueries and set operations
- Stored procedures, functions and triggers
Unit 4: Database Design Using the E-R Model
8 hoursThe design process; complex attributes and mapping cardinalities; reducing E-R diagrams to relational schemas; extended E-R features; good relational design; 1NF, 2NF and 3NF.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- EER model and mapping to tables
- Data redundancy and anomalies
- Functional dependencies
- Normal forms: 1NF, 2NF and 3NF
Unit 5: Big Data Analytics and Storage
8 hoursBig data storage systems; MapReduce and beyond; streaming data and graph databases; data warehousing and mining; physical storage media, magnetic disks, flash memory and RAID.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Big data, Hadoop and HDFS
- MapReduce for databases
- Streaming data and graph databases
- Data warehousing and data mining
- Physical storage media and RAID
Unit contents are summarised from the official DBATU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Technological University (DBATU).