Database Management System Unit-1

Introduction: Overview, Database System vs File System, Database System Concept and

Architecture, Data Model Schema and Instances, Data Independence and Database Language and

Interfaces, Data Definitions Language, DML, Overall Database Structure. Data Modeling Using the

Entity Relationship Model: ER Model Concepts, Notation for ER Diagram, Mapping Constraints,

Keys, Concepts of Super Key, Candidate Key, Primary Key, Generalization, Aggregation,

Reduction of an ER Diagrams to Tables, Extended ER Model, Relationship of Higher Degree.