• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  • Level: GCSE
  • Subject: ICT
  • Word count: 4118

Green Associates is a seller of many games - design a computer based system

Extracts from this document...


Chapter 1: Identification General description of the task being undertaken A Mr. Green of Green Associates is a seller of many games, and at the moment archives all the information about the price of each game, the producer, and the genre using a pen and paper technique, which is to simply write on table in columns the information. This is tiresome and can be full of erroneous records as it is down to the human factor to make sure all data is correct, because of this it can be unreliable, it is not only tiresome to write all the information, but it also extremely hard to find a certain piece of information. The solution for this is obviously a computerized solution, which is to create a database in Access, which would allow for easy searching of data, and would allow for many other extra features, such as data validation which would prevent the entry of invalid data. Reasons for selecting the chosen approach A/B I have chosen to use Microsoft Access as it easily the most widespread database software in the world, and therefore the most compatible. It is extremely well suited for this as has many special features, in particular, I will be making use of Access's command buttons, to create a user friendly menu allowing the user to select different functions with ease. I will also be implementing data entry forms using Microsoft Access's "Forms" facility. Printing using Access is just as easy as the user must simply click on the print symbol in the toolbar. Possible alternative strategy for solving the problem B There are many other alternate strategies for solving this problem, for example, one could use Excel's table's and input data in a similar approach that Mr. Green is doing know, which is to write all the names of the other companies and their games, and prices, and update whenever necessary. ...read more.


Overall however I overall believe that the system will work, but needs to be easier to navigate in. Sincerely, Mr Green. Test plan Test No. 1 Item being tested Data Validation, this is used to prevent the user from typing in clearly erroneous data, this is used the entry of price, and checks to see if the user has typed a price between �4.99 and �39.99, if it isn't the computer will display an error message. Test Data �5.00, �4.99, �4.98 Reasons for choice of data. These will test that all data entered between the values is allowed, that data entered that is equal to the specified values is allowed and those that are outside the values are not. Expected result. Test 1: Allowed. Test 2: Allowed. Test 3 Disallowed + error message. Test No. 2 Item being tested. Price range query, this is used by the user to generate a list of games between a certain minimum and maximum price that he specifies. Test Data �6.99 - �12.99, �0.01 - �4.98. Reasons for choice of data. The first test will allow me to see whether it is showing the correct price range, and the second confirms this as the price range is below the data validation range, and therefore no games should appear. Expected Result 1st test: There should be a variety of games shown. 2nd test: There should be no games shown. Test No. 3 Item being Tested. Drop down menus in the forms. Test Data. To do this all we have to is attempt to add a new game to the database using the drop down menu, all this requires is a visual check. Reasons for choice of data. - Expected Result. It should allow the game to be added. Test No. 4 Item being Tested. The user should be able to specify a genre and the database should be able to display the games alphabetically. ...read more.


I am also pleased that it is enough for me to navigate in it without too much hassle. I am particularly pleased at the main menu you designed so that I would not have to use the usual access menus which are too confusing for me. The forms that you designed are also particularly useful with the added drop down menus. The report which shows all the out of stock items is particularly useful as it shows the addresses of the various developers of the game I am out of stock with so that I can phone them up and request more. However I would like a search function for developers, also new forms for films and applications would be good too. Sincerely, Mr. Green Response to customer feedback To create a search function for developers table would not be too difficult, I would have to create a new query similar to the one that searches for keywords in game titles and would display it. To create a new part of the database for films and applications it might be easier to create a new database altogether designed in the same way as the first but with differences such as data validation, which would have to change as some applications like visual basic cost a lot of money. Suggestions for further enhancements In a real situation this would probably only work for a small shop that doesn't stock many games, but in a large shop it would be extremely tedious to type in possible dozens of new games released every week, however it could be done by subscribing to a place that shows newly released games and importing that somehow into the database. The search functions for the model are also very refined in their parameters, for example there is not function to search for developers, for example, if Mr. Green wanted to look up a phone number for a developer he would have to search for it manually in the developers database, which would be extremely tedious. However on a small scale I believe that my model would work fairly well. ...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. Video Rental Shop I.T. System

    x x x x x x x x x 10 9 8 7 6 5 4 3 2 = = = = = = = = = 0 81 40 21 12 20 36 0 16 = 226 226 11 11 - 6 = 5 Check digit = 5 VERIFICATION

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

    > Transaction type Eg: rental, sale, late or food. This column will also have a validation to ensure that one of these transaction types is entered. > Video number I will validate this column to ensure that if a number is input, it must be between 0 and 2000 (video

  1. Creating a computer system for a video rental shop

    * The hardware suppliers gave a vague specification for Tower Case, motherboard and the ATX power supply * Only 20GB of hard disk space, this my not be enough * Win 98 keyboard, this is a old keyboard which does not take advantage of windows ME keys such as logoff .

  2. Creating a computer system.

    I must also take into account the current problems and the needs of the user(s). Then I will need to generate some ideas, considering the resources available. I will also need to justify the ideas. The design will include thorough testing strategy and plan.

  1. Smarts Leisure Park Database Booking System

    Processes Process One To extract a customer details query. I will extract all customer details from the Customer Details Table. To locate the correct customer I will enter [Please Enter Surname] in the criteria box of SName Field. Process Two To extract all of the booking details query. I will extract all of the booking details from the customer and activity data tables.

  2. System requirements analysis

    This software adds and removes appointments very easily. The doctor can view the appointments page and will know who his/her patient is and prepare (if necessary) themselves. The doctor will also be aware of their break and will know how long to spend with the patients.

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

    In the case if a fire we will lose all our files and card as we have no backup. There is also a bit of crime that goes on in `HMV`. Some people come into shop with the intention of stealing a game.

  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