DBATU TY IT syllabus

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

All notes for this subject
  1. Unit 1: Introduction and Data Modelling

    8 hours

    Advantages 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
  2. Unit 2: Relational Model and SQL I

    8 hours

    Attributes 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
  3. Unit 3: Views and SQL II

    8 hours

    Creating, 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
  4. Unit 4: Database Design Using the E-R Model

    8 hours

    The 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
  5. Unit 5: Big Data Analytics and Storage

    8 hours

    Big 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).