Problem 1 (5 points) Consider the entity relationship (ER) diagram shown in the figure below. This diagram represents aspects of the data model for a proposed "Injury Reporting System" for a large manufacturing company named Parisot Auto Manufacturing Inc. To simplify the data model for this quiz assignment, the entity symbols do not include attributes (attributes will be included for the next data modeling assignment). employs submits DEPARTMENT EMPLOYEE CLAIM REPORT completes processed by INJURY REPORT INSURANCE COMPANY documented by MEDICAL REPORT ER Diagram: Injury Reporting System for Parisot Auto Manufacturing Inc. (Prepared by Serena Lewis, 5/2/2022, version #1) What you need to do: Include cardinalities in the diagram such that it represents the information gathered from interviews (see the information provided below). Information that was gathered from interviews regarding the ER diagram for the proposed system: 1. A department may employ numerous employees. 2. Even the smallest departments in the organization (e.g., janitorial services, copy services) have at least one employee. 3. An employee works for one and only one department. 4. While being employed by the organization, an employee may complete more than one injury report. 5. If an employee has never been injured, then they would not have ever completed an injury report. 6. Each injury report is associated with one and only one employee. 7. Along with the injury report, an employee is requested to document each injury report with at least one medical report from a doctor. Some injury reports involve multiple types of injuries (e.g., a sprained wrist plus skin puncture wound) and hence may be documented by more than one medical report. 8. Each medical report is associated with one and only one injury report. 9. A specific claim report for injury compensation is associated with one and only one employee. 10. If an employee has never been injured on the job, then the employee will not have submitted a claim report. 11. It is possible that an employee may have submitted multiple claim reports over time (i.e., an employee who has been injured more than once). 12. Each claim report is processed by at least one insurance company. In some cases, a claim report may be complex (e.g., a claim report may involve a claim for medical costs plus a claim for lost wages) and hence may be processed by more than one insurance company. 13. An insurance company could be included in the data table for insurance companies even if it has not yet processed any claim reports. 14. An insurance company may have processed numerous claim reports. What you need to do: The Parisot Auto Manufacturing Inc. would like to include additional data entities and relationships to the ER diagram that you worked on above. Please make additions to your diagram to represent the following information: 1. Parisot Auto Manufacturing Inc. has been -- and is -- involved with a variety of manufacturing projects. Each of the projects is assigned to one or more departments. While most of the different departments in the organization (e.g., accounting department, production department, warehouse department, etc.) have been -- or are -- assigned to more than one project, there are some departments in the organization which have never been assigned to any of the manufacturing projects (e.g., the organization's janitorial services department has never been assigned to any manufacturing project). 2. Based on additional interviews with the management of the Parisot Auto Manufacturing Inc., the analyst has learned that a claim report may involve a variety of generic "injury claims" (i.e., types of injuries that may occur). The company believes that it would be useful to keep track of the injury claim(s) associated with each claim report. Each claim report would be associated with at least one injury claim. Some claim reports could be associated with multiple instances of injury claims (e.g., reports involving employees who had experienced an accident with multiple injuries). For the more common types of injuries (e.g., sprained wrist), an instance of an injury claim could be associated with many different claim reports. However, the set of generic injury claims listed in the injury claim table may also include instances of injury claims that have not yet been associated with any claim reports. Problem 1 (5 points) Consider the entity relationship (ER) diagram shown in the figure below. This diagram represents aspects of the data model for a proposed "Injury Reporting System" for a large manufacturing company named Parisot Auto Manufacturing Inc. To simplify the data model for this quiz assignment, the entity symbols do not include attributes (attributes will be included for the next data modeling assignment). employs submits DEPARTMENT EMPLOYEE CLAIM REPORT completes processed by INJURY REPORT INSURANCE COMPANY documented by MEDICAL REPORT ER Diagram: Injury Reporting System for Parisot Auto Manufacturing Inc. (Prepared by Serena Lewis, 5/2/2022, version #1) What you need to do: Include cardinalities in the diagram such that it represents the information gathered from interviews (see the information provided below). Information that was gathered from interviews regarding the ER diagram for the proposed system: 1. A department may employ numerous employees. 2. Even the smallest departments in the organization (e.g., janitorial services, copy services) have at least one employee. 3. An employee works for one and only one department. 4. While being employed by the organization, an employee may complete more than one injury report. 5. If an employee has never been injured, then they would not have ever completed an injury report. 6. Each injury report is associated with one and only one employee. 7. Along with the injury report, an employee is requested to document each injury report with at least one medical report from a doctor. Some injury reports involve multiple types of injuries (e.g., a sprained wrist plus skin puncture wound) and hence may be documented by more than one medical report. 8. Each medical report is associated with one and only one injury report. 9. A specific claim report for injury compensation is associated with one and only one employee. 10. If an employee has never been injured on the job, then the employee will not have submitted a claim report. 11. It is possible that an employee may have submitted multiple claim reports over time (i.e., an employee who has been injured more than once). 12. Each claim report is processed by at least one insurance company. In some cases, a claim report may be complex (e.g., a claim report may involve a claim for medical costs plus a claim for lost wages) and hence may be processed by more than one insurance company. 13. An insurance company could be included in the data table for insurance companies even if it has not yet processed any claim reports. 14. An insurance company may have processed numerous claim reports. What you need to do: The Parisot Auto Manufacturing Inc. would like to include additional data entities and relationships to the ER diagram that you worked on above. Please make additions to your diagram to represent the following information: 1. Parisot Auto Manufacturing Inc. has been -- and is -- involved with a variety of manufacturing projects. Each of the projects is assigned to one or more departments. While most of the different departments in the organization (e.g., accounting department, production department, warehouse department, etc.) have been -- or are -- assigned to more than one project, there are some departments in the organization which have never been assigned to any of the manufacturing projects (e.g., the organization's janitorial services department has never been assigned to any manufacturing project). 2. Based on additional interviews with the management of the Parisot Auto Manufacturing Inc., the analyst has learned that a claim report may involve a variety of generic "injury claims" (i.e., types of injuries that may occur). The company believes that it would be useful to keep track of the injury claim(s) associated with each claim report. Each claim report would be associated with at least one injury claim. Some claim reports could be associated with multiple instances of injury claims (e.g., reports involving employees who had experienced an accident with multiple injuries). For the more common types of injuries (e.g., sprained wrist), an instance of an injury claim could be associated with many different claim reports. However, the set of generic injury claims listed in the injury claim table may also include instances of injury claims that have not yet been associated with any claim reports