Databases
Database
Candidates should be able to:
1. Define a single-table database from given data storage requirements
Note and guidance
Including:
fields
records
validation
2. Suggest suitable basic data types
Note and guidance
Including:
text/alphanumeric
character
Boolean
integer
real
date/time
3. Understand the purpose of a primary key and identify a suitable primary key for a given database table
4. Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table
Note and guidance
Limited to:
SELECT
FROM
WHERE
ORDER BY
SUM
COUNT
Identifying the output given by an SQL statement that will query the given contents of a database table