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

  2. ICT notes

    Computer Controlled Systems Advantages Disadvantages Computers can respond instantly to changes. The system is expensive to purchase Systems can be running 24 hours a day, 365 days a year. Special software is needed. Computers can process data quickly and machines can operate faster than humans.

  1. System requirements analysis

    The VB code method does not list the patients' names in the diary slot but fills them up with a different colour. To insert the patients' records into my booking software I had to 'import' the data form a database that was provided.

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

    They are: * Text or labels this means text that has no numerical data * Values or constant this means any number * Formulae this means a mathematical equation used to calculate I will be using all of these data types in the design of my spreadsheet.

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

    * It is easier to make changes to your document. You can move, change, delete, save, and format all your ideas in one handy file. * It frees you to express ideas more clearly and to let your thoughts flow because anything can be changed or deleted later.

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

    system uses binary decimals to represent different characters. Each digit takes up memory of 1 bit; it takes 8 digits i.e. 8 bits i.e. 1byte to form a character. 1024bytes (210 bytes) = 1KB; 1024KB (220 bytes) = 1MB; 1024MB (230 bytes)

  1. ICT Report 2b: ICT in Organisations

    Boots takes full advantage of speakers for advertisement where they can have a person speak special offers around the store. However, more importantly, Boo ts utilize this in the production facility and R&D Department where orders are fired off form over head speakers in assembly lines, for example, to inform

  2. The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The ...

    Computers are ideal for storing large amounts of data and searching through it quickly. There are two ways that a computer could be used to do this. The first is to have a program specially written to do everything MovieZone Video Rental wants.

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