table: plane_section_seat column name sample value (Web hosting packages) *airline_id 1
table: plane_section_seat column name sample value *airline_id 1 *brand_id 1 *model_id 2 *section_id 1 *seat 19A The plane_section_seat table describes which seats are located in a specific section of the aircraft. This is per airline, brand, model, and section, because different airlines could possess the same kind of aircraft but use different seat numbers or have a larger business section than others airlines. Also, in some cases, seats 1A and 1C may exist but 1B may not. Thus, we need this table to hold the complete list of existing seats. table:flight_crew column name sample value *flight_id 34 *crew_id 9 With these sample values, we can deduce that Dan Murray is the pilot for flight 456 of Air-Quebec. Another possible column in this table would be the status of this crew member for this flight: arrived on time, cancelled, or replaced. table: plane_event column name sample value *plane_id 302 *event_id 1 *start_moment 2008-10-01 end_moment 2008-10-31 table: reservation_registered_ bags column name sample value *flight_id 34 *passenger_id 1302 *tag AQ636-84763 Other columns for tag tracking could be added here.
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check Vision professional web hosting services