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

Creating an IT system.

Extracts from this document...


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.


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


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. a level ict project

    The following screenshot is an example of a table, and the annotations refer to all tables in the database. Relationships The following screenshot shows the relationship between the various tables in the system. Macros The following screenshots show the macros included in the system ` Queries The following screenshots show

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

    her job being on the computer, it is very easy for her to procrastinate * She has to use a special keyboard to actually even be able to type properly, making typing quite a tedious task * Can be quite confusing to use Conclusion The computer is what allows Sarah to maintain a job.

  1. Creating a computer system.

    For example, the user may want to target their advertising to the customers in a particular area such as slough. To do this they could use an auto filter function, which would come up with all the customers who live or work in slough.

  2. System requirements analysis

    LCD's stand for liquid crystal displays and it is made up of two polarizing transparent panels and a liquid crystal surface sandwiched in between. Voltage is applied to certain areas, causing the crystal to turn dark. A light source behind the panel transmits through transparent crystals and is mostly blocked by dark crystals.

  1. I will be analysing the problems defined by the management in the old system ...

    The scanner is meant for data collection. Pictures of the items available and data collection forms can be scanned so that the data is transferred to the computer and backups can be made. The keyboard and the mouse are essential for data input to the computer.

  2. I.T. System for a Newsagents

    To find a bit more about my client, I asked some questions so I could know how much knowledge he had about computers. 1) How long have you run a business? A) I have run a business for 5 years now. 2) What do you do in your business? A)

  1. Different types of technology How I use ICT at home and at school

    your life as they now know every small bit, like when you go to bed, when you eat and other pointless facts. You can also make new friends which can be harder to do in real life, especially for someone like me who tends to have a lack of confidence in new situations.

  2. ICT Solutions.

    top of the page ending with ingredients and picture of the meal at the bottom of the page. I will section it into starters, main courses and desserts. I will be making it easier to find the recipes by doing a contents page.

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