• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  • Level: GCSE
  • Subject: ICT
  • Word count: 2070

System analysisThe purpose of the new system is to extend the current computerised cottage booking system, which at present does little than assist room number of the booking order and associated invoices

Extracts from this document...

Introduction

Detailed Analysis The data which is likely to be required to be entered in each of the three categories, which are cottages, customers and booking, include the following: Cottages: * Cottage No/name * Type of cottage * Number of room in the cottage * Cottage price- by size of cottage * Peak/ off peak * Cottage location Customer: * Customer name * Customer address * Customer contact No * Customer email address if required * Customer D.O.B * Cottage type selected * Total amount to be paid * Number of weeks staying Booking: * Cottage model No * Payment method by credit card of debid card * Booking payment * Cottage type * Date booked * Arrival date * Departure date * No of days The validation checks which are likely to be required on this data are: Input mask: Presence check: To ensure that all necessary fields are present. This checks that an entry has been made for the field. For example, the Surname or arrival date or departure date field in customer and booking form cannot be left blank. It is a required field. Field Length Check: To ensure that an item of data has the correct number of characters. ...read more.

Middle

It will send data on rents to the company's financial system. SYSTEM CONSTRAINTS The system will use the existing PC's, but an additional PC will be needed for the renting cottages. The PC's will have to be networked together and share a common database. It is expected that the system can be written in ACCESS for which the company already has licences. A budget of �25,000 is available for the system which it hoped can be implemented by August 2006. WEAKNESSES IN THE EXISTING SYSTEM The main problems with the current system follow from the fact that it does not cover anything to do with landlords. However the cottage system is not easy to use, with very little ability to look up customers. Management cannot get reports or graphs which provide any useful analysis of cottage history and which cottages have been mostly used. There isn't any password for the folders and the files to keep them secure. They have not got any validation checks which are likely to be required on this data. There is not any facility to show cottage is booked so that's why sometimes cottage booked twice. ...read more.

Conclusion

The costs therefore will be the analyst's and programmer's time for development, and the cost of transferring data to the new system and the extra cost of parallel running. This is estimated as follows: System analyst: 10 hours at �40.00 per hour. �400 Programmer: 50 hours at �30.00 per hour �1500 Data entry: 4 hours at �18.00 per hour �72 Contingencies �200 Total �2172 The benefit will include the time saved in performing royalty calculations and the greater accuracy achieved. The time spent on updating the spreadsheet will no longer be required. The total time- saving is expected to be in the region of 10-12 hours per month by various senior members of staff. The system therefore pay for itself within the first 6 months and thereafter will achieve a substantial cost saving. No new system is completely risk-free as things can always go wrong. For this application the risks are low as Access is a well-tried and tested software package and no new hardware has to be purchased. The greatest risk in this system is that the clerical procedures will not be correctly followed, leading to situation where, for example, landlords/customers are not credited with the correct amount. Careful auditing procedures will need to be put in place to avoid this. Process Structure Diagram Context Diagram ?? ?? ?? ?? D:\Second year\Unit9\Task1 Analysis1.1.doc\Manmeet Kaur\5/10/2007 ...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. Data processing. Difference between computerised and manual systems and the benefits of my system

    It looks really professional. Takes time to do. You can make it easier to understand and more precise. If you are on the computer then it will affect your eyes. Using ICT Advantages of ICT in general Disadvantages of ICT in general Processing of data is much faster on a computer.

  2. System requirements analysis

    The calendar that is shown above shows all the data that the system stores such as the data and the days etc. Also I can have data protection if I have more time. Data protection ensures that the data cannot be deleted and it cannot be viewed unless you have specific instructions to do so.

  1. Creating a computer system for a video rental shop

    video identity Date of returning DA 8 - Date of returning the video Reservation Reservation Number NU 6 - Unique reservation identity P Video ID NU 10 - Unique video ID identifier F Member ID NU 6 - Unique member ID identifier F Date of reservation DA 8 - The

  2. ICT car insurance quotation System Coursework

    It then displays the percentage. The IF section of the formula, makes the cell blank when the Clearscreen macro is ran, instead of displaying #N/A. =IF(E30="","",VLOOKUP(E30,Multipliers!B29:c33,2)). This formula shows today's date. =TODAY() This formula below shows when the quote is validated from...

  1. Creating a computer system.

    they know where they have to deliver any wine purchased by the customers. They also use their system to record what their customers have purchased and the total price. Their system is kept in a blue box underneath the till.

  2. Moviezone video rental system.

    I will also need a printer. Every computer room at school has a laser printer so this isn't a problem. I also have a small inkjet printer at home that I can use. This means that I have all the resources I need to set up and test the new system.

  1. Producing documents for a company. Spreadsheet, Invoice and Website.

    Database This alternative is similar to the spreadsheet but it's more suitable for handling with data. This alternative would include that the company has a working computer system with database making software. The information would be entered into designed fields and tables by using a computer system.

  2. Analysis of ICT task for a hairdresser's booking system.

    An example of a paper-based system is a record card system where all the details of the customers are put on a pack of cards in alphabetical order. An example of a computerised system is a database system or Microsoft Access.

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