• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design specification for an IT system for Harry's Dog Kennel business.

Extracts from this document...


Transfer-Encoding: chunked Design Specification Details of what the system needs to do The system needs to help Harry do many things such as making it easier to find specific data , to save time . It must be easy to edit as Harry?s Boarding Kennels are constantly getting new dogs staying and new owners keeping their dogs there , so the records and documents need to regularly updated . The information calculated needs to be accurate , if it is not this could lead to an overcharge to the dog owner , and they could pass this on or post a bad review online . This would ruin the reputation of Harry?s Boarding Kennels . If a dog stays for more than one day , there is a reduction for the days after so there needs to be a calculation to automatically make a reduction. It must be simple and easy to use as Harry has no prior experience with ICT Systems , but still must fulfil all the success criteria . ...read more.


Solution Outline This will allow Harry to store owner details eg Name and telephone number . Store dog details eg name , breed , age , gender , special dietary requirements as well as other relevant information . Use information about a dog?s stay (eg kennel number , number of days stayed and extra services ) to produce an invoice which they can have at the end of each visits including the costs . Calculate income and expenditure every month . Allow Harry to plan future prices by changing the profit and seeing the price required to achieve this profit . Allow for future expansions or changes to the business such as getting more kennels or adding on more extra services . Outputs to be produced At the end a spreadsheet , invoices , letters and a graph which is able to manipulate and edit details . There should be filters so Harry for example can see all the dogs with a gluten intolerance . ...read more.


7 There should be ?what if? predictions If a certain profit is wanted , you should be able to type this into the profit cells and the prices should change accordingly to reach this profit . 8 Use vlookups to find the price of a service After all the information has been entered for the extra services , the user should be able to on a different sheet , enter the extra service and the correct price should be brought up via a vlookup 9 The data is stored chronologically You can easily filter between the past and recent stays . 10 Must show income and expenditure There must be formulae?s automatically calculating the expenditure and income including the SUM formulae . 11 Be able to transfer data between applications Harry?s Employees must be able to access the solution . The solution needs to be saved with macros enabled Data security Harry needs everything/some cells to be password protected so no one can edit and change the solution without his permission , because that would ruin the time and effort that has been put in to create the solution . ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Database Design Guideline

    the information about a patient whose surname is Anita and D.O.B is 07/04/88. Expected Result I should find only one result, as the information for each patient is different. Fields Used Patient ID, Doctor ID, forename, surname, gender, D.O.B, address, NSH number, date admitted, date discharged, ward, phone number, post code and illness.

  2. Database design.

    Adding a record To add a record in customer or in video I put in the main switchboard add a customer or video like so: Amending a record I put in Edit record for each form, video and customer like so: After I clicked this it brings me to the

  1. A Design Specification for an ICT System Introduction Going places is one ...

    Staff will use my new system to update the information on the database, and various customers will also use it. Couples, families, students etc will all be able to book appropriate holidays themselves, and view what is on offer. I am going to be creating a database, which is more

  2. ICT specification

    want to upgrade to a higher class car for a week so that they can give themselves a luxurious experience. The company on average would make 20-35 transactions in a day. Data for the system Mini size 2dr Capacity Price Ford KA 2 �167.00 Daewoo Matiz 2 �167.00 Seat Marbella

  1. System requirements analysis

    that they have very high resolution and that are very fast and they are very quiet. However the disadvantages of a laser printer are that they are very expensive to buy and to repair and also they cannot be used continuously.

  2. The new system is required to calculate the costs of a new car as ...

    This costs the company a lot and reduces their competitiveness in the car market. Other Objectives: > The new system is required to calculate the costs of a new car as the user selects the various options and customises their purchase.

  1. drum kit costing system

    This would probably be the best solution as it is designed for calculations using simple formula. It can work out many calculations if you program it with a set formula. The spreadsheet can work out the total price; calculate discounts and will not make any mistakes as long as the information is input correctly.

  2. ICT Specification for a spreadsheet for the Hairdressing business.

    The information has been stored on my USB and that there is anti-virus is stored to prevent any data or memory loss. 1. To have tables and then link the tables together by relationships and this should make it easier for the user to navigate from page to page quickly.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work