Happy Holidays (HH) is a Caravan Park operator who has employed you to develop an Information System to manage caravans, caravan bookings and people working at each site.

The capacity of the sites ranges between 30 and 150 caravans. Currently they exist in 3 locations in North England and are planning to open parks in the South of England and Scotland in future.

The parks are run by Happy Holidays staff (frontdesk, estate staff and cleaner) who work on a shift (see section 8.7 for the schedule). Each site has a mixture of caravans which can be rented by customers for a minimum of 7 days. Some caravans are owned by Happy Holidays and the rest by private owners. Caravan owners are expected to pay an annual ground rent for their pitch (caravan pitch). Each owner is dealt with by a Happy Holidays Owner Manager at the site. It is not unusual for an owner to have more than one caravan usually at different site. Caravans owned by HH for rent belong to one for the following category: bronze, silver, gold etc... Each category will have a different rental tariff which shows the different prices depending on the time of the year.

Caravan Park sites and caravans vary, in the facilities they offer and are priced accordingly. For example, caravans will have different number of berths (beds); some have satellite TV and DVD players, etc.... Sites are graded according to their facilities e.g. Swimming pool, restaurants, baby-listening, and fishing.

The Happy Holidays system is used to keep track of bookings made by customers. Bookings are taken by phone or on-line when facilities are matched to customer requirements so that the most appropriate caravan can be allocated.

Customers pay a 20% deposit at the time of booking and the remaining balance is due 4 weeks before the holiday date. Deposits are lost in this last month if the balance has not been paid or the customer cancels their holiday 4 days before holiday starts.

Happy Holidays management is aware of the amount of data they are holding in the booking system and believe that this could be used to produce some good reports for management.

EXAMPLE OF REPORTS:

· To be able to retrieve records of the total number of staff at a specific location.

· To be able to list all customers staying in a particular caravan in March 2015.

· To be able to list facilities each caravan site has to offer.

· To be able to identify most popular caravan pitch.

· To be able to calculate the total of the "lost" deposits per month.

· To be able to identify customers who have their caravans at more than one site.