AS 91902 · 4 credits · Internal
Complex database design
Use complex techniques to develop a database
Study with Coach
Got a result for this standard?
Sign in to add your result →Save your actual school result to count your credits.
In plain EnglishAI study guide · check the NZQA standard
You need to build a working database that does real work—organising, searching, and displaying data in useful ways. The database must be well-designed with good data structure, use smart techniques to handle the data, and consider real-world impacts like privacy and accessibility. Your job is to create something that actually serves its purpose for the people who'll use it.
What to do, grades and common mistakes
What you actually do
- ·Design a proper database structure with multiple related tables or nodes that logically organise your data
- ·Use complex queries to insert, update, delete, or retrieve data in ways that serve your purpose
- ·Create displays of your data (reports, dashboards, web pages, or interfaces) that pull information from multiple parts of your database
- ·Test your database thoroughly to check data is correct, reliable, and secure—and use what you learn to improve it
- ·Think through real-world implications like privacy, accessibility, security, user needs, and whether your solution actually works for its intended users
AAchieved
You design a database with multiple tables, create queries to modify and retrieve data, present the data in a useful format, test it, and consider at least one real-world implication.
MMerit