ACARA 9-10 Digital Technologies: Tables, keys and relationships
Students learn how data is organised in tables, why one big table causes repeated data, and how entities, primary keys, foreign keys and relationships link tables in a relational database.
One content description (AC9TDI10P03) from the full ACARA Digital Technologies Years 9–10 — Entities, Relationships and Queries journey. All 13 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (13)
1
Organising data in a table with headings
2
What a single-table database is
3
Counting fields and records in a table
4
Database field data types
5
The repeated-data problem in one big table
6
What is a relational database?
7
Entity
8
Attributes become fields
9
Primary key
10
Choosing a suitable primary key from a table
11
Foreign key and table relationships
12
One-to-many relationships between tables
13
One-to-one and many-to-many relationships
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →