PROCEDURE From the game description to the DDL 1 Gather requirements 2 Highlight Entities 3 Identify relationships What the game needs to remember between sessions Nouns from the description: player, match, object What is the ratio on each side: 1:1, 1:N, N:M 4 Attributes and keys 5 Normalize 6 Save DDL What information do we store about each entity, and how do we distinguish between rows? Remove duplicates and anomalies; format to 3NF Types, Constraints, and Indexes for a Specific DBMS