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

The Answer is in the image, click to view ...

Question: 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

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.

Before developing a database solution, the company had been using a spreadsheet

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Before developing a database solution, Eventbase had been using a spreadsheet to record basic information about events. A fragment of this spreadsheet is used in this question see Figure 5). The...

a. Before developing a database solution, Eventbase had been using a spreadsheet to record basic information about events. A fragment of this spreadsheet is used in this question see Figure 5). The...

please help me answer this question will rate your answer right away! Requirements: A summary of the key issues and your thoughts about important aspects of an analysis or recommendation. A...

As Mitch Mackenzie sipped his morning coffee on the way to work, he envisioned the value he hoped to bring to his family business, Custom Closet Contractors (C3), which designed, manufactured, and...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Overview of the case. What do you think of the particular assignment given to Browning? TEXTBOOK : Brown, C.V., DeHayes, D.W., Hoffer, J.A., Martin, E.W., and Perkins, W.C. Managing Information...

Can someone please help me make this run? I don't understand why it is not //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Can someone help make this java file run? The code is probable the main issue I am having //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

Please help with this. Text below BCS 101 - Programming Concepts and Problem Solving This course will provide an introduction to programming logic and problem solving techniques using different...

MMH074.qxd 4/8/09 5:09 PM Page 238 Adam Darkins is the Chief Consultant for Care Coordination at the US Department of Veterans Affairs. He has a track record of developing the clinical, technology...

How does a professional corporation differ from a traditional corporation?

As part of its environmental strategy the Antland government wishes to reduce the annual consumption of coal- fired electricity by 5% Antland government economists have analysed data which reveal...

Which of the following is true about a 4 0 1 ( k ) plan? Group of answer choices 4 0 1 ( k ) contributions are made after taxes are paid on your salary Your contributions are yours regardless of when...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

(Appendices) Why do readers of financial statements prefer the separate disclosure of gross sales revenue and sales returns and allowances to the disclosure of a single net sales revenue amount? LO61

(Appendices) Name the two allowance methods used to compute uncollectible account expense. For each method, how is uncollectible account expense computed and what does the balance of the allowance...

(Appendices) INCOME EFFECTS OF UNCOLLECTIBLE ACCOUNTS. The credit manager and the accountant for Goldsmith Company are attempting to assess the effect on net income of writing off $100,000 of...