Data concept and design

$8$:$25$

$.$Il $52$

Holiday Cottage Bo$...$

Holiday Cottage Bookings

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:

$-$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 rating$($one$,$ two or more stars$)$ can be associated with zero, one or many cottages

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

Do you have a holiday cottage in a certain region of a particular rating?

Is a particular cottage booked at a given date in the year?

Do you have any available cottages with a swimming pool $($facility$)$ available?