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