• 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
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  • Level: GCSE
  • Subject: ICT
  • Word count: 5082

Creating a computer system for a mobile phone shop.

Extracts from this document...

Introduction

Description of the Problem I own a small mobile phone shop in Darlington. The shop is contracted to sell Orange(r) phones on contract. Whenever I sell a phone, I have to take the buyers details and the details of the phone they have bought and store them. If this information is not stored and updated correctly, then I will lose my license to sell Orange(r) contract phones. This would lose me a lot of money and I may even go bankrupt because of it. Orange have already contacted me and brought this problem to my attention and they are requesting that I take action to fix this problem as soon as possible. At the moment I store all my customers' details on paper, in a locked filing cabinet. This is a problem as every so often papers are lost/misplaced. My new system will have to be simple to use so that data can be entered quickly and efficiently. The system will have to be easily maintainable eg. If something goes wrong it will be easy to repair/correct. The system will have to be relatively cheap and not costs thousands of pounds to create. Analysis I have to store the customer' details and the features of the phone I have just bought. This data needs to be easily accessible, if Orange(r) requires me to produce it quickly. At the moment this is not easy as the filing cabinet is not very organised, and often papers get lost or accidentally destroyed. I am hoping to have a system where I can quickly access the data I need, I need to be able to do this efficiently and without problems occurring. I could solve the problem by using a number of different methods. I could create a good filing cabinet system, where customers' details are stored alphabetically and always in order. Using this method, it should be quite easy to find the data I wanted. ...read more.

Middle

Validation is performed by a computer program. There are many ways that a computer can check to see whether the data is valid i.e. allowable. Verification is a task done by a human and is basically just checking that the data that they have entered is correct. For example when filling in a form, a person would normally double check that what they have write down is correct, this is basically the same, but on a computer. In my database I have used input masks as validation on fields like postcode and phone number. For example, my database would not accept a phone number that had a letter in the middle, because it knows there has obviously been a mistake made by the user. Also it wouldn't accept "D584 9JA" as a post code, because it knows that the second digit has to be a letter... Data and / or program structures These are the three tables I created in Access:- I created these three because I needed to have one table for the customers' details (tblCustomers), one table for the phone details (tblPhones) and a table in the middle that links the two (tblFeatures). This is how the three tables are conncted... The tables are linked in this way, because you cannot have a many-to-many relationship. As many people can have the same model of phone this automatically means that for the tblCustomers and the tblPhones to be linked, it would have to be a many-to-many relationship, which is not allowed. That is why I had to introduce the tblFeatures, where the user selects which features the customer has on their Phone. This is the design for my three tables, showing the fieldtype, size, whether or not validation is used, and whether it is required. TblCustomers CustomerID - I made this field an autonumber so that the database automatically picks a random unique number that is associated with the customer. ...read more.

Conclusion

2. Make the data easily accessible. The data needs to be easily accessible so that if someone rings up, then we can supply them with information as quickly and efficiently as possible. Orange might ask to see a list of our customers, we need to be able to provide that data quickly and efficiently. The Data is made accessible by the use of a Switchboard, where just a few buttons need to be clicked before you have access to any data held, about any of the customers/phones. 3. Make entering new data easy, and also editing data that has already been entered. It needs to be easy to enter data so that it can be entered quickly, and with as few mistakes as possible. If the system was complicated then it would be hard to enter the data efficiently. The Forms I have made make it very easy for the user to enter information, as well as the input masks which aid the user in entering data such as DOB, Telephone Number and Postcode. 4. Let me select the data I need to see by using a menu. This is linked to "Make the data easily accessible" because I need to be able to select data without complications, and in the simplest of ways possible, a graphical menu system. A Graphical Menu system was implemented in my database, a switchboard, a menu system which makes it as simple as possible to do the task they need to do. 5. It will have to aid the user with input by providing "masks" that make it easier to enter data. For example when entering a customer's post code... 6. Needs to create reports which show:- * All the customer's details * A specific customers details (for the Data Protection Act) * All the people with a specific feature (games, wap etc.) These reports need to professional looking and show all the data required in a presentable format. I have made these reports, and they look very professional looking, hopefully impressing the people at Orange. ...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. ICT notes

    all respondents must be asked the same question in the same way. Conducting a face-to-face interview and the completion of a questionnaire are 2 popular ways information is collected. Advantages/Disadvantages of Interviews Advantage Disadvantage Questions are fully completed as respondents can clarify points further with the interviewer.

  2. Spreadsheet Project - computer system for a video hire shop.

    I shall use colour to highlight important information such as total figures. Solution broken down into sub tasks The two workbooks have links within the workbooks and with each other. All of the monthly worksheets in the Income workbook are linked to the final worksheet which gives a yearly income total.

  1. System requirements analysis

    are found. These help the doctor/receptionist navigate from page to page. But certain tabs such as, the 'cell links', will not be relevant to them. If there are any problems, then the technician will check this page and see if there are any errors.

  2. Creating a computer system for a video rental shop

    Audio Controller This processes the Audio output from applications, a speaker must be connected to hear the sounds. This would work well for the leisure centre. A more advanced card such as one that outputs digital surround sound will not be needed as it is only a luxury addition which is not necessary important for the centre.

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

    This'll increase the number of typos and make Sarah work slower. The word prediction will also fail to work properly with typos. Summary of advantages * Allows Sarah to use a keyboard much more easily * Specifically marketed towards people with her type of disability * Has word prediction to

  2. Creating a computer system.

    To check that it actually works and achieves the objectives set out in the analysis. I will also need to explain any changes I have to be made. This will also involve creating a user guide, system flow chart, etc.

  1. Smarts Leisure Park Database Booking System

    I must decide how many forms that I need. I am going to have four forms. * Customer details * Activity details * Booking details (not included with customers) * Cancellation details. Processes Process One To extract a customer details query.

  2. Introduction to information skills and system. An information system is a system that accepts ...

    1 1 8 1 0 0 0 Each digit in a binary decimal can only be 1 or 0. To convert from decimal x to binary: divide x by highest possible power of 2, then divide left over by highest possible power of 2, repeat until 1 or 0 is left.

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