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