Fig. 1 shows the entity relationship diagram for an independent music festival. Artists can perform on several stages, and a stage hosts many artists across...
Question 1 Report
Fig. 1 shows the entity relationship diagram for an independent music festival. Artists can perform on several stages, and a stage hosts many artists across the day. The Performance entity stores the planned start time, which is different for each artist-stage combination.
(a) State the relationship type between Artist and Stage without Performance. [1]
(b) Give two fields that link Performance to the other tables. [2]
(c) State why StartTime is stored in Performance rather than Artist. [1]
(d) Give one suitable primary key for Performance. [1]
For each delivery, the courier company records the driver who completed it. Fig. 1 shows the fields selected for two related tables. A driver can complete many deliveries during a shift, but each delivery is assigned to one driver.
(a) State how many Driver records may be linked to one Delivery record. [1]
(b) State how many Delivery records may be linked to one Driver record. [1]
(c) Give two fields, other than keys, that would be useful in the Delivery table. [2]
Answer Details
Music-festival database
(a) Without Performance, Artist and Stage have a many-to-many relationship. [1]
(b) Performance is linked using ArtistID and StageID. [2]
(c) StartTime is stored in Performance because an artist can have a different start time for each stage or performance. It is not a fixed property of the artist. [1]
(d) PerformanceID is a suitable primary key. A composite key made from ArtistID and StageID is also acceptable where that combination is unique. [1]
Courier database
(a) One Driver record may be linked to one Delivery record, because each delivery has one assigned driver. [1]
(b) Many Delivery records may be linked to one Driver record, because a driver can complete many deliveries. [1]
(c) Two useful non-key fields are delivery address and delivery date. Delivery time, parcel weight and delivery status are also acceptable. Any two [2].
Download The App On Google Playstore
Everything you need to excel in your exams
