Before developing a database solution, the company had been using a spreadsheet to record basic information about events. A fragment of this spreadsheet is used in this question. The fragment shows the event id, the date of the event and the pilot, observer and drone used.

The company used the following relation as the template for the spreadsheet columns and rows shown below:

• Event (EventID, Date, PilotEmployeeID, PilotName, ObserverEmployeeID, ObserverName, Manufacturer, Serialnumber)

The following are known to always hold between the attributes of the above relation:

• A value of EventID uniquely determines a single Date value.

• A value of EventID uniquely determines a single PilotEmployeeID value.

• A value of EventID uniquely determines a single PilotName value.

• A value of EventID uniquely determines a single ObserverEmployeeID value.

• A value of EventID uniquely determines a single ObserverName value.

• A value of EventID uniquely determines a single Manufacturer value.

• A value of EventID uniquely determines a single SerialNumber value.

• A value of PilotEmployeeID uniquely determines a single PilotName value.

• A value of ObserverEmployeeID uniquely determines a single ObserverName value.

A table of sample data representing the relation is shown in Figure 5.

• i.Using the data in Figure 5 describe, with an example, how an amendment anomaly might arise.

• ii.Briefly explain why Event is in first normal form.

• iii.Briefly explain why Event is in second normal form.

• iv.Event is not in third normal form. Identify the problems, and then split the relevant attributes into new tables so that the resulting tables are in third normal form.

Event Date ID Pilot Employ ee ID PilotNa me ObserverEmplo | ObserverN yeeld ame ManufactSerialnum urer ber 002346 Rotor Dyn RD142562 E002 82 10/09/ 002341 19 Joshua Smith Hannibal Heyes 324 1/09/1 002330 Thadde 002346 RotorDyn E002 75 Hannibal Heyes RD142562 324 19 us Jones E002 1/08/1 002330 Flyte Spee 1242322 Thadde 002341 us Jones Joshua Smith 71 E002 002330 Thadde 002347 Je de diah Rotor DunD1AESC 10/09/ 19 83 us Curry 243 Jones E002 11/09/ 002341 002346 Rotor Dyn Joshua Smith Hannibal Heyes RD142566 243 84 19 Thadde 002347 Flyte Spee1242322 E002 85 11/09/ 002330 19 Je de diah Curry us Jones E002 15/09/ 002341 002346 Flyte Spee 1442522 Joshua Smith Hannibal Heyes 90 19 E002 | 17/09/ 17/09/ 002330 002341 Flyte Spee 1442522 Thadde us Joshua Smith 19 Jones