1. Create an un-normalized tabular format (flat spreadsheet-like table) from the report format 2. Convert to 1NF: a. Each cell contains a single value b. Identify the primary key 3. Convert to 2NF: a. Identify the partial dependencies b. Convert tables to 2NF (table form and relational schema) by eliminating partial dependencies 4. Convert to 3NF: a. Identify the transitive dependencies b. Convert tables to 3NF (table form and relational schema) by eliminating transitive dependencies