5
6
Concepts of Database Management, 4th Edition, Pratt & Adamski
Information-level Design Methodology
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