Creating a New Database for Auto Nation PLC Essay Sample

essay
  • Pages: 9
  • Word count: 2,345
  • Rewriting Possibility: 99% (excellent)
  • Category: business

Get Full Essay

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

Try it free!

Identifying the problem

I am Mr. RM Green the business consultant for a company named Auto Nation PLC. The company Auto nation PLC offers a service to the public where they find cars to meet customer’s individual requirements, which are local. So that Auto nation plc meets this aim auto nation have records on cars for sale, using paper-based research.

Description of present system

At the moment Auto Nation plc use a card index system to record the details of the cars. This is an old way of recording data therefore it has many drawbacks to this system. Some of the bad things about paper-based research are:

* Will almost certainly become damaged through use.

* Data can become lost.

* Data cannot be borrowed.

* Takes a long time to search.

* Takes time to search for something with a certain criteria.

* The system cannot have its data validated.

* It cannot be easily updated.

* Data cannot be automatically printed out.

* Data cannot be searched for with multiple criteria.

Outline of the tasks

The owner of Auto Nation plc Mr N C Park has been looking for a more simple, quicker and more efficient way of locating vehicles nationally.

I have been given the job of computerising this process, to become successful in doing this I will need to:

* Produce a data capture sheet.

* Collect and input data on the cars.

* Sort the data on the cars.

* Show the results of searches.

* Write up a conclusion of the process.

* Create a guide to show users how to use the data handling system.

Research

To gain information about types of data that I will be using I will use the internet to research what factors are important when selling a second hand car. As well as the Internet I will collect advertisements from magazines and newspapers. From the information I have gathered from the various sources I will create a questionnaire to find out what is important to know about car they are buying second hand.

When I have gathered the information, which the general public look for when buying a second hand vehicle I will use this information to go into my data capture sheet.

Inputs outputs and processes required

The inputs that are needed by the data system will be various details about the cars and their owners. These details will be important so that potential customers will be able to select a vehicle, which they desire and will be able to contact the owners for information such as further details or how to collect the vehicle.

The processes involved in the database are:

* Data collection

* Data preparation

* Data input

* Data verification

* Data validation

* Database searches

* Printing various forms

The outputs needed by the system are print outs that show the requirements of potential customers.

Identification of software

Data capture sheet

I have researched car companies across the country finding what details they show i

n their advertisements. Below is a list of various car companies I have found on the Internet and in

magazines or newspapers.

Internet

First I have gone onto the auto trader website, then I have gone onto dealer directory. There I have selected auto traders at random and gone onto their company website.

A Nicolas Autos

A Nicolas Autos gives the following information about the cars which they are advertising on the web site:

* Make

* Model

* Colour

* Type of car

* How many doors

* Price

* Alloy wheels

* Mileage

* Electric windows

* Air conditioning

* Taxed until

* Power steering

* Registration

* Cruise control

* Sunroof

* Convertible

* CD player

* Fuel type

Aire valley autos

Aire valley autos gives the following information about the cars which they are advertising on the web site:

* Make

* Model

* Colour

* Fuel type

* Mileage

* Doors

* Air conditioning

* Automatic transmission

* CD player

* Air bag

* Electric adjustable mirror

* Electric boot release

* Electric windows

* Power assisted steering

* Remote central locking alarm

* Climate control

* Roof rails

* Traction control system

* Year

* Car type

Data recorded in advertisements

This is a collection of data from paper based and Internet based research I have done to find what information is in an advertisement for selling a second hand car.

* Make

* Model

* Price

* Colour

* Electric windows

* Air conditioning

* Remote locking

* Remote boot

* Airbags

* Engine size

* Alloy wheels

* Registration letter (when made)

* Leather seats

* Cd player

* Spoilers

* Tinted windows

* M.O.T date

* Alarm

* Mileage

* Contact information

* Taxed date

* Power assisted steering

* Anti-lock brake system

* Remote central deadlocking

* Central locking

* Tyres

* Amount of doors

* Cruise control

* Seatbelt Pretensioners

* Parking sensors

* Sunroof

* Wash wipe

* Climate control

* Type of car

* Convertible

* Fuel type

* Automatic transmission

* Electric adjustable mirror

* Roof rails

* Traction control system

Questionnaire

Please could you tick the following depending on what information you would want to be in an advertisement for a second hand car.

Feature

Important

Non important

Make

Model

Price

Colour

Electric windows

Air conditioning

Remote locking

Remote boot

Airbags

Engine size

Alloy wheels

Registration letter (when made)

Leather seats

Cd player

Spoilers

Tinted windows

M.O.T date

Alarm

Mileage

Contact information

Taxed date

Power assisted steering

Anti-lock brake system

Remote central deadlocking

Central locking

Tyres

Amount of doors

Cruise control

Seatbelt Pretensioners

Parking sensors

Sunroof

Wash wipe

Climate control

Questionnaire results

Feature

Important

Non important

Make

80%

20%

Model

60%

40%

Price

65%

35%

Colour

40%

60%

Electric windows

58%

42%

Air conditioning

32%

68%

Remote locking

30%

70%

Remote boot

28%

72%

Airbags

94%

6%

Engine size

87%

13%

Alloy wheels

8%

92%

Registration letter (when made)

89%

11%

Leather seats

4%

96%

Cd player

17%

83%

Spoilers

6%

94%

Tinted windows

28%

32%

M.O.T date

87%

13%

Alarm

65%

35%

Mileage

83%

17%

Contact information

94%

6%

Taxed date

73%

27%

Power assisted steering

92%

8%

Anti-lock brake system

86%

14%

Remote central deadlocking

28%

68%

Central locking

74%

26%

Tyres

14%

86%

Amount of doors

63%

37%

Cruise control

7%

93%

Seatbelt Pretensioners

74%

26%

Parking sensors

13%

87%

Sunroof

33%

77%

Wash wipe

68%

32%

Climate control

8%

92%

Collection of range of data

Reasons for choice of fields, field type and field length

Validation of database

Creation of database

Database visually checked

Database edited

Test questions produced

Search database using single condition

Search database using more than one condition

User guide produced

Sorry, but A and B essays are only available for premium users

Choose a Membership Plan

We can write a custom essay on

Creating a New Database for Auto Nation PLC Essay ...

According to Your Specific Requirements.

Order an essay

logo

Emma Taylor

online

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