• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Database project - To facilitate the marketing of cars & to improve customer care.

Extracts from this document...


To Facilitate the Marketing of Cars & To Improve Customer Care 1 User Requirements The users of this database would be the salesmen/women in the car dealership who sets it up; the secondary user would be the customer. The primary users would need it to sort out all the paper work. This database will help many users to do their work more quickly and more efficiently. It provides information on cars, customers and manufacturer, which saves time and makes it a lot easier for the salesperson. It increases not only the efficiency of the salesperson but also improves the quality of customer care, for example the salesperson can instantly see the type of car, the last time they spoke to the customer, the last service, and any other problems that the customer has had. ...read more.


Figure 2: The relationship between the Customer and the Manufacturer via the Car Dealership Figure 2 shows how the customer is related to the Manufacturer with the Car Dealership acting as the point of contact. Special symbols are used to show that the Car dealership is dealing with MANY manufacturers and is also dealing with MANY customers. This is a special data-basing symbol and the 1:1 or 1: Many or Many:1 is crucial idea in setting up the database. Each of the three tables need to be set up differently to include the relevant information. The websites I used to help were: * http://www.bmw.co.uk/ * http://www.mercedes-benz.co.uk/ * http://www.mini.co.uk/ * http://www.nissan.co.uk/ * http://www.fiat.co.uk/ * http://www.volkswagen.co.uk/ * http://www.toyota.co.uk/ * http://www.honda.co.uk/ * http://buypower.vauxhall.co.uk/ * http://www.renault.co.uk/ * http://www.peugeot.co.uk/ * http://www.ford.co.uk/ The Contents of the Three Tables within the Database Customers Cars Manufacturers Number ID Car Company Name Title Manufacturer UK Headquarters Forename Model Website ...read more.


Phone and Fax numbers have been highlighted to show that Access can be set up to automatically dial up the number. This the salesperson's time and they don't need to pick up the phone until the person answers. The next service could be mentioned at the end of a conversation and/or texted to a mobile. Customer Table Car Manufacturer Building the tables point of the design view and the form view How have you chosen to organise this data? Remember More Data, LESS information INFORMATION STRUCTURE Block Diagram Data becomes INFORMATION when it is structured. Show the structure of your spreadsheet. 3 Building the Grids in Excel What headings do you have for the various columns, how have you formatted cells? Use screen shot(s). St Bernadette Catholic Secondary School Bristol 50759 Assignment 3 Kalun Chung Centre Number 50759 Candidate Number 8021 2/7 St Bernadette Catholic Secondary School Bristol 50759 Assignment 3 Kalun Chung Centre Number 50759 Candidate Number 8021 ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    The only other competitor to be taken seriously is Nintendo with its upcoming GameCube, who, unlike SONY, has been in this market for over 10 years now, since the appearance of its Nintendo Entertainment System, the first console to be really successful worldwide.

  2. Datbase Project newsagent shop

    This is seen below. It will be seen that from here all information needed about customers that is including location of customers, amount paid, item bought e.t.c can be found out by just looking at the report of the customers.

  1. Home Office LTD company. Database

    In the case of this product information sheet, I have locked the price cells so that no one except the managing director can change the prices. This would make sure there is no unofficial changing of the prices. The only way prices can be changed is to unprotect the sheet with the password.

  2. Background and investigation for designing a database for a DVD rental shop.

    What would you say the main problems are with the current system? The current system is very time consuming and many tasks are avoided because searching through large amounts of documents in unpractical. We sometimes have problems with handwriting and incorrect data that has been stored on forms. 24.

  1. Video World Database as ICT project.

    Basically everything including customers, videos, staff and rentals are all written out manually onto a standard form every time something needed to be updated. There are a few problems with this filing system: Keeping track of when videos are due back.

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    So the executive management needs to establish cross-discipline teams like the IT and sales manager's to work together. The same thing applies for other groups like accounting and marketing. And there is no sense in automating what is already inefficient.

  1. Beanie Project.

    Then finally will be accompanied with a test planning section, which shows auto-completion macro entries and such, which cross link data to forms and such within the document. This will be followed up with error control, showing whether what was used in the test plan was correct and whether or not it did what was required from the user.

  2. ICT Solutions for people with Special Needs.

    Of the 2.4 million disabled people on state benefits and not in work nearly a million would like to work * Fewer than 5 per cent of disabled people use wheelchairs * By the year 2010, 40 per cent of the UK population will be over 45 - the age

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