Task 1 (25 points): Use the following data model to answer the following questions. The entities represented are: Customer, Car, Maintenance, Maint Detail, and Part a. Is the 'Car' mandatory or optional in the relationship between the 'Car' and the 'Customer'? b. Which entities have primary keys identified? c. In the relationship between Car and Customer, which entity has the foreign key? Task 2(10 points): The Harry Atkins, the manager of the Really Good Sales Company, wants to keep track of salespeople and products sold by the company. Initially, Harry simply wishes to keep up with salespeople and the products they bave sold. Harry wants to store the names of his salespeople, commission, the year that they were hired, the names of products they have sold, and the unit price for each product. For each product sold, Harry would also like to know the date of sale and quantity of sold Harry begins to create the ERD; however, he needs your help in finishing it 1. Which of the following BEST describes the relationship between the entities. Salesperson and Product, in the above incomplete ERD? a. One-to-one b. One-to-many c. Many-to-many d. None of the above 2. Based on your answer to the previous question: how many tables will you need to implement the relationship between Salesperson and Product in a relational database? a. 1 b. 2 c. 3 d. 4 Task 3 (15 points) Draw an ERD: A patient may generate many elaims but each claim is generated by one and only one patient: A claim contains one or more claim lines but each claim line belongs to exactly one claim. A procedure type may be written in zero or many claim lines but each claim line refers to one and only one procedure type. Attributes (not including foreign keys) for each entity include the following: 1. Patient: Patient number, Patient first name, Patient last name, Patient street, Patient city, Patient state, Patient zipeode 2. Claim: Claim number, Claim date, Claim total cost 3. ClaimLine: ClaimLine adjustment, ClaimL ine line procedure cost 4. ProcedureType: ProcedureType name, ProcedureType description, ProcedureType baseCost