Computer Science Final Project database

Criteria

Points

Add:

· Add a new flight to the system.

· Add a new Day for flights to the system.

+20

1- (+10)

2- (+10)

Status Customer

· Display the flight and day for each flight the customer has booked

· Display the flight and day for each flight the customer has waitlisted for.

+10

1- (+7.5)

2- (+2.5)

Cancel Customer Day:

· The booking for that Customer and Day must be removed from the flight’s bookings or the waiting list.

· If the booked entry is removed from a flights bookings, the waiting list must be checked to determine if another customer can be booked with that flight for that day, and if there is, the customer should be moved from the waitlist to the booking.

+30

1- (+15)

2- (+15)

Drop Flight:

· Remove a flight from the application.

· Any customers that have been booked for this flight on any day must be rebooked with another flight for that day

· If the customer cannot be rebooked, the user is informed that the customer could not be rebooked.

· Any customers on the waitlist for that flight must also be deleted.

+30

1- (+10)

2- (+12.5)

3- (+2.5)

4- (+5)

GUI:

· The results of any action are displayed to the user immediately after the action is performed without the user needing to check Status.

· All affected combo boxes are updated immediately after each action is performed.

+10

1- (+5)

2- (+5)