Question 1: Suppose that you have been presented with the given relation for the Baxter Aviation database: Charters (Pilot, Pilot-name, Aircraft ID, seats, Village, Flight, Flight-date, Flight-time, Customer, Customer-name)
i) How many entities are represented by this relation?
ii) Determine the primary key of this relation?
(Hint: Flight is unique; flight numbers do not repeat as they do on commercial airlines with regularly scheduled flights. Each flight can go to numerous villages and over time a village can receive many flights.)
iii) Give a particular illustration of one insertion anomaly present in this relation.
iv) Give a particular illustration of one deletion anomaly present in this relation.
v) Is this relation in first, second or third normal form? Why?