• 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 Report 2b: ICT in Organisations

    However, Boots is not interested in this because the staff is not complaining. All in all, Microsoft Word helps Boot's because it allows for the paper work for the R&D Department to be handled easily.

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

    Charts and graphs are the most popular ways of analyzing data. They show relationships, trends and comparisons at a glance. The impact (use of colours and symbols to draw attention to important data), speed (obvious) and simplicity (easily understood) made it popular.

  1. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    This is what it would look like; That's the basics I will now show you how to do some of the most common tasks. 1) Adding a new student or tutor: Open the database, as members are under the student section click on students, if you want to add a new tutor then just click on tutors.

  2. I have been asked to come in and help out a holiday company called ...

    I think that a small laser printer will be the best choice because it will produce high quality printouts very quickly. This will cost approximately �350. The computers at school and my PC at home all meet the minimum specification and already have Access 2000 installed.

  1. I will design a new video database for the video shop that will also ...

    * User-friendly: Once program is set up, does not require extensive expertise to use * Cross-functional: Data doesn't need to be translated from another program: Can use same spreadsheet for payroll management, accounting, reporting to sponsors, reporting to volunteers. Disadvantages * Unwieldy: As more people and information are added, the document expands across the screen.

  2. In this (2b) report I am going to investigate software application, Input and Output ...

    They do not require memorization of shortcut keys (i.e. F5, Alt+S, etc.) nor do they require a great deal of fine motor control, making them ideal for people who have difficulty using a conventional keyboard. Sainsbury used overlay keyboards easy to clean, and are much more resistant to spills or dust.

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

    Sarah can use programs like Skype or hardware like a webcam or microphone to call or video call people. She can connect to people while also saving money on what would essentially be adding money on her phone bill. Instead, she can video call family and friends for free.

  2. Benefits of using my IT system in the Travel Agents.

    * Finally, create your switchboard. Saving * First click on File and then click on Save Database As. * Then choose the Location where you want your file to be saved in. * If you want to, you can rename your file by going on File Name.

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