• 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. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    Actions to increase organizational learning and overcome barriers to acquiring new knowledge and practises are also useful. 6.5 Causes of implementation Success and failure: Implementation outcome can be largely determined by the following factors: > The role of users in the implementation process > The degree of management support for

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

    There are no measures to monitor how many times a movie has been rented unless Mr. Bradshaw decides to go through the rental forms which is unpractical. Concluding Remarks Mr Bradshaw the end user is used to his position and is suffering from a paper based management system that is inefficient.

  2. Datbase Project newsagent shop

    is more difficult for a person to search for a file in a large drawer or filing cabinet than it is to search through a computer database. This reduces fatigue for the owner. ANALYSE I will analyse how an ordinary food-item and confectionaries stock inventory database will work, then I will try to show how I computerized the database system.

  1. Home Office LTD company. Database

    can keep a record of all the customers that have purchased products from the firm. It holds all their relevant contact details such as names, address, contact number, email and the amount paid by the client and date on which the products were bought.

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

    them to put projects without immediate and obvious returns on investments on the back burner; and though many companies have begun implementing CRM solutions, they are still losing customers in droves, begging the question of whether CRM implementations were worthwhile in the first place.

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

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

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