Question: It is just this one question that are good cha Answer the following question based on the following, 5-relation Federal Aviation Administration (FAA) database. Airport
It is just this one question

that are good cha Answer the following question based on the following, 5-relation Federal Aviation Administration (FAA) database. Airport Initials, Airline Initials, and Airline Serial Number are unique across the database. Runway Names are only unique within airports. The service relation shows that number of flights of a particular airline that originate from a particular airport each day and the year that the airline began service at the airport. The entries to the left of the tables (e.g. A3, L1) are solely for row identification purposes in the questions below and are not part of the logical data of the table. Airport Initials Airport Name City State DFW Dallas-Ft. Worth Dallas TX A2 JFK Kennedy Inti New York A3 LAX Los Angeles Intl Los Angeles A4 MEM Memphis Memphis MIA Miami Int Miami Airport Relation Airline Initials Airline Name HQ City HQ State American Airline Dallas L2 Delta Atlanta L3 NW Northwest Minneapolis MN TW Trans World St. Louis MO UN United Chicago Airline Relation Runway Airport Initials Length Year Built Name (Feet) R1 4 Left MIA 1200 1958 R2 5 Right DFW 1500 1984 R3 5 Right LAX 1500 1984 R4 5 Right MEM 1000 1962 R5 7 Left JFK 1700 1960 R6 7 Left MEM 1500 1989 R7 8 Right LAX 1500 1984 Runway Relation Serial # Type Capacity Airline Initials Manufacturer 01754 747 250 TW Boeing 04970 727 130 Boeing P3 17594 DC-10 180 AA McDonnell-Douglas P4 18113 MD-11 230 McDonnell-Douglas P5 26040 MD-11 230 McDonnell-Douglas P6 35891 A320 130 Airbus Intl P7 48645 747 220 Boeing Airplane Relation Airline Airport Initials Flights per First Year Initials Day DFW 160 1978 AA LAX 1935 S3 $4 dd: DFW 8 1978 JFK 1952 $5 NW LAX 20 1954 S6 NW MEM 125 1948 TW JFK 45 1957 3 LAX 1930 Service Relation 3.1) How many relations have no foreign keys? 3.0) Draw an ERD that represents the 3.2) How many foreign keys are there in the service relation? 3.3) How many candidate keys are there in the runway relation? 3.4) According to cascading deletion rule, what will happen if an attempt is made to delete record L3? (See page 161 for reference) 3.5) The deletion of which of the following records has a potential to cause a referential integrity problem, assuming that the rest of the data in the database remains the same? (A1, A2, A3, All of above, or None of above)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
