The Airport Authority of Utopia maintains a spreadsheet to store information about airlines, pilots and planes....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Airport Authority of Utopia maintains a spreadsheet to store information about airlines, pilots and planes. There is only one airport but several airlines use it. The airport employs you as consultant to develop a simple database system. You are required to normalise the following spreadsheet and create an Entity-Relationship Diagram (ERD) to match the resulting tables of the data normalisation process. The following are some sample data on the spreadsheet. Airline_ID Airline_Name Airline_Phone Pilot_LicNo Pilot_Name Pilot_Address Pilot_DOB CX Capital (03) 99876543 A1567832 H.Simpson 12 Smith Rd. Sydney 4/12/1953 UG United (02) 94212321 A1786542 A.Khan 7 Cedar Pl. Ryde 22/10/1957 ΜΑ Miracle (02) 98098761 B3219210 B.Chen 9 Kings Rd. St Kilda 6/05/1961 14 Bradman Av, CX Capital (03) 99876543 B4351220 S.Waugh 5/5/1972 Central Coast ΜΑ Miracle (02) 98098761 B3219210 B.Chen 9 Kings Rd. St Kilda 6/05/1961 Pilot_Age Plane_ID Year Made Model Capacity Max Range 52 CX747021 1990 747 410 15,000km 48 UGDC810 1987 DC8 150 11,000km 44 MA737T1 1995 A310 220 9,000km 33 CX747021 1990 747 410 15,000km 44 MA747T5 1996 747 410 15,000km (a) Normalise the above spreadsheets to tables in third normal form (3NF). Specify the primary key and foreign key (if any) for each table. (5 marks) (b) Develop an Entity-Relationship Diagram (ERD) from the tables in (a)? (10 marks) The Airport Authority of Utopia maintains a spreadsheet to store information about airlines, pilots and planes. There is only one airport but several airlines use it. The airport employs you as consultant to develop a simple database system. You are required to normalise the following spreadsheet and create an Entity-Relationship Diagram (ERD) to match the resulting tables of the data normalisation process. The following are some sample data on the spreadsheet. Airline_ID Airline_Name Airline_Phone Pilot_LicNo Pilot_Name Pilot_Address Pilot_DOB CX Capital (03) 99876543 A1567832 H.Simpson 12 Smith Rd. Sydney 4/12/1953 UG United (02) 94212321 A1786542 A.Khan 7 Cedar Pl. Ryde 22/10/1957 ΜΑ Miracle (02) 98098761 B3219210 B.Chen 9 Kings Rd. St Kilda 6/05/1961 14 Bradman Av, CX Capital (03) 99876543 B4351220 S.Waugh 5/5/1972 Central Coast ΜΑ Miracle (02) 98098761 B3219210 B.Chen 9 Kings Rd. St Kilda 6/05/1961 Pilot_Age Plane_ID Year Made Model Capacity Max Range 52 CX747021 1990 747 410 15,000km 48 UGDC810 1987 DC8 150 11,000km 44 MA737T1 1995 A310 220 9,000km 33 CX747021 1990 747 410 15,000km 44 MA747T5 1996 747 410 15,000km (a) Normalise the above spreadsheets to tables in third normal form (3NF). Specify the primary key and foreign key (if any) for each table. (5 marks) (b) Develop an Entity-Relationship Diagram (ERD) from the tables in (a)? (10 marks)
Expert Answer:
Answer rating: 100% (QA)
a The relation is already in 1NF since it does not have any multivalued attributes The functional ... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Is it accurate to say that there is only one correct answer to every tax research question? Discuss the reasoning for your response. In what ways does your answer affect how the tax research process...
-
There is only one labour market in Profunctia. All workers have the same skills, and all firms hire workers with these skills. Use the accompanying diagram, which shows the supply of and demand for...
-
If in an economy: (a) Consumption function is given by C = 100+ 0.75 Y, and (b) Autonomous Investment Is 150 crores. Estimate (I) Equilibrium level of Income and (ii) Consumption and Savings at the...
-
In a recent survey, 80% of the community favored building a police substation in their neighborhood. If 20 citizens are chosen, what is the mean and standard deviation for the number favoring the...
-
Joshua Hill, Bates & Hill Fabricators production manager, has just completed the companys production budget for the first quarter (see Exercise 5-11). He has identified the following monthly expenses...
-
Explain how a redox reaction involves electrons in the same way that a neutralization reaction involves protons.
-
How to establish the terms of the attorney-client agreement?
-
The comparative balance sheet of Morston Educational Supply at December 31, 2016, reported the following: Morstons transactions during 2016 included the following: Requirements 1. Prepare the...
-
Project Management Information Systemis a [tool] for managing projects. The tools and procedures used to acquire, integrate, and distribute the outputs of process improvement procedures make up a...
-
Get It Right, CPAs, has been retained to review its client's corporate formation calculations for 20XX. Maria, Roger, and Novak created Grassroots Tennis, Inc. (GTI), which began operations on March...
-
What is the semiannual coupon payment for a 12% bond with a $1,000 par? A) 60 B) 12 C) 240 D) 120
-
The following particulars are given: current unit price, 1,000; unit variable cost, 500; fixed costs, 30 lakh. The following two suggestions are under the consideration of the management of an...
-
Purchasing power parity and the Argentine currency board (C). In 2002, Argentina suffered from inflation at the rate of 25 percent (still 1. 5 percent in the United States): a. What should be the...
-
The demand for output of a certain company is very elastic and a modern plant recently installed is capable of greatly increased production. Output at present is 80,000 units per year, and 5 lakh...
-
The sales of Forma Ltd. in the first half of the current year amounted to 2,70,000 and profit earned was 7,200. The sales in the second half year registered an increase and amounted to 3,42,000. The...
-
If we define an effective collision frequency ef () such that the longitudinal electric conductivity is given by then, by comparison with (2.18), we find that (a) Show that in the low-frequency...
-
Evaluate (8) (9) 5x+6ydydx =
-
CdF2 (s) Cd+ (aq) + 2 F- (aq) 1. A saturated solution of CdF2 is prepared. The equilibrium in the solution is represented above. In the solution [Cd+] eq = 0.0585 M and [F-] eq = 0.117 M. a....
-
Consider the hypothetical reaction A + B + 2C 2D + 3E In a study of this reaction, three experiments were run at the same temperature. The rate is defined as 2d[B]/dt. Experiment 1: [A]0 = 2.0 M [B]0...
-
The initial rate of a reaction doubles as the concentration of one of the reactants is quadrupled. What is the order of this reactant? If a reactant has a 21 order, what happens to the initial rate...
-
Draw all the structural isomers for C8H18 that have the following root name (longest carbon chain). Name the structural isomers. a. Heptane b. Hexane c. Pentane d. Butane
-
You have just been telephoned by the chief accountant of a listed company client, Randerston plc, to tell you that there has been a computer breakdown and that some parts of the data concerning...
-
Consider the following situations: (a) Assume that you are a partner in a two partner practice with total practice income of 250 000. One of your clients (a private limited company with a turnover of...
-
You have been asked by your audit partner to be senior in charge of the audit of a small public limited company. Unbeknown to the partner, you hold 1000 of the 100 000 shares in the company. Do you...
Study smarter with the SolutionInn App