Member Avatar for twity

Hi there,
I am designing database for a room reservation website. I have designed database such as:
RoomDetail(RoomNo#,RoomType,RoomStatus)
RoomTypeDetail(RoomType#,Description,rent)

Now I want reservation which handles for any pre-booking, on the spot booking. What modification is required in RoomDetail or a new database ......
I am really confused
Pl I am looking for help.

Thank you

  • 2 Contributors
  • 1 Reply
  • 85 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by timothybard
Member Avatar for timothybard

I would recommend a new table that has fields to track the following:

Room, Customer, Check-In Date, Check-Out Date

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.