From TKI

This achievement standard involves using complex techniques to develop a database.

This assessment task requires students to use complex techniques to develop a relational database to maintain a list of items, events, tasks for a specific purpose and end-user. For example, the student could create a database for the school notices, canteen orders, sports events for each term, a personal and/or academic goal tracking system, a cataloging (booking) system for the school tablets/laptops. This includes logically designing the structure of the database, as well as organising and querying the data logically. The student must also present the data effectively for the purpose and end-users of the database.

The step up from Level 2 is the requirement for students to use complex techniques which are clearly specified in the achievement standard, the use of efficient tools and techniques in the outcomes production.

Students are required to collect evidence as they develop their database outcome.

• early in development:

  • a sketch of the proposed database structure including field names, primary key and data types/length

  • identification of data duplication within a table and creation of a second related table

  • later in development:

    • screen captures of working database table (structure).

    • testing queries to confirm records are as expected

    • towards the end of development:

    • screen captures, or other methods show that

• code to evidence connection and querying of data

• Iteration over an associative array

• Output and styling of output

• evidence such as video or screen captures to show trialing of user selections and resulting output.