Identify the end-user and functional requirements of a database problem that relates to the implementation at this level.

Describe and exemplify a data dictionary with three or more entities: entity name; attribute name; primary and foreign key; attribute type (text, number, date, time, Boolean); attribute size; validation (presence check, restricted choice, field length, range)

Describe and exemplify entity-relationship diagrams with three or more entities, indicating: entity name; attributes; name of relationship; cardinality of relationship (one-to-one, one-to-many, many-to-many)

Describe and exemplify an instance using an entity-occurrence diagram

Describe and exemplify a compound key

Exemplify a design of a solution to a query: tables and queries; fields; search criteria; sort order; calculations; grouping

Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables: SELECT statement making use of: wildcards; aggregate functions (MIN, MAX, AVG, SUM, COUNT); computed values; alias; GROUP BY; ORDER BY; WHERE

Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables: INSERT statement making use of: wildcards; aggregate functions (MIN, MAX, AVG, SUM, COUNT); computed values; alias; GROUP BY; ORDER BY; WHERE

Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables: UPDATE statement making use of: wildcards; aggregate functions (MIN, MAX, AVG, SUM, COUNT); computed values; alias; GROUP BY; ORDER BY; WHERE

Describe, exemplify and use SQL operations for pre-populated relational databases, with three or more linked tables: DELETE statement making use of: wildcards; aggregate functions (MIN, MAX, AVG, SUM, COUNT); computed values; alias; GROUP BY; ORDER BY; WHERE

Describe and exemplify testing: SQL operations work correctly at this level

Evaluate solution at this level in terms of: fitness for purpose; accuracy of output