Question: 3 Based on thefollowing 3 NF relations, . Dash underline all foreign keys and draw arrows from FKs to PKs . Convert the relation into

3 Based on thefollowing 3NF 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)
Schedule(schedule num, flight number, flight date)
Reservation(reservation 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!