• 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

    Integrated 56k V.90 modem This is the modem that converts digital signal to analogue and sends across the telephone line. It connects computers to Internet Service Providers (ISP) such as AOL and Freeserve by a normal telephone line. It has no use in a network environment since the computer will be connected via the Ethernet Cards to a server.

  2. IT system for local video store.

    click on the find specific members details, the form below will appear with the members details, you would already know what films they are taking out as each film has a unique film number when they hand u the cover of the film, the unique film number will be on

  1. ICT notes

    'does this answer your question?' Or 'can I help you?' * Open-ended questions They require a more broad and lengthy answer and are used to gain more information from the respondent e.g. 'When you say [topic], what do you mean?'

  2. Features of a sports club database. The system has at least 1 table and ...

    Complex sorting on at least two fields in ascending/descending order from one table. 1. hyperlink back to the homepage 2. button to switch match report and this report 3. Hyperlinks to other pages 4. Header for the fields 5. Fields of the records 6.

  1. System requirements analysis

    as the patient may not be in a state in which they can be contacted. Medics On-call(tm) - Mobile PalmPilot(tm) Access As you can see, the company also allows the doctor to view the system with a PalmPilot. The doctor can be on his/her way to the health centre and they are able to see what forthcoming appointments they have.

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

    the data > Keyboard - to input the data > Mouse - to navigate around the computer > CD drive- this lets you run programs and play music CDs etc. Computer > Processor: A processor controls the functions of a computer and allows you to do what you need.

  1. Create an IT system for my karate club.

    and I am also able to produce a calculation which will total up all the members fees and give a grand total like an invoice. I also have the ability to create macro buttons on my form, this allows forms to be linked and I can create a main menu, which will be the "linking form".

  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