Define a single-table database from given data storage requirements

• Understand and identify fields and records.

• Implement validation for data entries.

Suggest suitable basic data types

• Text/Alphanumeric

• Character

• Boolean

• Integer

• Real

• Date/Time

Understand the purpose of a primary key and identify a suitable primary key for a given database table

• Explain the role of a primary key in a database.

• Select an appropriate primary key for given data.

Read, understand, and complete structured query language (SQL) scripts to query data stored in a single database table

• Use basic SQL commands to query a database:

  • SELECT

  • FROM

  • WHERE

  • ORDER BY

  • SUM

  • COUNT

• Identify the output produced by an SQL statement that queries the contents of a database table.