Creating your MySQL Database: Practical Design Tips and Techniques

Preliminary List of Data Elements

We list here the data elements as they can be deduced from the document gathering phase. In many cases, they are not in a format already suitable for the final model because they are prefixed with a table name. For example, a data element identified as pilot_last_name will become the column last_name in the pilot table. Sample values and more detailed information about each data element appear in the next section.

Data elements
flight_departure_moment	seat_id
flight_arrival_moment	plane_section
departure_airport_code	ticket_refundability
arrival_airport_code	gate_id
airline_code	boarding_time
airline_name	max_number_in_cabin_bags
airport_name	max_number_registered_bags
plane_brand	max_weight_registered_bags_kg ...