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

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

    Common file type: excel, word document Images - An image is an electronic copy of a picture, photo, scanned document etc for display on screen.

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

    Table designs I am going to design two tables for the customers, two for the holidays and two for the bookings. The reason why I am creating two tables fro each is because I need to choose one of the two, to use for my database.

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

    * Word documents take time to load into the viewer. * If not all users have Word installed then seeing the Word document using Microsoft WordPad may be a less satisfying experience. Excel Advantages * Time-saving: Data is entered once and can be selectively linked to other data to use for many purposes (timesheets, reporting hours, etc.)

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

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

    * Finally, click on Save. Printing To print the database you will have to print in different sectors. So you have to choose what you want to print. * First, you should click on File and then click on Print.

  2. ICT notes

    Access Security Vast amounts of data is lost due to carelessness by employees e.g. not saving work, deleting files by accident, not saving files with sensible file names and therefore are difficult to find etc. Limiting each employee's access to the system with help to ensure against the loss of data to the health centres system.

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