Reference no: EM13347482
Question 1:
Consider that you have been presented with the subsequent relation for the Baxter Aviation database: Charters (Pilot#, Pilot name, Aircraft ID#, #seats, Village, Flight#, Flight date, Flight time, Customer#, Customer name)
(a) How many entities are shown by this relation?
(b) What is the primary key of relation? (Hint: Flight# is unique; flight numbers do not repeat as they do on commercial airlines with regularly scheduled flights. Each flight will go to many villages and over time a village can receive many flights.)
(c) Give a example of one insertion anomaly present in this relation.
(d) Give a example of one deletion anomaly present in this relation.
(e) Is this relation in first, second, or third normal form? Why?