This project revolves around the dual focal points of efficiently managing flight schedules and systematically generating reports for B Airways. By optimizing scheduling and enhancing reporting processes, the aim is to elevate operational efficiency and provide essential insights for informed decision-making by the airline's management.
This project served as an excellent learning opportunity for students associated with the University of Moratuwa, providing hands-on experience in implementing database management concepts. It emphasized system design, data integrity, and query optimization within a practical, real-world context.
Our team successfully navigated the complexities of the project, demonstrating expertise in documentation, functional and non-functional requirements, and effective database planning. The collaboration fostered a positive environment for collaborative work and knowledge exchange.
Secure Sign-In
Users can easily register for the application by filling out a form that includes essential details. The system verifies and saves the information in the database, and upon completion, a confirmation email is sent to the user.
Booking a flight
Under the "booking a flight" section passengers can;
Two extra parameters should be considered by the system when determining the ticket price.
View passenger flight details
The system allows registered passengers to view their flight details, including the details of the most recently received flight.
Add new Airport
Flight dispatchers can add the new flight destination details through this feature of "Adding Airports"
Add new planes.
Flight dispatchers can add the new plane details through this feature of "Adding new Flights"
View all flight details
The system allows the flight dispatcher to view all flight details. and they can search by the flight ID, destination, and origin
Request for Reports.
The system allows airline administrators to generate several reports using the flight details and other details on the databases. The reports are described as follows,
Sathira Liyanapathirana
Undergraduate from Department of Computer Scinece Engineering.
University of Moratuwa
Sahan Caldera
Undergraduate from Department of Computer Scinece Engineering.
University of Moratuwa
Harshani Bandara
Undergraduate from Department of Computer Scinece Engineering.
University of Moratuwa
Yasith Heshan
Undergraduate from Department of Computer Scinece Engineering.
University of Moratuwa