Create an ER diagram based on the following requirements. Show entities, relationships, and attributes.

Then convert into a relational schema. Show all tables, primary key, foreign key and referential integrity lines.

Andys Motors is a car dealership that keeps track of:

• For each sales employee a unique salesessn, a salesename, start date and the number of years with dealership
• For each service employee a unique serviceessn, and a serviceefname
• For each customer: a unique cid, a cname composed of cfname and clname, and a phone number,
• For each vehicle: a unique VIN, as well as the information about year, make and model
• For each repair appointment: a unique raptID and raptdate

Additional requirements:

• Each customer is assigned to one sales employee A sales employee must have at least one assigned customer but can have many assigned customers
• A vehicle is owned by exactly one customer Each customer owns at least one vehicle but may own many
• A vehicle may be have many repair appointments but does not have to have any Each repair appointment is associated with one vehicle
• Each service employee may participate in many repair appointments but does not have to participate in any Each repair appointment has at least one service employee participating in it but can have up to four service employees participating in it
• Each sales employee has exactly one service employee assigned to him/her as his/hers tech expert A service employee can be assigned to up to three sales employees as a tech expert, but does not have to be assigned to any