FIT100
“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