Normalization The travel office at Pilot Training College maintains information

Question

Normalization The travel office at Pilot Training College maintains information about flights, pilots, and passengers. You have been given the following assumptions: flight has a unique flight number, a passenger has a unique name, a pillot has a unique name A A flight is handled by one airline .A flight can have multiple passengers, a passenger can be on multiple flights *A flight has one pilot, a pilot can operate multiple flights *A flight is always handled by exactly one airplane You have been given the following relation atdival city, planeid, planetme, seats) Answer the following questions: a. What is the PK for this relation in its current state? 1. b. What Normal Form is the current state of this relation?

Explanation / Answer

a) flightnumber, airlinename, passendername, pilotname, planeid --> It is a composite key

b)

Flight(flightnumber, flighttime, airlinename, pilot_id, planeid)

airline(airlinename)

passenger(passengername, pass_gender pass_dateofbirth)

pilot(pilotname, pil_gender, pil_dateofbirth, departure_city, arrival_city)

airplane(planeid, plane_type, seats)

flight_passengers(flightnumber, passenger_id)

Let me know if you have any clarifications. Thank you

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.