Common Sense Design

Design tables from the questions the data must answer. Learn from Northwind's design - one subject per table, columns at their smallest useful size, a primary key in every table, and foreign keys to link them.

Updated

Cheat sheet: Common Sense Design
Category
SQL
Level
Journeyman
Tags
database, Foreign Key, Granularity, Primary Key, sql