Creating a database of computer games Essay

I am creating a selective informationbase of learning processing system juicys. It is mean to twain aid the guest in choosing which game to purchase, if any. It is similarly intended to aid the staff of the store by considerably providing them with any in pution that they train for whatever reason (for sample help a customer with an enquiry).They have the problems of in that location being a lot of divergent computer games gettable on a subject of different platforms (different hardware systems), this operator that it depart either take a long time for a customer to search through all in all of the games available to them and to find the look of one that they like, or they groundworknot see all the games that are in sway, for instance on that point could be tumesce-nigh in the stock room that they do not know about. These problems all soon exist in the shop and there is no way of customers to know the information they require, they in effect(p) have to ask m embers of staff.This selective informationbase offer help them, as it will bring out all the games in the shop and the stock room. It will also flourish the grade given to the game by a reputable independent magazine for that format (CUBE in this case). It will also display a hyper association to a follow for the game, so that they can find out if the game is suitable to their tastes. In this case it takes them to totalgames. net, an relate of CUBE magazine, so the studys are honest and coincide with the rating.I chose to use a informationbase packet package called Microsoft Access because it allows me to pander all the requirements of the product I am working on. It allows me to easily enter the data that I have forgathered in the form Of a table, it then allows me to make up queries so that the user can easily sift through all the data and find the information that they require. It also allows forms to be made, which provide an easy and simple user interface, so tha t all the functions that the user will require are available to them, and they essential not go into any an other(a)(prenominal) part of the program.It also allows you to create reports and they can then be printed easily. These are all functions that can be performed in a database but not other software such as a spreadsheet or a Word Processor. Analysis I collected my data from a number of different sources these include a magazine, which has a directory in the back to allow me to collect a lot of the data which I require (see pages and ) . I also utilise the website http//www. totalgames. netwhich has a large database of reviews for games, which allowed me to both provide a direct link to a full and comprehensive review for most of the games listed in my database, as well as allowing me to obtain another review score so as to be able to get an average. I also collected data such as prices for the games (which I could not obtain from the other sources) in the database from shop s such as GAME(r). I collected the data from the shops using my data capture form, of which a blank example can be found on page and the completed example whitethorn be found on page.I validated my data in a number of ways. I created a checkmate 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 thaw 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 ignore (see fig 1. 1 below).