We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Designing a Car Mechanic’s Database Essay Sample

essay
The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 923
  • Category: car

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Designing a Car Mechanic’s Database Essay Sample

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 tell who (out of the mechanics available), is the best for a certain job, such as on a van or a people carrier or a normal car.

* Customer Database

This part is equally important in the whole project, as it involves the known clients of the garage. It allows the workers to see who has been to the garage before and link problems if a person returns.

* Spare Parts List

A garage can only function if it has enough pieces to repair the cars with. This database shows what spares are used by the garage, how commonly they are used and how much they are.

* Specialist Garage List

A garage can’t always do a job if it doesn’t have the right tools or men to do the job, so the garage needs to be able to recommend the customer somewhere else where the correct requirements are fulfilled.

Each of these different functions may be using a database. If so, I may link the tables, for example, I could link spare parts and vehicles so the mechanics could find the full specs of a car they need a spare for. When I test the system, I will go into each section and try everything I put into it. I will also (If I link the tables) try to get into different tables from different records etc.

The various files need to have different properties and properties in order to fulfil their various tasks. These would include:

Inputs:

* The new system has to have a way of collecting information of customers etc. The best way would be to use a data capture sheet for the customers to fill in. These would be collected back and the information stored in the new system.

* These data capture sheets would ask for things like age, address, car, phone number an other things the garage needs to keep a tabs on the customer and to be able to give them a efficient service next time.

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. Say if a customer or car is just introduced to the garage. The information needs to be able to be added to the system without a lot of hassle.

My files all need different field names and data types. In the vehicle database, I will use a combination of both text and number data types, as I will have things such as models, makes and drives (which will be text) and lengths, widths and heights (which will be number). I can also include gearbox, engine size and other measurements. The worker list will include things such as name, telephone, speciality, training and availability, most of which will be text. The customer list will include the regular things such as address, postcode and telephone, and the specialist garage will be similar, but will include what they are good at.

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

Car investigation portfolio

Newton’s law of motion explains that every object will remain motionless, in a straight line until it is forced to change by an external force. Newton said that “for every action, there is an equal and opposite re-action. ” The police use Newtons law to figure out how far a car has been forced to move, when involved in a collision. This also helps to...

Investigate Correlation if any, Between the Price...

The previous data shown is the original data of used cars. I have decided to investigate correlation if any, between the price of a used car and it's mileage. I did this because I wanted to know why some used cars cost so much more than others. I intend to take a sample of the data provided, simply because it would be extremely difficult to...

To Design and Build a Mousetrap Powered...

Situation The Good Shepherd Lutheran College requires a mousetrap-powered car to be designed and built for a Grade 12-assessment piece. The mousetrap car distance achiever must be designed to go the furthest distance possible using a medium sized mousetrap and any other materials needed. A test will then be carried out over a flat floor and higher marks will be awarded to the further the...

Audi TV Advert

The advert that I have chosen is the advert called "Beauty and the Beasts" which is an advert for the Audi R8 Spyder. The advertising agency used to make this advert was BBH. BBH BBH is an advertising agency that was first opened in March 1982. They are independently owned and managed. They can be located in London, New York, Sao Paulo, Singapore, Shanghai and...

Impact of ICT on Car Production

Traditionally, there would be a group of workers who would assemble cars. Skilled manual workers operated lathes and cutting tools, this would need lots of training and experience. The workers needed the ability to adapt to changes in task specifications. However unskilled and partly-skilled workers had to sort out and assemble these pieces by hand. Engineers who designed the cars had to work with paper...

Get Access To The Full Essay
icon
300+
Materials Daily
icon
100,000+ Subjects
2000+ Topics
icon
Free Plagiarism
Checker
icon
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access
immediately?

Become a member

Your Answer Is Very Helpful For Us
Thank You A Lot!

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?

Couldn't Find What You Looking For?

Get access to our huge knowledge base which is continuously updated

Next Update Will Be About:
14 : 59 : 59
Become a Member