The candidate must demonstrate knowledge and understanding, practical skills and problem solving based on the following content statements:
- Description of the benefits of an electronic database system in comparison with manual data storage, including searching and sorting, data retrieval, data storage and updating, data analysis and reporting.
- Entities and Data Relationships
- Description and exemplification of simple data entities, in terms of the following attributes: name, multi-valued or single valued, data type (text, integer, real, object, date, time).
Data Modelling Concepts
- Design and creation of data tables, including consideration of: table names, fields (name and type), keys (primary and foreign), validation (presence, restricted choice).
- Description and exemplification of the following field types: text, number, object, link, date, time, Boolean.
- Identification of the limitations of flat file databases, and the advantages of linked tables (relational databases).
- Explanation of normalisation.
- Identification of entities with a single one-to-many relationship between them in a single source document.
- Identification and removal of multi-valued fields in records.
- Implementation of database system based on data table.
- Description and implementation of simple queries including: sorting (two fields, ascending/descending), searching (two fields).
- Description and implementation of data input forms and simple reports.
- Implementation of consistent, user-friendly user interface and screen design.