• 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...

Introduction

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.

Middle

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.

Conclusion

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.

    The first name is the same, the street is also the same. The town is a lookup table, which means you choose one from the list. The postcode is an input mask. The phone number is all numbers. The video ID is a lookup table so you could choose the video from the table.

  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

    It is very fast printing approximately 10 pages a minute and the resolution is very high being typically 600 dots per minute and this means they can print high quality documents. The next type of printer is the ink jet printer.

  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 be acceptable but word processors are not really designed for formula and calculation work. You can add tables and insert pictures but on the whole it is not suitable for calculation and working out the prices * A spreadsheet.

  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