203150 Restaurants reservations

SCOPE OF PROJECT : To manage restaurants reservations for multiple outlets, print receipts for reservations, change, modify, cancel reservations, based on date, dining seatings, capacity, in a multiuser web environment. BACK-END : PHP+MYSQL+AJAX FRONT END: Explorer and Firefox FLOW : 1. Define restaurants 2. Define seatings per restaurant 3. Define capacity per seating 4. Define users and superusers 5. Add, Search, Modify, Cancel Reservation 5a. Lookup external database (Room Number, Name, Check-in, Check-out - view provided MSSQL) 6. Define number of allowed reservations based on length of stay 7. Print reservation (40 cols printer) with instructions (5 languages to choose from at time of printing) 8. Print daily reservations per restaurant SUPERUSER: - Can override max capacity - Can block seatings - Can close restaurant MAIN VIEW : Should be a snapshot of availability of today's seatings for all restaurants Should be possible to advance in the future day by day WHY AJAX : - Fill fields after lookup on external database - Snapshot updated if other user modify situation