• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20

Creating a new database for Auto nation PLC.

Extracts from this document...


Aims of study 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. ...read more.


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


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 Conclusions ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Different ways of data capture

    MANIPULATION AND/OR PROCESSING Modes of Processing Main modes of processing! * Batch Processing * Pseudo real time processing * Real time TRANSACTIONS Transactions are events that need to be recorded in connection with the production, sale, and distribution of goods and services.

  2. Tod's Tyres is a small business that supplies new car tyres to company car ...

    Number of new tyres fitted has also been validated which restricts users to enter a value greater than 5, if a greater value is entered, then an error message is produced. Company details table... Validation used for "companydetailstbl"... Other fields, which have been validated in the company details table, are

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    This mode is described here for comparison purposes only. As with asynchronous transmission it is apparent that the synchronous approach offers advantages to the transmission > The amount of central information that requires to be transmitted is restricted to only a few characters at the start of each block.

  2. I have been given the task to design a database for a company called ...

    Query outputs: The results of my queries could either be displayed in a table or in a form created by a wizard. The presentation of the results would better in a form this is because of a number of reasons, which include: * It is easier to read from forms than tables.

  1. Free essay

    Setting up and E-Commerce Site

    * Hooks up with the major on-line credit card providers easily - This is very important as the link with major credit cards will not limit the businesses potential custom. The majority of people buying online will be using a major credit card and this will make it easier for them to buy.

  2. Spare Parts Database Project

    TEST EXPECTED RESULT REMARKS 1 Insert correct password and click on 'Login' Main Menu should appear on the screen. OK 2 Insert incorrect password and click on 'Login' A message saying 'Wrong password' should appear on the screen. OK 3 Click on 'Exit' The program must close.

  1. Different Control Sensors

    to many other types of electrical switching mechanisms, the electromechanical rotary switch provides a desirable means to control large numbers of circuits over a wide range of currents, voltages and power requirements. Rotary switches provide electrical control for the following types of equipment; * * Medical equipment, * Aircraft, computers,

  2. Smart Card System

    The intelligence of the integrated circuit chip in both types of cards allows them to protect the information being stored from damage or theft. For these reason smart cards are much more secure then magnetic stripe cards, which carry the information in the outside of the card and can be easily copied.

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