Summary
Database design consists of several tasks: requirements analysis, conceptual design, schema refinement, physical design and tuning.
- In general, have to go back and forth between these tasks to refine a database design, and decisions in one task can influence the choices in another task.
Understanding the nature of the workload for the application, and the performance goals, is essential to developing a good design.
- What are the important queries and updates? What attributes/relations are involved?