• 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 - making a database of used cars.

    The database will be designed so that staff can obtain details of vehicles easily. After I gathered information about 50 vehicles, I decided to test the data with different software's. These software's were Access Database and Excel Spreadsheet. Access Database Advantages Disadvantages * Reduce errors in data with validation rules.

  2. ICT car insurance quotation System Coursework

    to start to drive; or even the premium costs and insurance groups to be raised for certain types of drivers. How much does a whole month of processing cost? Answer: The cost the dealers have is overhead costs including staff wages; but the system does not have any costs except

  1. Smarts Leisure Park Database Booking System

    The details about the booking will come from the customer data and activity data and the booking itself will be keyed in by the receptionist. Inputs I will need the following inputs: - Customer Details - Activity Details - Booking Details - Cancellation Details All inputs will be by keyed in by the receptionist.

  2. ICT Case Study Coursework - Hull Daily Mail Publications Ltd.

    Disk # Data Stored 1 3 2 6 3 2 4 11 As you can see, the data has been spread across 3 of the disks, and a check sum of the data stored on the other 3 disks has been stored on the 4th disk.

  1. Ict Powerpoint Coursework

    I have had a meeting with Mr Akram and have discussed the same issues with the CEO of S.A. Foods himself. I had concluded to use Microsoft Office PowerPoint, he happily agreed as this is what he thought was to be the best solution as well to overcome his problem at the current moment.

  2. Database coursework

    * Produce Forms * Be user friendly * Be printable Objective Explanation Working Database It must work correct and mange to do the tasks expected. It must be error free as well. This is important. Include all necessary information This means that it must have all information/data to work.

  1. ict applied coursework

    Such as games which are a lot cheaper on the internet then in any shops. The disadvantage of online shopping is that there is a bit of chance of getting hacked. Evaluation: I currently have TalkTalk Broadband at home which meets my needs fully and is very helpful to me

  2. Different types of technology How I use ICT at home and at school

    Disadvantages (How it does not meet my needs) However, Facebook can be quite deceiving. While it may make me think I have a social life. It simply gives the illusion. The social life it makes me think I have is simply created online and it doesn't mean I have a social life in real life.

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