... | ... | @@ -366,66 +366,8 @@ Acceptance Tests:<br> |
|
|
|
|
|
**Database Schema**
|
|
|
-----------------------------
|
|
|
**Database Schema**
|
|
|
This needs to be revised
|
|
|
<br>
|
|
|
<br>
|
|
|
Flight Route Schema:
|
|
|
<br>
|
|
|
<br>
|
|
|
Saskatoon——><———Toronto
|
|
|
|
|
|
Saskatoon———><——— Montreal
|
|
|
|
|
|
Saskatoon———><———Vancouver
|
|
|
|
|
|
Saskatoon———><———Los Angeles
|
|
|
|
|
|
*<Saskatoon——-><———Calgary>* [Departure Flight]
|
|
|
|
|
|
(**Calgary** is the connection airport for most international destinations)<br>
|
|
|
|
|
|
Calgary———><————-Seattle
|
|
|
|
|
|
Calgary——><——-Los Angeles
|
|
|
|
|
|
Calgary———><———Houston
|
|
|
|
|
|
Calgary————><———Yellowknife
|
|
|
|
|
|
Calgary———><———Chicago
|
|
|
|
|
|
Calgary——><———New York
|
|
|
![data_schema_template](uploads/c07d9039fa9e1b43821f97234b51fb7e/data_schema_template.gif)
|
|
|
|
|
|
Calgary——><——-Miami
|
|
|
|
|
|
Calgary——><——-Mexico City
|
|
|
|
|
|
Calgary——><——Cancun
|
|
|
|
|
|
Calgary——><——Paris
|
|
|
|
|
|
Calgary----><—-Frankfurt
|
|
|
|
|
|
Calgary——><—— London
|
|
|
|
|
|
Calgary———><———Barcelona
|
|
|
|
|
|
Calgary———><———Prague
|
|
|
|
|
|
Calgary——-><——Amsterdam
|
|
|
|
|
|
Calgary——><——Stockholm
|
|
|
|
|
|
Calgary——><——Rome
|
|
|
|
|
|
Calgary—><—-Munich
|
|
|
|
|
|
Calgary—-><—— Beijing
|
|
|
|
|
|
*<Calgary——><——Saskatoon>* [Return Flight to Calgary then back to Saskatoon]
|
|
|
|
|
|
<br>
|
|
|
|
|
|
|
|
|
|
... | ... | |