Before you create a database you must have a completed data dictionary

This will specify:

• tables
• fields
  • names
  • types and sizes
  • primary and foreign keys
  • required
  • validation rules