Candidates 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. 

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.