Air Discount!
What is Air Discount?
A website with database for people searching for cheap air tickets. Users can search with leave city, arrive city and the departure time to get the specific results. When there are multiple results of the specific searching, users can sort them by departure time or arrive time or ticket prices.
What does Air Discount do?
Figure 1 shows the use case of our website.
Figure 1: UML Diagram of Air Discount.
Framework
Figure 2 shows the structure of our system.
Figure 2: framework of Air Discount.
Database Design & Implementation
ER Diagram
Figure 3: ER Diagram of Air Discount.
Normalized 3NF Relations
- Users (UID, password, username, firstname, lastname, email);
- (UID) → (password, username, firstname, lastname, email)
- Tickets (TID, name, leavecity, arrivecity, leaveairport, arriveairport, leavetime, arrivetime, capacity, price);
- (TID) → (name, leavecity, arrivecity, leaveairport, arriveairport, leavetime, arrivetime, capacity, price)
- Orders (OID, TID, UID); (OID) → (FID, UID)
- Passenger (PID, firstname, lastname, DOB, TID);
- (PID) → (firstname, lastname, DOB, TID)
Screenshoot of our database
Figure 4: Screenshoot of our database
Demo
Figure 5 presents the index page of our website. Users can search air tickets without log in on this page. They can also choose to login on this page.
Figure 5: Home page of Air Discount.
In this case, we search the flight tickets from Miami to Boston, there are four air tickets show up in the result page figure 6. The information of air tickets including flight number, departure time, arrive time, number of remaining seats and price can be seen. Additionally, the results can be sorted by price, arrive time and departure time. In figure 6, the results are stored by price. Users just need to click on the button “SELECT” to buy tickets. If they are already logged in, they can go to the next step, otherwise they will be remained to log in or register.
Figure 6: Searching results of Air Discount.
In the page like figure 7, users can check the information of air tickets again and input their own information including first name, last name and date of birth to book the ticket. They only need to click on the “Confirm” button. Once the user confirms the booking, a new order will be generated and the related information will be saved into our database automatically. The number of remaining seats of this ticket will reduce by 1 at the same time. That is to say, if the capacity of a flight is 0, it cannot be booked any more, unless someone cancel his/her order.
Figure 7: booking page of Air Discount.
After booking process, users can click on “My Account” to check their order. In the page as shown in Figure 8, they will see all air tickets they booked. Additionally, they can cancel their trip through click the “cancel” button. And the number of remaining seats of this ticket will change in database with users’ operation.
