Would Implement Relationships Shown Following Outline Microsoft Access Q37135734

How would I implement the relationships shown in the followingoutline in Microsoft Access?

AIRLINE AirlinelD AirlineName) FLIGHT(TriplD Year, Month, Day, DayOfWeek, AirlinelD, FlightNum, OrigAirport, DestAirport, Dep

AIRLINE AirlinelD AirlineName) FLIGHT(TriplD Year, Month, Day, DayOfWeek, AirlinelD, FlightNum, OrigAirport, DestAirport, DepartPlan, DepartDelay. TimePlan, TimeElapsed, TimelnAir, Distance ArrivalPlan, ArrivalDelay) OrigAirport foreign key to AIRPORT DestAirport foreign key to AIRPORT AIRPORT AirportID StateAbbr, County, City, Longitude, Latitude) StateAbbr foreign key to STATE STATE(StateAbbr, StateName Show transcribed image text AIRLINE AirlinelD AirlineName) FLIGHT(TriplD Year, Month, Day, DayOfWeek, AirlinelD, FlightNum, OrigAirport, DestAirport, DepartPlan, DepartDelay. TimePlan, TimeElapsed, TimelnAir, Distance ArrivalPlan, ArrivalDelay) OrigAirport foreign key to AIRPORT

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.