DBMS Unit-1 -UPTU

Introduction:
An overview of database management system,
Database system Vs file  system,
Database system concept and architecture ,Overall Database Structure,
Data model 
Schema and instances,
Data independence and database language and interfaces/data abstraction,
Data definitions language, DML.
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, 
Extended ER model-Generalization, Aggregation,
Reduction of an ER diagrams to tables.