 |
 |
 |
 |
Structure of the Customer table
|
Field Name |
Data Type |
Field Size |
Primary Key? |
Description |
|
Customer ID |
Text |
3 |
Yes |
Customer number (primary key) |
|
Customer Name |
Text |
20 |
|
Customer/Dealer name |
|
Contact Person |
Text |
20 |
|
Contact person |
|
Phone |
Text |
8 |
|
Contact phone number |
Table 3
Data for the Customer table
|
Customer ID |
Customer_Name |
Contact Person |
Phone |
|
COM |
Complete Auto Sales |
Your Name |
455-3451 |
|
SPO |
Sports Car Emporium |
Mario Smellhouse |
455-6639 |
|
PET |
Pettys Antiques |
Bonnie York |
456-7877 |
|
TRA |
Travel All Auto |
Kari Thompson |
415-2258 |
|
MEL |
Mels Classic Car Lot |
Mel Radbell |
785-9111 |
|
OTT |
Ottos Old Autos |
Otto Foreman |
555-8890 |
Table 4