In this homework assignment, you will create an Entity-Relationship model using your preferred notation tool.

1. Read through the following business case for the Allcar Auto Insurance company.
2. Create an Entity-relationship model with the necessary entities, attributes, identifiers and relationships to capture the data.
   • Label all entities with noun phrases. Clearly indicate an identifier (key) for each entity.
   • Label all relationships with verb phrases.
   • Specify cardinality constraints whenever possible.
   • Relationship lines should be clear enough.
3. Write out two relationship sentences for each relationship using the format: One may be (or must be) one (or many)
4. Clearly specify any assumption that you are making.

Business Case: Allcar Auto Insurance

Allcar Auto Insurance (AAI) is a company offering car insurance services for the DFW area.

• The company has a staff of employees that take on different roles such as agent, accountant, and receptionist. Each employee has an Employee ID, SSN, Sex, Name, Salary, Phone Number, and Start Date. Besides which, each agent also has a Commission Rate and the level of each accountant is recorded.
• The agents review the contents of a clients vehicle(s) and generate a policy with a unique Policy ID#, Policy Number, Start Date, End Date, Total Premium, Paid Amount, and Balance (derived). A client may be covered by one or more policies, and one policy must be associated with at least one client.
• Each client has an eight-digit Driver's License Number (DLN), Name (First Name and Last Name), SSN, DOB, Email, Address, Sex, Phone Number (one or more phone numbers), IsPrimaryPolicyHolder, and Driving Record Score.
• The covered vehicle(s) on the policy are recorded with VIN#, Year, Make, Model, and Color (may have multiple values).