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