• 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


    The form names are used as column names. The macro then updates the chart and takes the user back to chart. The chart titles and axis are changed to show that the chart is comparing different students.

  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

    * What you hope to achieve - Microsoft Excel will allow me to achieve all my targets as this as all the stuff I need to achieve all the things. I want to achieve the system to make it easy and I can do that by using easy instructions so the customers can gradually get through my pages.

  1. GCSE Book DataBase Project

    Alternative Solution The alternative to using ICT to solve this problem is the manual record system that ICT department is already using. They are finding this method difficult and time consuming. They are finding it hard to keep track of the condition of each book and are therefore loosing money no charges due.

  2. Organising the database at Costsloadsless.

    * You don't have to install an expensive system * it will put people off working there because they will be working harder then they are being paid. * it will not take any time * They are too much relying on staff which could result to mistakes, mistakes that could lose money!

  1. Smarts Leisure Park Database Booking System

    Hardware SLP will need to buy many things including: An internet connection This will allow SLP to connect to the information. They need a modem and an internet browser to go on the internet.

  2. System requirements analysis

    internal print server, HP Jet direct connectivity cards �46,50 I think a HP Business Inkjet 2800 Printer is most suitable for the health centre. The resolution is between 300 to 600 dots per inch and the cheapest ones are well under a �100 and also they are quite small.

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