Overview of Database Design
Conceptual design: (ER Model is used at this stage.)
- What are the entities and relationships in the enterprise?
- What information about these entities and relationships should we store in the database?
- What are the integrity constraints or business rules that hold?
- A database `schema’ in the ER Model can be represented pictorially (ER diagrams).
- Can map an ER diagram into a relational schema.
Schema Refinement (Normalization): Check relational schema for redundancies and related anomalies.
Physical Database Design and Tuning: Consider typical workloads and further refine the database design.