The Best Software is an company that specializes selling software and in helping clients who bought software form them. They provide free support to the corporate clients who bought software with long term license agreement. The client is the person in the company that uses The Best Software products.

• Given the nature of the business, some The Best Software employees are given a company car to drive, and each The Best Software company car must be assigned to an employee.
• Each employee has a unique employee number, plus an address and set of certifications. Not all employees have earned one or more certifications.
• Company cars are identified by their vehicle id, and also contain a license plate number, make, model, and year.
• Employees represent clients for their account. Not all employees represent clients, while some employees represent many clients.
• Each client is represented by one and only one employee. Sometimes clients refer one another to use to the Best Software.
• A given client can refer one or more other clients. Each client is assigned a unique client number.
• Additional attributes recorded for each client are; name of the person, company name, company address, and phone number and email.

QUESTION1 : Develop and design Presentation Layer ER diagram based on Chens Model. Decide and show the related attributes based on given parameters on the ER diagram. For each Entity, identify the primary key as well.

Once you define the entities, then draw Presentation Layer ER diagram that shows the entity types and relationship types. Explain the relationship among the entities. While you must name each relationship type and define its structural constraints, it is not necessary that you supply role names. Provide our solution in ER diagrams (Conceptual ER diagram symbols) by using free online tool at www.DRAW.io and the place them in your final presentation document.

QUESTION2 Revise the ER diagram drawn in the previous section (Question 1 ) to include the followings:

Employees can sell Laster Printers to clients. More experienced Employees often sell separate Laster Printers to many different clients, while newer Employees may sell none. Likewise, not all clients have purchased a Laster Printers from an Employee, whereas some clients have purchased Laster Printers from more than one The Best Software Employee.

QUESTION3 Revise the ER diagram drawn in the previous section (Question2) to include the followings:

Employee will receive commission for selling a Laster Printer to a client.