table: passenger column name sample value *id 1302 (Starting a web site)
table: passenger column name sample value *id 1302 last_name Smith first_name Peter passport_info CDN234234 table: crew column name sample value *id 9 category_id 1 last_name Murray first_name Dan Passengers and crew members cannot be physically merged into one table even if they belong to the same flight because the set of columns used to describe a passenger diverges from the one associated to a crew member. We’ll cover in the Sample Queries section how to produce a combined list of all persons on a plane. table: flight column name sample value *id 34 airline_id 1 number 456 departure_moment 2007-10-02 22:45 arrival_moment 2007-10-03 11:30 departure_airport_id 1 arrival_airport_id 2 plane_id 302 meal_supplier_id 9 number_meals 2 departure_gate 74 arrival_gate B65 boarding_moment 2007-10-02 22:10 status_id 1