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

Designing a Car Mechanic's Database

Extracts from this document...


DESIGN When you look at the qualities required of the filing system, it seems that a computer program would be the best choice. For example, data capture sheets would take time to make by hand, whereas on a computer, it would take hardly any time at all. Also, it would be extremely hard to keep everything in order if a manual system was used. If a computer were used, it would be very hard to mix things up without being able to fix it easily. Finally, a manual system would be hard to change once it was some information was entered. Say someone's address or name changed, it would be much easier to change the records if they were stored on a computer. The following data flow diagram shows the garages current manual filing system: So what will I try to do? Well, there are many types of things I could include, but these are the ones I will include: * Vehicle Database This would be the core of the garage's computer system. It would contain information on certain cars, normal things like engine size and transmission, but other things, such as size and known problems. * Worker List This would be a very useful part of the system, as it allows the workers to be able to ...read more.


Processes: * There will probably be more than one set of information to go through, so their needs to be an effective way of choosing the right set of information e.g. Customer Information, Vehicle Statistics, Mechanic Information. * It will also be required to be able to search through the records quickly and efficiently. This could be by labelling certain sections of the records or by something similar. Outputs: * Their needs to be two main ways of accessing information with the new system. The first needs to be in a list form. This way the information can be quickly read and would be extremely useful if say only one piece of information is needed from the customers record. * The second way needs to be as individual records. If there are many records at a time (as in a list), it may disturb your eye. This way each person has an individual section with his or her info. General: * The filing system itself needs to be easily accessible and easy to use. It is no use having a system from which nobody can get the information that is needed quickly and easily. * The system needs to be able to be changed easily. ...read more.


Length: 7 Specialities Text Field Length: 30 Size Text Field Length: 6 SPARE PART DATABASE Field Name Data Type Other Ref No Autonumber Primary Key Part Text Field Length: 30 Make Text Field Length: 30 Producer Text Field Length: 20 Model Text Field Length: 30 Availability Text Field Length: 8 SPARE PART DATABASE Field Name Data Type Other Worker No. Autonumber Primary Key Surname Text Field Length: 15 Forename Text Field Length: 15 Address Text Field Length: 30 Town Text Field Length: 20 Telephone Number Long Integer Experience Text Field Length: 10 Specialities Text Field Length: 30 The following diagram shows how the new computer filing system will manage data. I have included a flow chart of how the system will run. It includes all the requirements I have listed above. As, you can see, I have also included a section on Data-Capture Forms. This would allow the workers to keep a tabs on their new customers, by asking them questions about things such as what car they have, where they live, etc. My information will be displayed in forms in the program, which will look something like this. This is what I plan to do in order to help the mechanics sort out their filing needs. Jason Crudgington - JACR099177 - 25/09/03 Mr Rawal - 10R / IT3 ...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.

    Can you show me a list of black cars? Which of these cars are priced under �10,000? 7. Which Ford cars do you have? Which of these cars is priced �10,000 to �15,000? 8. Which cars do you have that have air conditioning? Which of these cars is under �10,000?

  2. ICT car insurance quotation System Coursework

    Depending on age and other factors this Value of �200.00 is multiplied. Each section the value is multiplied by the Multiplier figure and all added together. Example: Age 17-19= 200*4.4 + Sex-male= 200*1.2 + Area-med= 200*1.5 + No claims 1yr= 0.20*200 + Type third party= 0.39*200 = �880+�240+�300+�40+�78= �1538.00 Processing

  1. Smarts Leisure Park Database Booking System

    These buttons must be navigation buttons, close form and search buttons. I do this by selecting the toolbox key to open the toolbox. I then clicked on the command button key and drew it out, it then came up with this: After I selected the form options and "close form"

  2. System requirements analysis

    It is used in the drop-down menus, which then is used in the schedule page and the appointment letter, etc. the patient records' are also a form of inputted data as it essential for the concatenate function. The concatenate formula is then a form of input as the output is on the appointments page.

  1. Financial Model to help organise the year eleven prom

    I limited this to 2 decimal places as I thought it was appropriate. Welcome screen I came up the idea of a welcome screen so the committee had a choice of what sheet they wanted to go to, whether it was the "user input" sheet to work out the price

  2. Computing Project – Designing a Ticketing System for a Cinema.

    input data of; film they want to watch, whether they are adults or under 16 years old, how many tickets they want. The member of staff at the ticket booth would, key-in this input data into the system, which would return seat coordinates for a screen, the ticket/s is then printed off.

  1. GCSE Book DataBase Project

    Why is the ICT solution the ideal solution? The ICT solution is the ideal solution because if you wanted to edit the database interface for the different person using it, it can be done easily and quickly without any cost.

  2. Organising the database at Costsloadsless.

    swipe card system will work by containing all the information for one customer - from name, address , name of DVD/ video and the date is due back, when the card is swiped through the computer all the information will automatically be transferred on the computer screen, **advantages** **disadvantages** o You don't need to again rely on staff.

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