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
The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 1402
  • Category: business

Get Full Essay

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

Get Access

Creating a New Database for Auto Nation PLC Essay Sample

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 in 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

We can write a custom 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...

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...

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...

Wace Group’s To Scaling A Business

M&S was highly specific about the quality of paper, size of paper, cuts as well as delivery schedule. Though quality standards and technical skills were forte of Wace Group, yet some of the major changes that the company had to accompany in its order schedule, capacity schedule and delivery schedule. Most importantly were of important concern which on one hand can pose risks to the...

Business Accounting and Assurance Coursework

The conceptual framework has been defined as ‘a coherent system of interrelated objectives and fundamentals that is expected to lead to consistent standards.’ (FASB 1978) Answer the following questions in relation to the International Accounting Standards Board’s Conceptual Framework, 2010. Q1. What is meant by general purpose financial reporting and how does it differ from special purpose financial reporting?​The financial report implies noticing down the monetary exercise...

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