AS 91892 · 4 credits · Internal
Database development
Use advanced techniques to develop a database
Study with Coach
Save your actual school result to count your credits.
You need to design and build a database that organises data in a structured way, then use advanced techniques like queries, filters, and validation to make it work properly for a specific purpose. You'll also need to test it, fix any problems, and explain how things like privacy, accessibility, and user needs affect your design choices.
What to do, grades and common mistakes
- ·Design how your data will be structured (tables, fields, relationships) to store information effectively
- ·Use advanced techniques such as linking tables with keys, writing queries to filter/sort data, adding validation rules, and creating custom forms
- ·Test your database thoroughly, identify problems, and fix them to improve data quality
- ·Consider and explain relevant implications like privacy, accessibility, user needs, functionality, and ease of use
- ·Present your data in a way that makes sense for the people who will actually use it
You design a database structure, use some advanced techniques to organise and query the data, apply basic testing, and mention at least one relevant implication.
You design a logical database structure, use multiple advanced techniques effectively, use testing to improve the database quality, and address several relevant implications thoughtfully.