AS 91633 · 6 credits · Internal
Relational database
Implement complex procedures to develop a relational database embedded in a specified digital outcome
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
This standard asks you to build a working relational database that's connected to another application (like a spreadsheet or website) and meets a set of specifications you've agreed on beforehand. You'll need to design the database structure, write queries to pull and change data, create forms for entering data, and make sure the data stays accurate and secure throughout.
What to do, grades and common mistakes
What you actually do
- ·Design and build a database with multiple related tables that are properly structured and organized
- ·Create queries that pull data from more than one table and that can insert, update, or delete information
- ·Set up a system so data can be entered or changed from another application (spreadsheet, web form, or custom program)
- ·Build customized input forms and data displays (reports, PDFs, or web pages) that look professional and work correctly
- ·Test and verify that your data is accurate, valid, and meets the original specifications, with appropriate access controls in place
AAchieved
You build a working relational database that meets the agreed specifications, with multiple tables, working queries, links to another application, and proper data integrity checks.
MMerit