- database solutions and downloads for microsoft access

Microsoft Access Data Model Example

Holiday Cottage Bookings Scenario

The following data model is designed to hold information relating to a holiday cottage bookings. For this scenario we need to define the following facts:

These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.

The draft facts have been defined as:

The Entities required should include:

  • Clients
  • Cottages
  • Bookings
  • Cottage Facilities
  • Price Bands
  • Regions

The Entities are related as follows:

  • A Client can Book One or Many Cottages
  • A Cottage may have One or Many Bookings made for it
  • A Region may contain zero, one or many Cottages
  • A Cottage may have zero, one or many Facilities
  • A Facility may be associated with zero, one or many Cottages
  • A Cottage can have Many Prices associated with it (different prices apply to different times of the year)
  • A Band (Rating applied) can have zero, one or many Cottages

When asking questions of the database we may need to know:

  1. Do you have a holiday cottage in a certain region of a particular band (rating)?
  2. Is a particular cottage booked at a given date in the year?
  3. Do you have any available cottages with a swimming pool (Facility) available?

The following data model allows these questions to be answered and allows the information contained above to be stored logically and in a structured manner.

To view the model please go to: Relationships for Holiday Cottage Rentals Data Model

Please download the data model relating to Relationships for Holiday Cottage Rentals which is contained in the zipped up Microsoft Word document.