The seven steps in their correct order
- Identify field data types
- Identify
NULL
value fields
- Identify the primary key (this could be single or multiple fileds)
- Identify all foreign keys
- Identify default values for fields
- Identify domain constraints
- Create the table