More Answers because of FDs
ws(Date,From,To,Pilot,Aircraft)
=> flight(Airline,Flight_no,From,To) & schedule(Airline,Flight_no,Date,Pilot,Aircraft)
Functional dependencies:
Pilot Airline
Aircraft Airline
ws
Date From To Pilot Aircraft
08/28 sfo nrt mike #111
08/29 nrt sfo ann #111
09/03 sfo fra ann #222
09/04 fra sfo john #222
… … … … ...
Previous slide
Next slide
Back to first slide
View graphic version