Creare a database base:

Holiday Cottage BookingsThe following data model is designed to hold information relating to a holidaycottage 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 pricesapply to different times of the year$)$ A rating$($one$,$ two or more stars$)$ can be associated with zero, one ormany 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 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$?$