You need to enable JavaScript to run this app.
CS5021-1 Group 7
Flight School Management Database
Introduction
Show Recommended Aircraft
Create Reservation
Aircraft Data
Sample Queries
Soonest Annual
View the Most Worked Mechanic
View the Most Frequently Flown-together Customer and Instructor Pair(s)
View the Most Flown Aircraft
View the Most Worked Instructor
Select Aircraft with more than 15 Reservations
Select all Customers with Unpaid Invoices
Select Customers with more than 5 Reservations but no Invoices
Select Customers with Reservations but no Payment Info
Select Instructors with Upcoming Reservations
Show HP Reservations' Customers' Ratings
Show .edu Emails
Categorize Customers
Aircraft Data
Sample visualization of the number of each class of aircraft the flight school has using d3.js.
Run query