• 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
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  • Level: GCSE
  • Subject: ICT
  • Word count: 1695

Creating an IT system.

Extracts from this document...

Introduction

Analysis 3 Background 3 Description 3 Problem 5 User Requirements 5 Hardware and Software 5 Other Constraints /limitations 6 User's ICT skill levels/experience 6 Performance criteria - quantitative and qualitative 6 The New System 7 Design 8 Possible solutions 8 Chosen solution 8 Entity Relationship diagrams. 9 Table design 9 Testing Plan 11 Implementation 12 Testing 13 User guide 14 Evaluation 15 Analysis Background The user is my mum who is a Church administrator and the problem is that she has to order lots of different equipment that the Church uses. Most of the information is easily lost and a record needs to be kept of what they order each time. Also the bulbs and batteries are ordered from lots of different companies and she finds it hard to keep track of the different companies she needs to contact when she needs to purchase equipment. The church is also a registered charity. Description My Mum deals with typing up letters and notices, ordering equipment that needs to be ordered, photocopying, etc. At the moment the details of the suppliers are kept in files, in the office. Also they have to use separate sheets when amendments or additions are made to the list of suppliers. So when they need to order some equipment they have to find the contact details for the company that supplies that equipment and contact via phone, e-mail, fax or an order form. ...read more.

Middle

* My User Guide will be fully detailed using a technical approach that suits the needs of my user. Performance criteria - quantitative and qualitative Quantitative Criteria Current New Finding a suppliers address It takes several minutes at the moment The info should be returned in less than 5 seconds. Finding details of a supplier that supplies a particular item. It takes several minutes at the moment The info should be returned in less than 10 seconds. Finding details of what items are supplied by a particular supplier. It takes several minutes at the moment The info should be returned in less than 10 seconds. To produce a headed letter to a particular supplier. It takes several minutes to fill out an order form. It should take less than 1 minute to produce a headed letter to the supplier. Qualitative * The new system should be reliable. If there is a problem then there should be a section in the program where they can find help to solve the problem. * The new system should have the capacity to be able to store as much data as is needed as well as having data added to it. * The system should easy to use. There should be an online help system. ...read more.

Conclusion

A many - to - many relationship is unacceptable in a normal database so I have to add a link table between Supplier and Item to create two, one - to - many relationships. This is my second attempt at an entity relationship diagram and I have three one - to - many relationships which is acceptable in a normal database. Table design Supplier table Data Item Example Type Length Restrictions Supplier ID (primary key) 1 Auto number 2 Presence check Name Mail Print Ltd Text 25 Presence Check Address 25 Wren Road Text 50 E-mail address clive@hotmail.com Text 50 Telephone No 07145 220145 Text 20 Presence Check Fax No 020 8330 3222 Text 20 Items supplied Projector bulbs Text 50 Presence Check Account Number 2511423655 Text 50 Item table Data Item Example Type Length Restrictions Item ID (primary key) 5 Auto Number 2 Item Name Bulbs Text 50 Presence Check Product Code 1370018 Text 50 Stock table Data Item Example Type Length Restrictions Supplier ID (primary key) 1 Number 2 Presence Check Item ID (primary key) 5 Number 2 Presence Check Letter table Data Item Example Type Length Restrictions letter ID (primary key) 1 Number 2 Presence Check Description 'This is a letter to be sent to a particular supplier' text 32 Presence Check Letter Letter to supplier hyperlink Presence Check Testing Plan Implementation Testing User guide Evaluation Laura Rogers 13.5 ...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. The impact of ICT on a person with special/particular needs

    She can find help where previously hard to find more to her needs. The word prediction eliminates the slow speed usually associated with something like this. Once Sarah gets used to it, the word prediction uses an algorithm to calculate most used and most associated words with certain combos of

  2. I am creating and producing an online interactive guide presentation on Chelmsford to help ...

    the PowerPoint as you cannot do hyperlinks and use videos and music in it. Electronic solution are the best way to go about the solution in hand as electronic solutions can be created easily and used easily. Electronic software to solve the solution can also store information and maybe update the presentation.

  1. System requirements analysis

    The macros also post and print appointments. The 'post appointment' macro records the details that the receptionist inputted into the schedule page. This schedule page can be viewed by the doctors. c) System outputs (A02.13, A01.51, and A04.41) The outputs from the system are the monitor which the software appears on.

  2. a level ict project

    customer, the chances are that the business has misplaced it or even lost it, either way it will take him and his subordinates an unnecessary amount of time to locate it. * The user requires the new system to be computer based.

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

    is smaller than could be; introducing a computer-automated system would mean a larger customer base over a wider geographical area. Performance Criteria As a result of this new proposition into the business, he has employed me to implement a new system for calculating costs; this new system should have the

  2. drum kit costing system

    Also, when the customer buys a drum kit they also get a free pair of drumsticks with it and that will come up automatically on the pricing system. The current manual system it self is dreadful and Drum Gurus are having problems with it and have asked me to create a fresh new computerised system.

  1. The end user of my program is for the people applying for the insurance ...

    * The new system will also save a lot of time for staff workers having to sorting and checking data will also save a lot of time for staff sorting and checking data. Process and task description Before I build the new system I have to make sure I know

  2. Statistics Study Guide

    (add the class width to the starting pt. to get the second class limits. Etc.0+100=100, 100+100=200 5) List the lower class limits in a vertical column and proceed to enter the upper class limits, which can be easily identified. 6)

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