To prepare the list of tables, we start with the physical objects or persons we can observe in the sentences built from the documents gathering phase. Then we have a look at all the elements and build new tables to accommodate them.
In the following table descriptions, the table layout is followed by design comments when appropriate.
Usually the following tables are designed first because they are easier to model and they are needed for establishing the relations from more complex tables.
|
table: airport |
column name |
sample value |
|---|---|---|
|
*id |
1 | |
|
international_code |
YUL | |
|
description |
Montreal-Trudeau |
The airport table could contain other columns like the address, phone, and website.
|
table: airline |
column name |
sample value |
|---|---|---|
|
*id |
1 | |
|
description |
Air-Quebec |
|
table: plane_brand |
column name |
sample value |
|---|---|---|
|
*id |
1 | |
|
description |
Fontax |
We avoid naming this table as brand because it's a too generic name.
|
table: meal_supplier |
column name |
sample value |
|---|---|---|
|
*id |
9 ... |