Supplemental Case (Php web hosting) Study [ 76 ] airport_name flight_departure_moment
Supplemental Case Study [ 76 ] airport_name flight_departure_moment We need to indicate whether the airport is for departure or arrival. The airport code for Montreal-Trudeau is YUL and the one for Charles de Gaulle is CDG. The data element obtained from the above sentence is: airport_code Should we use the airport_code as a primary key? Maybe not, due to space considerations. This flight is scheduled to land at 11:30 the day after (local time). The data element obtained is: flight_arrival_moment Do we need to split the date and time into two fields? Probably not, to benefit from date and time calculations functions (how many hours and minutes takes a flight, taking the date into account). An aircraft model APM-300 from Fontax services this flight. The data elements obtained from above sentence are: plane_model plane_brand Do we need to associate the plane model to a flight, but also to which specific plane. (There can be more than one APM-300.)