• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Creating a database of computer games.

Extracts from this document...


I.T. Coursework Project 1b I am creating a database of computer games. It is intended to both aid the customer in choosing which game to purchase, if any. It is also intended to aid the staff of the store by easily providing them with any information that they need for whatever reason (for example helping a customer with an enquiry). They have the problems of there being a lot of different computer games available on a number of different 'platforms' (different hardware systems), this means that it will either take a long time for a customer to search through all of the games available to them and to find the look of one that they like, or they cannot see all the games that are in stock, for instance there could be some in the stock room that they do not know about. These problems all currently exist in the shop and there is no way of customers to know the information they require, they just have to ask members of staff. This database will help them, as it will display all the games in the shop and the stock room. It will also display the rating given to the game by a reputable independent magazine for that format (CUBE in this case). It will also display a hyperlink to a review for the game, so that they can find out if the game is suitable to their tastes. ...read more.


I created a couple of input masks so that information could not be entered incorrectly; fig 1.2 displays an error that was displayed if you entered text in a numeric field. Another one was to just check all entries by proof reading them, both as I entered them and then reading through again after entering them. The second was to run a spell check, to pick up on any spelling anomalies and allow me to check the manually. This picked up on a couple of mistakes which I was able to edit (see fig 1.1 below). (fig 1.1) (fig 1.2) Whilst validating my information picked up a difference between the information entered in the table and that on my data capture form. This first shot shows it incorrectly I then changed the information so that the platform is show as "All" rather than "GC", as the game is available on all consoles, rather than being a GameCube exclusive. I created a number of different searches, these would be able to easily different customers questions as well as advising them on what games they are likely to enjoy. I created eight different queries. These allow me to set the system up so that a customer could quickly and easily find the information that they need. There are a number of similar searches which allow you to find the information by entering the information for one field, these allow ...read more.


I was not required to find out all the information for it as a lot of it was found in the Directory of CUBE (tm) or on different websites such as www.hmv.co.uk where I found information such as the RRP . This shot shows the RRP for a game called "legend of Zelda". Results This is the design for a complex search. It finds the game that suits you most by asking you a question about each criterion, and if you don't know them you can leave it blank. This allows you to search for a game by developer. This allows you to search for a game by the number of players it caters for. This allows you to search for a game by the platform it is available on. This allows for the staff to find out the price of the game by entering the name of the game and the platform it is on. This allows you to find all the games released by a certain publisher. This query allows you to find all the games in a certain genre. Using this query you can find out all the information for a game by entering its name. With this I can find all the games which have a certain rating. Or you can find all the games which have a rating starting in 0.9 (which would bring up all games scoring 90% or above). David Reed 10 Blue IT Coursework Project 1B Page 1 of 7 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business 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 AS and A Level ICT in Business essays

  1. The business I have decided to set up is RCS (Reg's computer systems.) This ...

    Are you male or female? Male Female 2. Which age group do you come into? 16-20 21-30 31-40 41-50 51+ 3. What is your current income bracket per annum? <15,000 15,000-20,000 20,000-25,000 25,000-30,000 35,000< 4. Do you currently own a personal computer?

  2. Apple Incorporation - Case Analysis

    Apple has the ability of producing and controlling its hardware and software. A merger of operations with Peoplesoft, Oracle, or SAP could provide a positive financial influx that will provide continued life to Apple's operating system platform. The learning curve for many ERP supported programs is lengthy and when combined

  1. ICT Coursework Two - Database Project

    This information will be collected by a customer filling in a form at the shop and then the staff collected it in and input the information into the database. If the data needs to be collected then an invoice will be sent to the customer attached with another form to fill in the updated or correct details.

  2. For my Coursework I have looked at how Steve Edwards at Airbus UK uses ...

    ( There may be a problem with the recipient's computer, so they may not receive the email ( You cannot be sure that your email has been read only by the recipient, a third person may be able to hack into the computer.

  1. Writing a Games Manual

    designing this card on software called Microsoft publisher, I will have our business logo on the also I will have our teams motto. I will be having the usual things on my card such as the offices phone number; my personnel mobile number our web site address.

  2. An I.T. System for a Games Retailer

    There will be a button to clear an invoice. There will a button to exit the menu and save it. End User Requirements User Skills The end user is familiar with Microsoft Excel and has knowledge of macros and knows how to use a keyboard.

  1. Report for StGeorges School computer system

    why this is a problem to the users or for the system in general * The first computer in the system was introduced back in the 1990's and so it doesn't have the more up to date features as the other computers Operating systems and cant benefit from the technology the other computers can because of its compatibility.

  2. Estate agent.I will be creating a system that will help my client to let ...

    their so if someone contact's wishing to buy a house my client will be able to check the entire system for the type of house they want making them money. Analysis Investigation techniques: There are many different methods I could have carried out this experiment.

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