Using draw.io create an ERD diagram of the MariaDB database called database.drawio that satisfies the requirements in Project.pdf. Put the diagram in the diagrams folder on the Google Drive. The diagram should should be in 3.5 normal form (Boyce-Codd normal form), including primary keys for each table, foreign keys for references to other tables, and no data stored redundantly. You will also need to choose suitable MariaDB datatypes for all data stored. Remember to use the DECIMAL datatype for money.
Data storage minimum requirements (except from Project.pdf):
For each flight, record: flight number, data of flight, departure airport, destination airport, number of passengers, scheduled, departure time, actual departure time, scheduled arrival time, actual arrival time, aircraft tail number.
For every passenger: source airport, destination airport, flights taken (flight number, source airport, destination airport, scheduled departure time, actual departure time, scheduled arrival time, actual arrival time).
For each airport: arrival time of each aircraft, flight number as arriving aircraft, number of arriving passengers, departure time of each aircraft, flight number as departing aircraft, number of departing passengers, gate used, aircraft tail number.
For each aircraft: aircraft tail number, for each flight: date of flight, flight number, departure airport,
destination airport, departure time, arrival time, number of passengers.
Other possible tables: an Aircraft table with aircraft stats, an Expenses table with the cost for gas and landing/takeoff fees based on location (US vs Paris)
Summary
Using draw.io create an ERD diagram of the MariaDB database called
database.drawio
that satisfies the requirements inProject.pdf
. Put the diagram in thediagrams
folder on the Google Drive. The diagram should should be in 3.5 normal form (Boyce-Codd normal form), including primary keys for each table, foreign keys for references to other tables, and no data stored redundantly. You will also need to choose suitable MariaDB datatypes for all data stored. Remember to use the DECIMAL datatype for money.Data storage minimum requirements (except from
Project.pdf
):For each flight, record: flight number, data of flight, departure airport, destination airport, number of passengers, scheduled, departure time, actual departure time, scheduled arrival time, actual arrival time, aircraft tail number.
For every passenger: source airport, destination airport, flights taken (flight number, source airport, destination airport, scheduled departure time, actual departure time, scheduled arrival time, actual arrival time).
For each airport: arrival time of each aircraft, flight number as arriving aircraft, number of arriving passengers, departure time of each aircraft, flight number as departing aircraft, number of departing passengers, gate used, aircraft tail number.
For each aircraft: aircraft tail number, for each flight: date of flight, flight number, departure airport, destination airport, departure time, arrival time, number of passengers.
Other possible tables: an
Aircraft
table with aircraft stats, anExpenses
table with the cost for gas and landing/takeoff fees based on location (US vs Paris)Group Questions
Foobar?