• 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. Analysing Qualitative Interviews

    Due to the fact that qualitative analysis is about understanding people's attitudes and feelings, it tends to be used in relation with hospitals and work places.

  2. The impact of ICT on a person with special/particular needs

    She can easily download lots of different material needed for her stories and such. She can also actually manage to read books, news and articles whereas she usually couldn't due to the difficulty of turning a book. This has made Sarah feel much better as she feels more in touch with herself and her passion of writing.

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

    such as doing hyperlinks to online sites and is therefore not fit for purpose. Taking in to account that not only could you possibly use electronic solutions but you can possibly use a manual solution. In this case a manual solution would not be able to supply enough information in

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

  1. a level ict project

    The amount of storage space is limited, Victor is running out of places to store the documents due to the increasing quantity, which leads to the next problem, certain archives are becoming harder to find. If there is a situation where Victor needs to find the history of a certain

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

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

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

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