AC9TDI10P03

See also: Learning Areas / Technologies / Digital Technologies / Processes and production skills / Acquiring, managing and analysing data / Years 9 and 10

model and query entities and their relationships using structured data

Elaborations

• AC9TDI10P03_E1 - modelling entities and processes, their attributes and the relationships between them, for example creating database tables for a movie, a user and their movie review, where a movie has a title, genre and release date, and a review has a movie, a user and their rating and comments
• AC9TDI10P03_E2 - using structured data to help in decision-making, for example creating a data schema for a relational database and building the database, incorporating query and reporting functionality to solve a problem of student choice
• AC9TDI10P03_E3 - interpreting and querying multi-table databases using SQL queries with SELECT, WHERE and simple JOIN/GROUP BY clauses and counting, for example checking that each user has only reviewed each movie once

Achievement Standard Components

• ASTECTDI91002 - Students acquire, interpret and model complex data with databases and represent documents as content, structure and presentation.