Database for Car Vandalism Problem

Satisfactory Essays
Database for Car Vandalism Problem IDENTIFY Define problem There is a lot of confusion at school because there have been unsolved cases of vandalism in the school car parks. This is due to the fact that there is no way to tell between the cars that belong to teaches and the cars that belong to the sixth formers. I need to create a database that I can use to tell who a car belongs to if it is damaged. I can do this by putting the name of the owner, the car colour, the Number plate and make/model of car into a database. Hardware The system I am using is as follows: The network has a server that has a Pentium III processor running at 500MHz. It has 512 MB of RAM, 512 k cache memory and a 9 Gb hard drive. The system is referred to as a Citrix Metaframe. The workstations have a 486 processor with 4 MB RAM with a WindowsNT4 operating system. When a workstation is running all processing is done by the server not by the workstation. The system runs in parallel with the main network where work files are stored. I would need a printer in case I needed toy print any reports or forms. Software - Why used? The software I use needs to be capable of storing, retrieving and amending data so that I can save files, change them if anyone gets a new car and call it back up to perform queries. I have access to; MS word, MS Access and MS Excel. I am going to use MS Access as I can create a good database that is clear to show information and easy to use. ANALYSE Available data I need to collect data such as name of the owner, car make and model, registration, if the owner is staff or sixth form, if they park in the top or bottom car park, car colour and the owners telephone number. How data captured? I will need to devise a questionnaire so that I can collect all of the
Get Access