AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Communication Technology

Relationships between tables

Week 6 · Unit 2 Requirements and Production Stages of the Project (3), Create database tables stage (2): relationships between tables: one to one, one to many, many to many, foreign and composite keys · 3 lessons
Answers are for parents and teachers.
1
Name the relationship: (a) a pupil and his locker, (b) a class and its pupils, (c) pupils and the clubs they join.
2
In the teams and players tables of this week, list the players of team 1 and give their number.
3
A joining table has the pairs (1,1), (1,2), (2,1) and (1,2). Which row breaks the rules, and why?
4
A classmate says: “A many-to-many relation cannot be stored in a database.” Explain what is wrong with this sentence.
5
Which field holds the foreign key in a table of books where each book has one writer from a writers table?