Clarification details
Updated December 2021. This clarification has been updated to address issues that have arisen from moderation.
Advanced techniques are given in Explanatory Note 4. The evidence needs to demonstrate at least two advanced techniques in the database.
Design of the structure of the data will include some planning for the database, including:
- planning the table or tables to be used
- selecting appropriate types for the data
- planning any queries needed to address and meet end user requirements.
Student evidence needs to explain the relevant implications for the database. This explanation is then used to inform the design and development of the database. There is a dedicated clarification document which expands on what is meant by relevant implications.
The database must present data. This can be done in various ways, depending on the assessment task and the database application used. Strategies may include the use of forms, reports or web-based interfaces.
Data integrity and testing should show the database functions as intended, and that the data is relevant for the purpose and end user. Evidence needs to include testing to show that the data in the database is correct.
For Merit, evidence of how the outcome was improved using testing procedures is required. Student evidence could be provided using annotated screenshots. The evidence needs to show how the relevant implications have been addressed.
For Excellence, iterative improvement is required throughout the design, development and testing process. Iterative improvement involves cycles of improvement. For example, evidence of developing the database in sprints throughout the development process.
A working database is required for Achieved. The database should work more efficiently as a result of iterative improvement. Evidence could be supported by screenshots that show iterative improvements. There is a dedicated clarification document which expands on what is meant by iterative improvement.
For Moderation
Where the evidence uses PHP and SQL or similar web-based methods, a link to show the database running on a webserver should be provided, rather than submitting the evidence to be unpacked into a webserver by the moderator.
Alternatively, a screencast showing the functional database and website operation could be submitted. The video should include some voice-over or subtitles, describing what is happening and explaining what the database does and how it functions.
Assessors will need to ensure that all prepared evidence, such as voice-over video files, online version control tools or separate testing documents are visible to the moderator. When files are password-protected the access settings should be changed appropriately to allow the moderation process to occur.