Hello, I want to design a database for a hotel booking systems. The hotel has 3 types of rooms. Single room , double room , triple room. I must be able to manage bookings , set different prices for rooms for different dates , see what rooms are available at a certain date range , make bookings online for a certain date I was thinking for tables like this Customer ---------------- ID Name Surname ... ... Settings ---------- No_Singles No_Doubles No_Triples Prices ---------- Date Single Price Double Price Triple Price I don't know how to design the bookings table and the availability table. Any suggestions would be much appreciated. P.S the interface should look smth like this http://rc-deco.foedus.net/default.cfm Thanks
As you are asking for db design, I can make you the structure of tables without any data or design, for free of course(Thats a quick job) . PM if you'r interested.
Tables: Customers, Bookings, Prices/Catalog - whatever you want to call it Customers stores all the customer details with an ID Catalog stores all the "products/services" such as Single room and price + an ID Bookings table basically has the customer_id field and the catalog_id field and a price modifier(like how many days?), start date/end date etc So when admin or someone wants to check the bookings, it loads from the bookings table, and using the IDs it takes the customer data and catalog data and modifies it with how many days he want to book Hope this helped.
You are setting yourself a fairly hard project.... anything date based like this is complex to program with getting the logic correct to ensure that you arent either double booking or declining business when there will be free rooms.
Hi bbrock32, Google is your friend I found these which might give you some ideas on how to take your project forward: http://www.databasedev.co.uk/hotel_room_booking_system_data_model.html http://forums.devarticles.com/database-development-6/hotel-booking-database-design-10320.html HTH, Petey