Note for Database Management System - DBMS By Kaustuva Dev

Data & Information, Evolution of Database Systems, Overview of a DBMS, Database System Concepts & Architecture - Data models, schemas and instances, Data Abstraction, Data Independence, Database languages and interfaces.

Data modeling using Entity - Relationship (ER) Model: Entity sets, attributes and keys, Relationship types, sets, roles and structural constraints, Weak Entity types. Data Models: Relational, Network, Hierarchical and Object Oriented.

Relational data model concepts, Codd’s 12 rules, Relational model constraints and schemas, Relational Algebra and Relational calculus

Data dependency, Armstrong’s Axioms, Functional dependencies and Normalization of Relational Databases, First, Second and Third Normal forms, Boyce-Codd Normal form (BCNF), Relational Database design Algorithms and further dependencies, Denormalization

Disc Storage, Basic File Structures and Hashing, Indexing structures for files, multi-level indexing using B-trees and B+ -trees.

Introduction to Transaction Processing concepts and Theory, ACID Properties, concurrency control, Serializability