SGBAU TY Computer Engg syllabus

SGBAU · Third Year B.E. Computer Engineering · NEP 2020

Database Management Systems

5KE220PC · Semester V · 3 credits · IE 40 + ESE 60

  1. Unit 1: Introduction to DBMS and the ER Model

    6 hours

    Database applications and the purpose of database systems, views of data, database languages and architecture, users and administrators; the entity–relationship model, constraints and keys, ER diagrams, reduction to relational schemas, design issues and extended ER features.

    Examined in the 60-mark end-semester paper

  2. Unit 2: Introduction to SQL

    6 hours

    SQL data definition and the basic query structure, set operations, null values, aggregate functions, nested subqueries and join expressions; views, integrity constraints, data types and schemas, authorisation and triggers.

    Examined in the 60-mark end-semester paper

  3. Unit 3: Relational Database Design

    6 hours

    Features of good relational designs, atomic domains and first normal form, decomposition using functional dependencies and dependency theory, BCNF, decomposition using multivalued dependencies and higher normal forms.

    Examined in the 60-mark end-semester paper

  4. Unit 4: Query Processing and Query Optimisation

    6 hours

    Measures of query cost, evaluating selections, joins and expressions; transforming relational expressions and estimating the statistics of expression results.

    Examined in the 60-mark end-semester paper

    • Query processing: selection, sorting and joins
    • Query optimisation and evaluation plans
  5. Unit 5: Transactions and Concurrency Control

    6 hours

    The transaction concept and model, storage structure, atomicity, durability and isolation, serialisability and isolation levels; lock-based protocols, deadlock handling, multiple granularity and timestamp-based protocols.

    Examined in the 60-mark end-semester paper

  6. Unit 6: NoSQL Databases and MongoDB

    6 hours

    NoSQL databases and data models, the CAP theorem and BASE properties, SQL compared with NoSQL; MongoDB CRUD operations, indexing and aggregation.

    Examined in the 60-mark end-semester paper

Unit contents are summarised from the official SGBAU syllabus . AiCanCode.org is not affiliated with Sant Gadge Baba Amravati University (SGBAU).