The current date and time should be system generated. Individual reservations should also be retrievable. A retrieved reservation may be cancelled. Advance reservation prices are for those who make a 14-day advance purchase but are not among the first 10 reservations. All others pay full price.
All prices are system controlled and there can be no manual overrides.
Seat assignments can be made at the time of reservation. Customers can request window or aisle seating. Customers already booked for the flight may be able to view information about all seats available on a flight. The best setup for this would be to provide information using a picture with seats that are taken and those that are available. Data Create an Access database with relevant tables.