• 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


    Class Boundary This possess grade boundary table named grades. Is used as a Vlookups to assign grade and comment to students based on their average mark on parent report. There is no macro on this sheet as the user will nerve see it.

  2. GCSE Database Project ICT

    After data has been isolated, it can be sent to other applications in the form of a mail merge in which, the data can separated into fields and be inserted, in the form of a letter, to fill in patient information.

  1. ICT - making a database of used cars.

    This is very useful for a business as it saves a lot of time searching for cars or features that customers may ask for. Here are a range of questions that customers may ask: 1. Can you show me any blue Volvo's?

  2. Design Section

    (Extras page) * Use Formulas - This is for finding out the total costs of things for the model of the phone. Plus the extras page. This is great for my project as I will need to access all these software's for my project to be completed.

  1. GCSE Book DataBase Project

    The ICT department believe that the use of IT will help them dramatically and have asked me to design and produce a suitable system. The advantages and disadvantages of using both of these methods have been shown in tables underneath to help me decide whether to do the design by hand or computer.

  2. Organising the database at Costsloadsless.

    hour because another customer will come in and they will have to remember there data as well as the first customers * They don't have to pay electricity on the computers therefore saving money for the business. * They will go threw a lot go pressure to remember everything!

  1. Smarts Leisure Park Database Booking System

    manager My Objectives I want my database to achieve the following objectives: * Organised * Easy to use * Readable * Meet all the user needs * Works * Is Professional, correct, efficient and well designed. Analysis The Computer System Smarts Leisure Park will need a computer system to run

  2. System requirements analysis

    they are quite slow printing 4 pages per minute and expensive to run however the hospital does not need this as much as other things. Task 2 Interviews and research 2.1 Summary of research findings (AO2.12), 2.2 Interview and research notes (AO2.12)

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