Coaches Round Table

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

  1. Room number? Total expenses that the customer owes?
  2. kitchen table bar table
  3. 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)- ?
  4. 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)
  5. TOTAL RUPEES THAT THE CUSTOMERS OWN THE ITEM
  6. 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