• 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. Designing a Car Mechanic's Database

    Last Visit Date/Time None Reason Text Field Length: 50 DEPOT DATABASE Field Name Data Type Other Depot Number Autonumber Primary Key Name Text Field Length: 20 Location Text Field Length: 25 Address Text Field Length: 25 Postcode Text Field

  2. Ict Powerpoint Coursework

    The computer costs �3500 but Mr. Akram is more then happy to fund this money for a perfect outcome. The computer also stores a large space of 4,000 gigabytes this is more than enough of what Mr. Akram needs but just for backup purposes he might need all of the hdd.

  1. 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 *

  2. Database Coursework

    Analysis My Chosen Method I think the best method to use would be to use an interview. I would prefer to do this over all the others, because it would definitely give me back the most information compared to any other methods.

  1. IT coursework.

    Your Shoe has a medium size shop on a busy shopping street, and a warehouse where the shoes are customised which is based three miles away from the shop. The address for the warehouse is 31 Manor Drive Tottenham London N18 8GH.

  2. GCSE IT Coursework

    Section B: Analysis (Refer to questionnaire in Appendix 1) I sent a questionnaire that I had produced to the owner of D and D newsagents asking for information on the details they require in the database that I will produce. The questionnaire has told me that, the user has average levels of computer skill.

  1. Ict coursework full

    and a computer to run it on. * The system must have a user-friendly interface, and a company logo atop each page. * The system must be able to invoice the user's bank account, and print off a receipt as proof of purchase.

  2. GCSE Database Project ICT

    The report will be printed out and the required fields checked for any errors then Word will be opened. A letter template will be made for the reminder letter which contains spaces for the data of the patients name(s) the date of last appointment (including sub-form)

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