Tables and relationships
Answers are for parents and teachers.
1
A table holds 7, 3, 10, 8, 2. Find Sum and Average.
Sum = 30, Average = 6
2
The clubs have 7, 3 and 5 students. How many rows appear in the combined query?
15
3
In a one-to-many relationship between “Books” and “Authors” (one author – many books), which table holds the foreign key?
In the Books table (the AuthorID field).
4
Why must a primary key not repeat in linked tables?
If it repeated, a record could not be identified exactly and the link would become ambiguous.
5
Draw a “Clubs” table for three clubs and a “Students” table with 4 invented students in your notebook, and mark the foreign key.
In Students, ClubID is the foreign key; its values must be one of the ClubID values in Clubs.