Database Management System

Introduction: Database system concept, Purpose of Database system; View of data: Data
abstraction; Data models: Relational model, Network model, Hierarchical model; Database
languages: DDL, DML; Conventional file processing; Transaction management; Storage
management; Database Administrator; Database users; Overall system structure.
Database model: Entity-Relationship model; Attributes; Mapping Cardinalities; Existence
Dependencies; Weak entity set & Strong entity set; Relational model and its language (Relational
algebra and SQL).
Database design: Decomposition; Normalization; Object-oriented Databases; Centralized
systems; Distributed Databases; Data Fragmentation; Parallel Databases.
Integrity Constraints: Domain constraints, Referential constraints, Functional Dependencies.
Indexing: Basic concept; Ordered index; Primary index; Dense index and Sparse index;
Multilevel index; Secondary index.