|
Choosing the tables that belong in the database
After learning the questions users will ask the database, you think about how your database should be structured to best answer their questions. The first step is to choose the tables in the database.
In a relational database, all data is represented in the rows and columns of tables. Each table describes a collection of related entities such as persons, objects, or events. Each row describes one occurrence of the entity and each column describes one property of the entity—for example, a person's last name, an object's weight, or an event's date.
You choose the following seven tables for the Arrow Aircraft database:
 |
an aircraft table describing all of the business jets managed by Arrow Aircraft |
|
an aircraft bookings table listing all the dates the jets are booked or otherwise unavailable to fly |
|
a shareholders table describing all the corporations and individuals who own shares in the jets |
|
a pilots table describing all the qualified captains and co-pilots available to fly the jets |
|
a pilot bookings table listing all the dates the pilots are booked or otherwise unavailable to fly |
|
an itineraries table describing all the itineraries requested by the shareholders |
|
a flights table describing all the legs of the itineraries. |
| 
