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.