• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3508

Information Handling System for 'TKO Games' in 'Newbury Park'

Extracts from this document...

Introduction

Information Handling System for 'TKO Games' in 'Newbury Park' 1.1 Identification of the problem TKO games in Newbury Park currently run their computer games shop with a manual system to hold details of all games in the shop. Since there are so many people coming in to the shop and asking questions about stock, the staff working there are spending more time answering customer queries, searching for a product in the store, and looking on their manual index card system (which is difficult to use, and takes a long time) than selling stock. 1.1.2 Aim I intend to devise a solution to the above problem. I am going to create a computer system which can be used by customer's in order to help them to find information on a certain game, console or game's accessory without having to ask the staff in the shop. 1.2 Methods of data collection To collect the information needed for my project I will go to a number of different sources. I will use the TKO shop to get price lists in order to find out about the products and prices. In order to find out what the manager wants the system to do, I will decide whether to use interviews or questionnaires. Interviews and questionnaires both have advantages and disadvantages. This table (below) will show what these advantages and disadvantages are: Interviews Questionnaires Benefits Drawbacks Benefits Drawbacks * Actually speaking to the person * Arrange interview times. * Someone fills it out. * Limited responses. * Pickup on things they say * Only 1 person at a time * More than one person at a time. * May not be returned. * Tape conversations * May run out of time * Statistically large spread of answers. * Questionnaire cannot be developed. * Difficult to carefully analyse. * Easy to extract from. * People may not take questions seriously. ...read more.

Middle

in stock l 1 Picture lll 3 Graphics review 0 Sound rating 0 Playability l 1 Age rating ll 2 Rating /100 lll 3 Manufacturer 0 Whether the game is action/ adventure / racing / RPG / strategy etc lll 3 Format CD / MD / Cartridge ll 2 New/second hand lll 3 1.5.2.2. Database query requirement By analysing my questionnaires, it has allowed me to identify the requirements for the database. The fields that will be entered into the database are those that have 3 or more votes, since these are the ones the customers really want. These are: * Name/Title * What console the game is for * Cost * Picture * Rating /100 * Whether the game is action/ adventure / racing / RPG / strategy etc * New/second hand 1.5.2.3. Database report production capabilities The analysis of my manager questionnaire (found in my questionnaire section) has helped me to identify the sort of reports that my system will need to produce. The manager chose the following as the problems created by the current system: * Difficult to keep up to date (new games coming out all the time) * Difficult to find data quickly * Complicated searches take a long time * Difficult to make back-ups * Contacting customers take too long * Not enough information about products stored on system * Stock taking * Estimating stock value * Analysing sales performance 1.5.2.4. Database Data Processing Capabilities The analysis of my manager questionnaire has allowed me to identify the different types of data processing my system will need in order to perform: * Maintaining the database * Analysis of sales performance * Mailmerge * Reports 1.5.3 Identify the outputs, inputs, and processing required 1.5.3.1 Output Requirements * Printed stock level requirement reports: Allows the manager of the store to see what games are selling well, so that more can be ordered. ...read more.

Conclusion

* The addresses of all the manufactures. * To design an easy to use database. This is because the system will be used in situations where the manager and staff must be able to help customers in the store. Sometimes these situations become stressful and a system that is too complicated will make it even harder for the staff and manager. An easy to use system will mean that most of the staff will be able to use it and any new staff won't have any problems with it. * To create an easy to maintain system. This is because the user must be able to add, delete and correct records. This is an essential part of the database as new stock is always coming in, and stock is always being bought. If the database is easy to maintain then the user won't have problems using it on a day to day basis. * To create additional databases along with the main database. This is to provide the user with a list of details of the suppliers to contact them when ordering stock. * Exchanging data between software easily. This is to allow the user to send and receive data to other software so that the user can produce mail merges and stock level reports. * Testing the system ensures that once the system is installed, the system doesn't fail when in use. Testing the systems also helps to reveal whether there are any hidden errors in it. * Producing a user manual ensures that if the user/s of the system has any problems, then he/she can look it up in the manual. If there is not a manual then the user would have to contact the maker of the system or take it to a specialist. This is time consuming and may cost the store money because the store may lose money while the system is unavailable. * Once the system is in use, a report must be made on how successful or how unsuccessful the solution to the problem was. Harnoop.S.Atkar ICT Project 2 Analysis ...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 PROJECT

    Type Female into gender combo boxes instead of F Verify that only data currently in combo box can be entered Data should not be modified As expected Test and data used Purpose for test Expected result Results after testing 38.

  2. Creating a computer system for a video rental shop

    Choices of Software: There are three main choices of software these are Excel a spreadsheet, Access a database or a high level language such as Pascal. All have advantages and disadvantages. Excel: Excel has many advantages, which include the following points and features: - * Excel allows you to insert

  1. This report I will be writing, will be on the way I do activities ...

    Also I can access the files without the need of accessing the Internet. Evaluate Social Needs The USB Pen Drive meets my social needs very well because I can move files to any system at my friend's house very easily.

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

    selected group of people and may not be representative * Tendency to eliminate extreme positions and force a middle-of-the-road consensus * More time-consuming than the group process method * Should not be viewed as a total solution to forecasting * Requires skill in written communication Entity Relationship Diagram (ERD)

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

    Eg 25 = 24 x 1 + 23 x 1 + 22 x 0 + 21 x 0 + 20 x 1; therefore 25 decimal = 11001 in binary. To convert binary into decimal you do the reverse. Eg 101011 in decimal is 25 x 1 + 24 x 0

  2. Database Analysis and Database Design Project - DVD library for moving images.

    the ones where all the information can be edit and the others ones is where the user can enter new information without altering the information that is already store in the system, as we can see in picture 1.1 this form is the main form to enter new information and one of the commands is "edit existing information".

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    the text into your document where you chose it to be while you were creating it. Macro fill-in fields allow you to type something in, for example, "Type here". When you click the "type here" it will highlight all the text for you so it will save you highlighting the text and pressing delete.

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

    Adding details I will choose the exact details I need from the database then I will right click it. After that I will click on copy then I will open my template letter then paste the details. The details were added to the letters successfully.

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