What tables should be included in a database for a hotel?
For my ICT coursework I need to create a database that could be used for a hotel. I need to include 3 tables. The first table will be Customer table, which will include details about the customer... What could I include in the other 2 tables?
Public Comments
- Room number? Total expenses that the customer owes?
- kitchen table bar table
- Bookings By Month: Hotel rooms booked for this month - ? hotel rooms not booked for this month - ? and Costs By Month: income revenue (from rooms booked) - £? lost revenue (from rooms not booked)- ?
- a Table for Rooms (all about each room including who is currently in each room and the rooms condition / reported problems / history etc) a Table for Bookings (link to customer and rooms tables including all details about how and where the booking was made and paid for and the duration of stay etc etc)
- TOTAL RUPEES THAT THE CUSTOMERS OWN THE ITEM
- How about any of these... Bookings (# of Occupants, # of Rooms, etc...) Customer_Feedback (Compliments/Complaints) Sales (Revenue, AvgRoomRate etc..) {Not all bookings will be completed}
Powered by Yahoo! Answers