The Best Insurance is an company that specializes in selling Fire Insurance helping clients who bought Insurance form them . They provide free support to the corporate clients who bought Fire Insurance with long term agreement. The client is the person in the company who deal with the Insurance related transactions. Given the nature of the business, some The Best Insurance employees are given a company car to drive, and each The Best Insurance 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 Insurance. 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, company name , 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 Life insurance to clients as well. More experienced Employees often sell separate Life insurance to many different clients, while newer Employees may sell none. Likewise, not all clients have purchased Life insurance

from an Employee, whereas some clients have purchased Life insurance for their own employees from more than one Employee.

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

The Best Insurance Employee will receive commission for selling Life insurance to a client.