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

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.

Get Access

Introduction of TOPIC

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

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
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

We can write a custom essay on

Creating a New Database for Auto Nation PLC Essay ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

A Business Plan for an It Start-Up

The company is an ITES startup that makes apps and websites for third party. The business aims at targeting the lesser exploited markets of grocery stores, schools and medical stores. For doing the on-ground marketing of our services, we have planned to hire a salesman. We’ll train him well and make him enough knowledgeable about our business so that he can give us our potential customers. Digital marketing is done through social media ad campaigns like Facebook, Google and Twitter. Conventional channels like print media and radio broadcasts are also used. We are targeting the local grocery stores that cater to the needs of the general public. The concept is to bring the local stores online. This is beneficial to both the parties i. e. the customer and the store owner. The customer can place orders from his or her home. Or even when he or she is not around...

Ethical and Legal Issues Revolving

A civil action film is a based on true life experiences that revolve around the good scenarios and issues that are bound to be tried by legal bodies. It is based on the true stories that were taking part in the year 1980s when the environmental pollution took place and better parts of Woburn. There was the ethical issue revolving around the film as there was a corporate body that was using the trichloroethylene product which is the industrial solvent and uses it to contaminate the aquifer of the area that the plaintiff was residing. Therefore the film is based on the two larger firms that are damaging the environment through pollution in M.A. The ethical issue that the plaintiff presents in the court is the value that the dollar holds in comparison to the well-being of the human life (Crane & Matten, 2016). The two larger firms that are...

Business Ethics - International Trade Administration

As experts in business ethics, your expertise can be used to help breakdown a situation good or bad. In situations we can come in and erase the bad and replace with good or simple reinforce the good that is being done. In this case, we will be doing a lot of erasing for many reasons. This branch of the bank was not doing what it was supposed to in regards to protecting itself and following the country’s banking laws. “The actions cited included failing to put in effect measures to prevent money laundering, overcharging customers for financial derivative products and making loans that helped clients carry out a variety of improper deals, regulators said.” Acts like this are major unethical decisions that should never be made by employees of a bank. Such movements open up themselves as employees and the company to major back lash and trouble. All of that...

Popular Essays

logo

Emma Taylor

online

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