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

Figure 1: The Customer Table

After this database is fully completed it should allow users to find out about the car details and their manufacturers. I used the Internet to collect information that I needed.  This information is about the specification of the various models. The data I have collected are from search engines on the Internet, I used a variety of search engines to have a wider range.

        

2        Data Requirements

The basic structure of the database is three linked tables.  Each table contains the relevant information about the following: Customers, Cars, and Manufacturers.

(Secondary user)                        (Primary user)                                     (Secondary user)

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:

---

The Contents of the Three Tables within the Database

Figure 3: A table to show the contents of each of the three tables within the database

        

Customers: Car: Manufacturers 

Figure 3 shows the contents of the 3 tables.  The email and website addresses are in blue and underlined to show that live links can be set up within Access so that the car dealer can immediately go to the website address or to an email.  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).

---