ACARA Digital Technologies Years 9–10 Word Scramble: Entities, Relationships and Queries (Modules 433–451)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
ATDA DNACNDUREY
The same details stored again and again in one big table. It wastes space and risks typos or missed updates, like a customer's address copied onto every order.
2
TNTEIY
A type of thing a database stores data about, such as a student, book or order. Each ______ becomes one table, and its name is a singular noun.
3
TIRTBTUEA
An ______ is one property of an entity, like a student's name or year level. Each ______ becomes one field (column) in the entity's table, and each instance of the entity is one record.
4
TNOUJCIN LTAEB
A table that splits a many-to-many relationship into two one-to-many links by holding two foreign keys, such as Enrolment with studentId and subjectId.
5
DER
An entity relationship diagram draws each entity as a labelled box and each relationship as a line joining two boxes. Boxes list attributes, with PK and FK marked.
6
RCOS'W OFTO
ERD notation where a single bar at a line's end means one and a three-pronged ______ means many. The ______ end is the foreign key side of the relationship.
7
RED RMOF A AIECSRON
Find the entities, list their attributes, pick primary keys, then work out each relationship and draw it, with the foreign key on the many side.
8
LREEARNTIEF RGEIYNTTI
Every foreign key value must match an existing primary key in the related table, so no record points to something missing. The database blocks changes that break this.
9
QLS
Structured Query Language, the standard language for asking a database to return data (SELECT) or to add, change or remove it (INSERT, UPDATE, DELETE).
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 433–451
1ATDA DNACNDUREY → data redundancy — The same details stored again and again in one big table. It wastes space and risks typos or missed updates, like a customer's address copied onto every order.
2TNTEIY → entity — A type of thing a database stores data about, such as a student, book or order. Each entity becomes one table, and its name is a singular noun.
3TIRTBTUEA → attribute — An attribute is one property of an entity, like a student's name or year level. Each attribute becomes one field (column) in the entity's table, and each instance of the entity is one record.
4TNOUJCIN LTAEB → junction table — A table that splits a many-to-many relationship into two one-to-many links by holding two foreign keys, such as Enrolment with studentId and subjectId.
5DER → ERD — An entity relationship diagram draws each entity as a labelled box and each relationship as a line joining two boxes. Boxes list attributes, with PK and FK marked.
6RCOS'W OFTO → crow's foot — ERD notation where a single bar at a line's end means one and a three-pronged crow's foot means many. The crow's foot end is the foreign key side of the relationship.
7RED RMOF A AIECSRON → ERD from a scenario — Find the entities, list their attributes, pick primary keys, then work out each relationship and draw it, with the foreign key on the many side.
8LREEARNTIEF RGEIYNTTI → referential integrity — Every foreign key value must match an existing primary key in the related table, so no record points to something missing. The database blocks changes that break this.
9QLS → SQL — Structured Query Language, the standard language for asking a database to return data (SELECT) or to add, change or remove it (INSERT, UPDATE, DELETE).