The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Hotel Bookings...
This data model was designed to handle Hotel Bookings.  (Note, there only tables included in this database the balance is up to you!)
Business Rules...

Booking periods will need to be tracked

Staff will be charged with *caring* for Rooms

Rooms will vary in size

Hotels have multiple Rooms

There will be multiple Bookings

Bookings can be done by Agents or (prospective) Guests

Rooms can have multiple Rates

Guest will be charged to Rooms

Main Entities...




A Guest or an Agent can book multiple rooms

There can be more than one Guest per room

Download Sample (Access 2007 and up and an unzipping program needed)

Rates can vary