Hi, I am working on this hotel booking website
I have the following tables:
booking (bookingid,arrival,departure,roomid,customerid)PK bookingid
customers (customerid,firstname,lastname,address)PK customerid
rooms (roomid,roomnumber,roomtypeid) PK roomid
roomtypes (roomtypeid,roomtype,numbeds,priceper night)PK roomtypeid
roomtypeid has 1 for single, 2 for double, 3 for twinbed, 4 for triple
I hope this is right.What I need is to check room availability on a certain date to/from.
Since there are no bookings at the moment all rooms should be available.Also is not clear to me how to select
a roomtype on a given date.Thanks a lot.