Define Schema
Let's start by defining your table structure. What are the columns?
Primary Key
Select the attribute(s) that uniquely identify a row. Select multiple for a Composite Key.
1NF Check
First Normal Form requires atomicity.
Is there any cell that contains multiple values?
(e.g., "PhoneNumbers" storing "555-0101, 555-0102")
2NF Check
Checking for Partial Dependencies.
3NF Check
Checking for Transitive Dependencies.
Do non-key attributes depend on other non-key attributes?
Example: Does City depend on ZipCode (where ZipCode is NOT the Primary Key)?