DBATU · Third Year B.Tech Computer Engineering · NEP 2020
Database Management Systems
26AF1245PC504 · Semester V · 3 credits · Continuous assessment 20 + mid-semester 20 + end-semester 60
Unit 1: Introduction and the ER Model
8 hoursPurpose and applications of database systems; views of data and database languages; database architecture; ER concepts, constraints, keys and mapping cardinality; weak entities; Codd's rules; extended ER, generalisation and aggregation; reducing ER diagrams to tables.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
Unit 2: Relational Data Model and Relational Algebra
6 hoursStructure of relational databases, schemas and keys; fundamental, additional and extended relational-algebra operations.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Relational algebra
- Extended relational algebra operations
Unit 3: Relational Calculus and SQL
8 hoursTuple and domain relational calculus compared with algebra; SQL data definition and basic queries; set operations, nulls and aggregates; nested subqueries; modifying the database.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Tuple and domain relational calculus
- SQL: DDL and DML
- SQL functions and aggregate queries
- Joins, set operations and nested queries
Unit 4: Intermediate and Advanced SQL
6 hoursJoin expressions, views, transactions, integrity constraints, data types and authorisation; SQL from programming languages with JDBC, ODBC and embedded SQL; functions, procedures and triggers.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Views, indexes, DCL and TCL
- Integrity constraints
- Embedded SQL, JDBC and ODBC
- Stored procedures, functions and triggers
Unit 5: Normalization
6 hoursFeatures of good relational design; functional dependencies and their theory; first, second and third normal forms and BCNF; multivalued dependencies and fourth normal form; the database design process.
Examined in the 60-mark end-semester paper, and in the mid-semester exam if it is taught by then
- Functional dependencies
- Normalisation: 1NF, 2NF, 3NF and BCNF
- Fourth normal form and multivalued dependencies
- Database design process
Unit contents are summarised from the official DBATU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Technological University (DBATU).