ISDD+Relationships

media type="custom" key="28093825"


 * Questions**

1. Say whether each of the following relationships are 1:1, 1:m or m:n (a) Movie and actor (b) Head teacher and school (c) Library book and borrowers (d) Owner and dog (e) Father and daughter (f) Computer and mouse (g) Driver and driving licence (h) Book and author (i) Traveler and passport (j) Customer and product

2. Write down an example of each of the following types of relationship. (a) One-to-one (b) One-to-many (c) Many-to-many

3. Tech-Repair repair computers. They store all of the repair details in a database with 4 tables, shown below:

State two one-to-many relationships that exist between the tables