- This project is built for "IS211" course project submission.
- Project requirements are declared by "IS211" course instructor.
- The project aims to test relational databases knowledge and implementation.
- MS SQL server is used as the database management system.
- Conceptual and Physical ERD.
- SQL server database generated from the physical ERD with populated data.
- Both customer and admin should be able to sign-up and log-in to the system.
- The admin should be able to add flights and aircrafts, update their details, and
show a list of available flights that satisfy certian critera (e.g. date, source,
destination, number of seats, etc) - Customer should be able to update his profile data, see list of available flights
that satisfy certain criteria (e.g. date, source, distination, number of seats, etc),
and perform operations on flights: booking, cancelling, changing flight class.
- Admin can view a summary of registered customer, number of flights, aircrafts, and tickets.
- Every flight may have a flight leg which is added by the admin.
- Both customer and admin can view the flight legs info if exists in a flight.
- Customer can view all his reserved tickets, choose specific ticket and change its class type
(business, economy, first).
Authors
- Yousef Eldaly -YousefEldaly
- Fatma Elzahraa Ashraf - fatmaashraf1
- Yousef Ezzat Mohamed -Youssef18118
- Howida Adel Abd El-Halim -howidaabdelhalim
- Nour Tarek Sayed -NourTarek201