Skip to Content
Creating your MySQL Database: Practical Design Tips and Techniques
book

Creating your MySQL Database: Practical Design Tips and Techniques

by Delisle
November 2006
Beginner to intermediate
108 pages
1h 57m
English
Packt Publishing
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

The MySQL Workshop

The MySQL Workshop

Thomas Pettit, Scott Cosentino, Dr. Vlad Sebastian Ionescu
Effective MySQL Replication Techniques in Depth

Effective MySQL Replication Techniques in Depth

Ronald Bradford, Chris Schneider
Database Design: Know It All

Database Design: Know It All

Toby J. Teorey, Tony Morgan, Thomas P. Nadeau, Bonnie O'Neil, Elizabeth O'Neil, Patrick O'Neil, Markus Schneider, Graeme Simsion, Graham Witt, Stephen Buxton, Lowell Fryman, Ralf Hartmut Güting, Terry Halpin, Jan L. Harrington, W.H. Inmon, Sam S. Lightstone, Jim Melton

Publisher Resources

ISBN: 9781904811305