SQL Database Design
Database Design Principles
Duplicate information is bad
Accuracy & Completeness is good
The Design Process
Determine the database purpose
Discover and collect information
Divide the entities into tables
Turn the data points into columns
Identify primery & forign keys
Normalize & refine
Last updated