Design

• What is the databases regular relationship?

  One to many
• What are the two key types?

  • Primary key
  • Foreign key
• How do you identify a primary key?

  Underline
• How do you identify a foreign key?

  Asterix (*)
• What are the data types?

  • Text
  • Number
  • Date
  • Time
  • Boolean
• What are the four types of validation?

  • Presence check
  • Restricted choice
  • Field lenth
  • Range
• In a data dictionary, what is the validation for a foreign key?

  Lookup from ...
• What is it called when the foreign key matches the primary key?

  Referential integrity
• How do you show the structure of the database?

  Entity relationship diagram
• What order should a query design be in?

  Tables

  Fields

  Search Criteria

  Sort order