Book Image

Creating your MySQL Database: Practical Design Tips and Techniques

By : Marc Delisle
Book Image

Creating your MySQL Database: Practical Design Tips and Techniques

By: Marc Delisle

Overview of this book

For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right.
Table of Contents (12 chapters)

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

plane_model

tag_id

pilot_last_name

ticket_issued_on

pilot_first_name

number_meals

flight_attendant_last_name

web_site_quick_reference

flight_attendant_first_name

meal_supplier

passenger_last_name

plane_id

passenger_first_name...