ACARA Digital Technologies Years 9–10 Crossword: Entities, Relationships and Queries (Modules 433–451)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
10
Across
- 1. 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. Word 2 of: ERD ____ a ________ (4)
- 5. Word 4 of the term in 3 Down: _______ KEY (field) __________ ______table(field) (10)
- 7. Word 5 of the term in 3 Down: _______ KEY (field) __________ ______table(field) (5)
- 8. 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. Word 3 of: crow's ____ (4)
- 9. 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. (9)
- 10. Structured Query Language, the standard language for asking a database to return data (SELECT) or to add, change or remove it (INSERT, UPDATE, DELETE). (3)
Down
- 2. 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. Word 1 of: ___________ integrity (11)
- 3. Used in CREATE TABLE to link a column to another table's key. The database then only accepts values that match an existing key, so bad links are rejected. Word 1 of: _______ KEY (field) __________ ______table(field) (7)
- 4. 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. Word 1 of: ________ table (8)
- 6. Word 4 of the term in 1 Across: ERD ____ a ________ (8)
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 433–451
1F
2R
O
M
3F
4J
E
O
U
F
5R
E
F
E
R
E
N
C
E
S
6S
E
C
R
C
I
7O
T
H
E
R
E
G
I
N
N
N
8F
O
O
T
A
N
I
R
9A
T
T
R
I
B
U
T
E
10S
Q
L
O
Across
1FROM — 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. Word 2 of: ERD ____ a ________
5REFERENCES — Word 4 of the term in 3 Down: _______ KEY (field) __________ ______table(field)
7OTHER — Word 5 of the term in 3 Down: _______ KEY (field) __________ ______table(field)
8FOOT — 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. Word 3 of: crow's ____
9ATTRIBUTE — 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.
10SQL — Structured Query Language, the standard language for asking a database to return data (SELECT) or to add, change or remove it (INSERT, UPDATE, DELETE).
Down
2REFERENTIAL — 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. Word 1 of: ___________ integrity
3FOREIGN — Used in CREATE TABLE to link a column to another table's key. The database then only accepts values that match an existing key, so bad links are rejected. Word 1 of: _______ KEY (field) __________ ______table(field)
4JUNCTION — 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. Word 1 of: ________ table
6SCENARIO — Word 4 of the term in 1 Across: ERD ____ a ________