Are PK Flight number & Passenger name? Since each passenger has a unique name. Maybe pilot name is also primary key?

The travel office at Pilot Training College maintains information about flights pilots, and passengers. You have been given the following assumptions: . A flight has a unique flight number, a passenger has a unique name, a pilot has a unique name 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: Flight (flightnumber flighttime, airelinename, passengername, pass gender pass _dateobirth, pilotname, pil_gender pil dateofbirth, departure city, arrival city, planeid, plane type, seats). Answer the following questions: What is the PK for this relation in its current state? (3 pts) What Normal Form is the current state of this relation? (3 pts) Perform the following Normalization steps: e Draw a dependency diagram showing all functional dependencies in the relation, based on the relation you have been given. (8 pts) EXAMPLE List the partial and transitive dependencies. (6 pts) EXAMPLE Partial Dependencies No Partial Dependencies Transitive Dependencies JOB CLASS emp base salary e Convert the relation to 3NF. (Hint: You might have to create a few new attributes to make sure that the relations contain attributes that meet proper design criteria; tha s, make sure there are no composite or multivalued attributes and that the naming conventions are met.) Write the corresponding relational schemas for each new relation. Identfy each rimarv kev and each foreion k Open With Print