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

GCSE Database Coursework

Extracts from this document...


GCSE Database Coursework 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. ...read more.


Sub problems * Will it be easier to print off lists of all colour categories * What types of data will I assign? * What field names will I use? * How many characters will I assign to a field? * Will a colour scheme make it easier to see records? Method of testing I need to test my new system; I could use it over a period of a week to try out my new database, if a problem arises, I will be able to use my new system as a faster, more affective way of finding out who a damaged car belongs to. DESIGN Which data used? These are the field names I am going to use: * Name of the owner - text- 50chars * Car make - text- 50chars * Car model - text- 50chars * Registration number * Is the owner staff or sixth form - text- 50chars * Car colour - text- 50chars Method of data capture I have chosen to go with my initial idea of creating a questionnaire to collect my data, I will have to send it out to everyone in the sixth form and on the staff so that I know for sure that I have covered everyone who has a car. ...read more.


EVALUATION How well was it solved? My Design works well but there are areas in which I could have improved. I could of added forms or records, and I could of added a special feature to determine where in the car park a person would park. I would have done this by numbering each car parking space and where ever the person falls in the database, is where they park, for example, if a person is number 20 on the database, they will park in space number 20. Real world use Databases are used for various things, they are used to keep pupil and staff records and can be linked closely with mail merge. For example if a teacher wants to send out a progress report to all pupil's in one tutor groups parents, he would look up the tutor group in the database files then type out a simple mail merge letter leaving spaces for every fieldname he needs to put in, for example: Dear Mrs <<Surname>> I am writing to inform you of <<Forename>>'s progress during this term. She has achieved a <<Maths>> grade in Mathematics, a<<English>> in English and a <<Science>> in science... The words inside the <<>>'s are the fieldnames that have been entered into the letter using mail merge. ...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 Coursework (MarcoS)

    password, and data can be handled without risk of damage data or lose it. Also with computer you can make calculus faster, without using a calculator, and another important thing is that you can make prediction of the work, how it's going and if it's improving or not.


    A textbox with heading BMW. Picture as heading. Tables with specification of car. Two pictures. Large picture heading title. 8 M3 (C) "Button and tab layout as slide 1" Models available. Specifications; Price, Fuel, CO2 Tax, Engine, Eu4, Fuel Consumption, 0-62mph and colours available. 2 pictures of M series BMW Logo from www.bmw.com Pictures from; www.bmw.com Information on car details from old system.

  1. Ict Powerpoint Coursework

    Choice , Yes or No with a reason Skulltrail Core i7 Dual Xeon AIO PC This is a custom made Easy Pc branded computer , it is one of the worlds fastest Pc's with the specs : Xeon i7 CPU (20Ghz)

  2. Database coursework

    * Can be done by everyone * No ICT skills needed * Cheap * Takes long time * Data can't be copied * Is not accurate * Needs storage place? * Very difficult to work with * Hard to update Web- Page * Easy to access * More graphics *

  1. Database Coursework

    There have been many times when a sheet of paper with all the details of a customer falls out. This would probably be the biggest problem of all, because not only do the workers lose all the customer's details, but the shop can't ask the customer for the details again, because they have lost the contact information too.

  2. IT coursework.

    customer and it may involve the company having to repay the price of his shoes that P.Y.S have done incorrectly. Background to the company Company name and location The company name is Pimp Your Shoe(c) and the address is 748 High Road Tottenham London N17 0AP Nature of business Pimp

  1. GCSE IT Coursework

    The advantages of using a computerised database are that information can be found quicker, data is stored more easily, it will also take up less space then a filing cabinet. Records will no longer be lost and will be more accurate then the current system.

  2. Ict coursework full

    * Information about the number of each item left in stock must be given. * The system must be able to hold a large amount of data, incase new items are added. * New hardware or software should not have to be bought; all that will be needed is OpenOffice Calc (or Microsoft Excel if preferred by the user)

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