To-Do's

[marc726]

1. User functionality (25 points)

• let people search for flights between two airports
  • one way on a specific date
  • round-trip on specific dates
  • one way or roundtrip on flexible dates (+/- 3 days)
• browse the resulting flights
• sort flights by different criteria (price, take-off time, landing time, duration of flight)
• filter the list of flights by various criteria (price, number of stops, airline, take-off time,
  landing time)

---

(25 points)

• Browse questions and answers
• Search questions and answers by keywords
• make flight reservations/buy the ticket.
• enter the waiting list if the flight is full
• view all the past flight reservations with their details
• view all the upcoming flights with their details
• cancel their flight reservations (if it is business or first class)
• send an alert to customers in the waiting list that there is an empty seat
• post questions to the customer representative

---

2. Admin (25 points)

(create an admin account ahead of time)

• Add, Edit information and Delete a customer representative or customer
• Obtain a sales report for a particular month
• Produce a list of reservations by flight number or by customer name
• Produce a summary listing of revenue generated by a particular flight, airline, or
  customer
• Find out which customer generated most total revenue
• Produce a list of most active flights (most tickets sold)

---

3. Customer Representative (25 points)

• Make flight reservations on behalf of users
• Edit flight reservations for a customer
• Add, Edit, Delete information for aircrafts, airports, and flights
• Retrieve a list of all the passengers who are on the waiting list of a particular flight
• Produce a list of all flights for a given airport (departing and arriving)
• Reply to user’s questions