This project was done to demonstrate our mastery of the materials covered in the course.
The scope of the project involves:
- Developing the backend database using MySQL
- Developing the frontend web interface using Python, Flask, and HTML
- Designing the Relational Schema and ER Diagram
The code for the website interface can be found in webapp\app.py.
The export of our sample database can be found as airsystem_uniform.sql.
The Relational Schema can be seen in airline_relational_schema.drawio.pdf.
The ER Diagram can be seen in dbproj_ER.drawio.pdf.