Holiday Cottages

18 Jan 2011 - 8:27am
1321 reads
Posted in:

The firm Acme Holiday Cottages manage the lettings of holiday cottages. They started in a small way in a popular resort in a national park, but over the years they have developed the business to cover the whole region.


The business is managed from an office in Felltown where the two partners and a team of largely part time assistants answer telephone calls and email enquiries. The company has a web site but it only advertises the services provided and does not give up to date information about the accommodation available nor does it provide any facility for booking cottages. Customers are invited to telephone or email for more information.


A card index is held of every person that has made an enquiry, and the same cards record details of any bookings made. Enquiries from customers fall into three categories:

- a request for the current catalogue;

- a request to book a cottage for a particular date / area;

- a request to book a particular property.


The firm responds by:

- sending a copy of the latest catalogue;

- sending a list of suitable cottages;

- sending a booking confirmation and invoice.


The firm already has a Sage accounting system and does not want the new system to deal with chasing and recording payments, though the system should send copies of any invoices to the accounting system. The firm runs a recommendation scheme. If an existing customer recommends a new customer, both customers are entered into a quarterly draw for a free holiday. Details of the recommending customer are shown on the new customer%u2019s booking form. Owners wishing to have their property managed submit details to the firm. A report on the property is obtained from an estate agency in the area the property is located. When the report is received it is given a reference number and brief details entered in the Surveys Book. The report is considered by one of the partners and a decision made: - Whether to accept or reject the property; - the price category (A to E) for the property. When these decisions have been taken, the owner is notified of the result and a record card created for the property. (A further report on the property could be called for if there is a major change in the accommodation.) When a booking is made, a letter is sent to both customer and owner confirming the booking and details are entered into the bookings sheet for that property.


A new catalogue is produced by the partners in December each year and a copy is sent to all existing customers. A copy is also sent to customers (new or existing) who request one. In the past properties added during the year were included in quarterly supplements. the partners want the new system to be able to print out an up to date brochure at any time.




 two of the processesRead the scenario in Appendix 1 (Acme Holiday Cottages) and draw up entity relationship diagrams to show:

Read the scenario in Appendix 1 (Acme Holiday Cottages) and draw up data flow diagrams to capture the proposed system.

1) A context (or level 0) diagram [ 7 marks]

2) A full system (or level 1) diagram [15 marks]

3) Diagrams at level 2 for

(You can chose your own processes but make sure you are able to add more detail at this level)



(a) the real-world data model for the proposed system.

(b) the relational data model for the proposed system.


Syndicate content Get the feed