Question: 3 Based on thefollowing 3 NF relations, . Dash underline all foreign keys and draw arrows from FKs to PKs . Convert the relation into
Based on thefollowing NF relations, Dash underline all foreign keys and draw arrows from FKs to PKs Convert the relation into final ERD. You can use the text based representation.
Flight flight number, departing airport, arriving airport, departure time, arrival time
Scheduleschedule num, flight number, flight date
Reservationreservation code, passenger name, agent # schedule num, seat number
Agent agent number, agent name
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
