Based on Diagram 3.38 and 3.39, answer the following questions:

FYI: Questions a -f related to diagram 3.38 and g-h related to both 3.38 and 3.39.

a) Explain where this diagram shows that a supplier can supply many DVD titles.

b) Explain where this diagram shows that a DVD title can come from many suppliers.

c) Explain where this diagram shows that a DVD title can have many DVD copies.

d) Explain where this diagram shows that a DVD copy relates to one title only.

e) Explain where this diagram shows that a DVD copy can be rented to one customer at a time.

f) Explain where this diagram shows that a customer can rent many copies of a DVD.

g) Explain what DVD_Title_num in the DVD Copy table is and what purpose it serves.

h) Explain what Customer_num in the DVD Copy table is and what purpose it serves.

 

Transcribed Image Text:

1 N Has DVD title DVD copy many Is Is sourced rented from to M Supplier Customer FIGURE 3.38 DVD store rental database (excluding purchase, supplier payment, rental payment and receipt items) 1 N Has DVD title DVD copy many Is Is sourced rented from to M Supplier Customer FIGURE 3.38 DVD store rental database (excluding purchase, supplier payment, rental payment and receipt items)

Answer rating: 100% (QA)

In an Entity relationship diagram rectangles represent Entity or Object diamonds represent decisions ... View the full answer