what are the Data Type for all these attributes based on the following rules.

The dealership

sells both new and used cars. Base your design on the following business

rules:

$-$A salesperson is identified by a salesperson $9$ alphanumeric character id and has a

first and last name.

A salesperson may sell many cars, but each car is sold by only one salesperson.

A car is identified by a $5$ alphanumeric character id and has a $17$ alphanumeric

character serial number, make, model, color, and year.

A customer is identified by a $5$ alphanumeric character id$,$ and has first and last

name, phone number, address, and a $6$ alphanumeric character postal code.

A customer may buy many cars, but each car is bought by only one customer.

A salesperson writes a single invoice for each car he or she sells.

A customer gets an invoice for each car he or she buys.

An invoice is identified by an invoice $5$ alphanumeric character id$,$ invoice date

and an invoice total.

A customer may come in just to have his or her car serviced; that is$,$ a

customer need not buy a car to be classified as a customer.

When a customer takes one or more cars in for repair or service, one service

ticket is written for each car.

$-$A service ticket is identified by a $5$ alphanumeric character id$,$ date

received, comments, and date returned back to customer.

The car dealership maintains a service history for each of the cars serviced. The

service records are referenced by the car's serial number.

A car brought in for service can be worked on by many mechanics, and each

mechanic may work on many cars.

GEIT $3341$

$-$A mechanic is identified by a $5$ alphanumeric character id$,$ and has a first and last

name.

A car that is serviced may or may not need parts $($e$.$g$.,$ adjusting a carburetor

or cleaning a fuel injector nozzle does not require providing new parts$).$

A part is identified by a $5$ alphanumeric character id$,$ and has a name and price.