GateXAIML · DBMS Concept Notes

Database Management Systems

Chapter 1
Introduction
21 sections
Overview, Data View, Database Engine and Core Internal Components
Chapter 2
ER Model
13 sections
Entity–Relationship (E–R) Data Model, Entity and Entity Sets, Relationship Sets...
Chapter 3
Relational Model
11 sections
Structure of Relational Databases, Attribute Domains, Atomicity & NULL values, Database Schema...
Chapter 4
Relational Algebra & Tuple Calculus
13 sections
Relational Algebra, Examples on Relation Algebra, Tuple Relational Calculus
Chapter 5
Structured Query Language (SQL)
45 sections
SQL Schema Creation and Insertion, SQL Data Definition / Modification Commands, SQL Query and Basic Operations...
Chapter 6
Normalization
21 sections
Functional Dependencies, Armstrong’s axioms (Inference rules), Closure of attributes & Finding Candidate Keys...
Chapter 7
Data Organization and Indexing
16 sections
Record Organization, Organization of Records in Files, Indexing...