By the end of this sub-unit, you should be able to:

  • define a single-table database from given data storage requirements 
  • choose and specify suitable data types 
  • choose a suitable primary key for a database table 
  • perform a query-by-example from given search criteria.