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...
-
Below are transactions related to Duffner Company. (a) The City of Pebble Beach gives the company 5 acres of land as a plant site. The fair value of this land is determined to be $81,000. (b) 13,000...
-
Maria Martinez died in 2014, survived by her spouse, Sergio, and two adult children. Her gross estate, all of which passed under her will, was valued at $7.2 million. She had Sec. 2053 deductions of...
-
The following information is taken from the annual report of The Claremont Corporation: The company uses the LIFO method to value its inventory. In addition, the footnotes to the companys annual...
-
If a firm pays its bills with a 30-day delay, what fraction of its purchases will be paid in the current quarter? In the following quarter? What if the delay is 60 days?
-
Assume a company sells $ 1 9 . 9 million in gift cards in November, and customers redeem $ 1 2 . 9 million of the gift cards in December. Required: 1 . & 2 . Record the necessary entries in the...
-
The Nelson Company has $1,302,000 in current assets and $465,000 in current liabilities. Its initial inventory level is $305,000, and it will raise funds as additional notes payable and use them to...
-
Task 7 - Antenna Installation, safety and regulatory measures Safety and other regulatory requirements to which the wireless network area shall comply are identified, obtained and understood. Refer...
-
CNT Industries wishes to accumulate funds to provide a retirement annuity for its vice-president of research, Jennifer Mangan. Ms. Mangan will retire in exactly 12 years time. Upon retirement, she is...
-
Given a system of 4 processes with a set of constraints described by the following precedence relation: {(P1, P3), (P1, P4), (P2, P4)} The processes access memory locations according to the following...
-
In the context of Orica Ltd's operations in 2022, drawing from the insight that 'Managers regard relevance, accuracy, and timeliness as important characteristics of information. However, much of...
-
A child is sliding on a sled at 1.9 m/s to the right. You stop the sled by pushing on it for 0.80 s in a direction opposite to its motion. If the mass of the child and sled is 39 kg, what is the...
-
Kim works at a sports store and needs to determine the selling price for running shoes. The running shoes have a cost of $90. The manager asked Kim to price the running shoes with a 60% target gross...
-
Suppose there is, for whatever reason, an increase in the level of investment desired by business. For each of the two models (classical and Keynesian), say what will be the effect on the interest...
-
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
-
(a) What would you look for in a simplex tableau in order to conclude that a problem is unbounded? (b) What would you look for in a simplex tableau in order to detect a degeneracy? (c) What...
-
You may have thought of trying the method of Lagrange multipliers to find optimal solutions, since, after the introduction of slack variables into the standard maximum problem, the problem has the...
-
Consider the problem: (a) Sketch the feasible region, find the coordinates of the corner points, and find the optimal value. (b) Repeat (a) if the right-hand side constants are changed to \(6+h_{1}\)...
Study smarter with the SolutionInn App