Step 1: Represent user view
as collection of tables
a: Determine entities involved and create separate table for each type
b: Determine primary key for each table
c: Determine properties for each entities
d: Determine relationships among entities
Step 2: Normalize these
tables
Step 3: Identify all
keys
Step 4: Merge the result (for
all user views) into design