“First Cut” --Initial Design
Using Entity-Relationship diagrams,
create the best physical DB
Design tables for the information created
Limit tables to simple entities
Worry about redundancy
Assess -- does it make sense?
The design process is iterative
… assess, improve, refine