DBMS Guidelines and Practical List PDF

DBMS Guidelines and Practical List

Course Objective: The course introduces the foundations of database management systems focusing on significance of a database, relational data model, schema creation and normalization, transaction processing, indexing, and the relevant data structures (files and B+-trees).

DBMS Guidelines

Introduction to databases: Characteristics of database approach, data models, database system architecture, data independence and data abstraction.

Data modeling: Entity relationship (ER) modeling: Entity types, relationships, constraints, ER diagrams, EER model.

Relation data model: Relational model concepts, relational constraints, relational algebra.

SQL queries: SQL data definition, data types, specifying constraints, Queries for retrieval, insertion, deletion, updation, introduction to views.

Database design: Mapping ER/EER model to relational database, functional dependencies, Lossless decomposition, Normal forms (upto BCNF).

Transaction and data storage: Introduction to transaction processing: ACID properties, concurrency control; Introduction to indexing structures for files.

DBMS Reference Books:

  1. Elmasri, R., & Navathe, S.B. (2015). Fundamentals of Database Systems. 7th edition. Pearson Education.

Source: https://www.du.ac.in

Download DBMS Guidelines and Programs List PDF

DBMS Guidelines and Programs List PDF

DBMS Guidelines and Programs List
Delhi University (DU)

DBMS Guidelines and Programs List PDF

DBMS Compiled Book
Delhi University (DU)