Question

car dealership needs to design a database for their business. It is assumed there are three tables in the database with 6 fields in each table. Give your suggestions for the most necessary fields and their proper types, propertis and PK (primary key) / FK (foreign key)

You can enlarge the answer window this way. Click in the answer box, then on the bottom right of the answer box, click on the triangle of dots icon and drag the window bigger.

Create simple data with access

Table 1: Customers

Field name	Data Type	Size/Other Properties
ID	Short Text	Primary Key
First Name	Short Text
Last Name	Short Text
Phone	Short Text
City	Short Text
State	Short Text

Table 2: Cars

Fields	Data Type	Size/Other Properties
ID		Foreign Key
Car Model
Year
Milage
Plate Number

Table 3: Sales

Fields	Data Type	Size/Other Properties

Answer 1

Table 1: Customers

Field name	Data Type	Size/Other Properties
ID	Number	Primary Key
First Name	Short Text
Last Name	Short Text
Phone	Number
City	Short Text
State	Short Text

Table 2: Cars

Field name	Data Type	Size/Other Properties
ID	Number	Foreign Key
Car Model	Short Text
Year	Date/Time
Milage	Number
Plate Number	Number
Engine Type	Short Text

Table 3:Sales

Field name	Data Type	Size/Other Properties
ID	Number	Foreign Key
Executive Name	Number
Invoice Number	Number
Amount	Number
Discount	Number
Net Amount	Number

Note:

In table 1 a change is made i.e., the primary key field(id) is made of number data type as it is convinient to use a number instead of a text for a unique field. In table 2 and table 3 the foreign key field(id) is made of number data type for the same reason.