Correct the following issues in the diagram.

1.Missing or extra tables including primary key correction

2.Missing or incorrect fields

3. Missing or incorrect relationships including foreign key placement.

4. Add subtypes in the correct places in the diagram.

5. get rid of Many to Many relationships.

CAK S2017 Medical License Management HIM 6217 Assignment 3 Spring 2017 structorEmployment Blaney, A.; Johnson, C.; Lopez, S.; White, K Professio CEProvider EIN EmploymentDivision Gender Provider Name Address MainPhoneNumber Application Code Inst rtDate SSN Numb Qualificatio Section Number License TypeID Term ST RUS LicenselD SSN ApplicationlD Decision Date requires ypelD LicenseType Title urselD SectionNuml requires CECourse Review ID Term ApplicantFirstName RoomN ApplicantlastName Document Description License Qualific onTypelD CourseNumber Cours eName Qualification Type SSN Course Hout License ypeID Decision Date Qualification Name pirationDate DMQAStaff Dep LicenselD NA RenewalID Min Hire Date PositionID LoginID Licensing Degree License Type Degree Type ssueDate School piration Date Graduation Date G PEE. Contracted Salary R Hourly Rate Co ContractEnd Date ONCE Grading G20 ID Attributes (40) ix Attrib problems[20) Amisk, ATTRIBUTES Foreign Keys (05 New Descriptions (10 Total (100)