A simple airline booking system implemented in Python using Oracle SQL.
- Login Screen
- Searching for flights
- Making a booking
- List existing bookings
- Cancel bookings
- Logout
- Record flight departure
- Record flight arrival
- Search and book round trips
- Search and book with upto 3 connecting flights
- Search and book for parties larger than 1
- airports(acode, name, city, country, tzone)
- flights(flightno, src, dst, dep_time, est_dur)
- sch_flights(flightno, dep_date, act_dep_time, act_arr_time)
- fares(fare, descr)
- flight_fares(flightno, fare, limit, price, bag_allow)
- users(email, pass, last_login)
- passengers(email, name, country)
- tickets(tno, name, email, paid_price)
- bookings(tno, flightno, fare, dep_date, seat)
- airline_agents(email, name)
System documentation can be found in the wiki.
Licensed under Apache 2.0 License.