• 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. Background and investigation for designing a database for a DVD rental shop.

    Do you store information about your customers? If so, how and what is it stored in? Yes we do. When a member form is filled we obtain information on the customer's name, age, contact details and address. 7. Do the customers have unique customer identification numbers?

  1. Datbase Project newsagent shop

    Item name/type. All these information would have been gotten from paper, which would contain all the field names so that where the data is to be entered and analysed it would not take a long time to find an item and its details, and to change its price or apply a discount would not be should a big hassle.

  2. Home Office LTD company. Database

    This sheet can also be used to create a mail merge file in word; this can be used for sending out mass newsletters and information to all clients with their own personal details on the letter. Also another purpose of this sheet is so that the user can add the

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

    This raises research questions like "Which is the best software vendor to rely on?" and "What are the different issues concerned with failure in different software products?" Following are the problems faced by different corporate executives in the corporate world in implementing CRM and by going through these will give

  2. Intermediate GNVQ Sample Database Assignment - Bolton Tools Database

    � 22.75 � 28.00 � 33.25 � 35.00 13 � 20.00 � 26.00 � 32.00 � 38.00 � 40.00 14 � 21.50 � 27.95 � 34.40 � 40.85 � 43.00 15 � 23.50 � 30.55 � 37.60 � 44.65 � 47.00 16 � 26.00 � 33.80 � 41.60 � 49.90

  1. Critically assess the personal attributes you would expect to find in a successful project ...

    It is therefore essential the project manager is a good negotiator and gets upper management 'on side'. Another fundamental aspect of successful project management is that of 'technical mastery' (Lackman 1987, p 13). Most academics in this area, (Slack et al 1995; Maylor 2002; Lackman 1987; Flannagan 1993; Male &

  2. The company that I have been studying in this Task is ECsoft (European Community ...

    Therefore Pink Roccade act as a Help Desk towards the workers in the company. The responsibilities that David Gardiner has as a systems administrator for the company are that he has to be able to manage and make decisions quickly.

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