DBATU TY Computer syllabus

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

All notes for this subject
  1. Unit 1: Introduction and the ER Model

    8 hours

    Purpose 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

  2. Unit 2: Relational Data Model and Relational Algebra

    6 hours

    Structure 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
  3. Unit 3: Relational Calculus and SQL

    8 hours

    Tuple 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

  4. Unit 4: Intermediate and Advanced SQL

    6 hours

    Join 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

  5. Unit 5: Normalization

    6 hours

    Features 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

Unit contents are summarised from the official DBATU syllabus . AiCanCode.org is not affiliated with Dr. Babasaheb Ambedkar Technological University (DBATU).