Question: Fix the following issues in the diagram. 1.Missing or extra tables including primary key corrections. 2.Get rid of any Missing or incorrect fields 3. Get
Fix the following issues in the diagram. 1.Missing or extra tables including primary key corrections. 2.Get rid of any Missing or incorrect fields 3. Get rid of any Missing or incorrect relationships including foreign key placement. 4. Add subtypes in the correct places in the diagram. 5. Get rid of all Many to Many relationships in the diagram.

Professional CE Provider Gende Provider Name Address Starte Date Main Phone Number submits Enrollment Application Enrollment ID ualifi Application ID Code SSN Numbe obtains Qualification License Type ID ction ID Renew License ID rm cation ID Decision Date ua ApplicationID has requires Qua Type License Section cense DocumentID Name Document ction Title CECourse ID Submission Date Section Number has requires ReviewID Term ApplicantFirst Name Room Number ApplicantLast Name Document Description License License ID Qual cationType SSN License Type ID cation eID ua Decision Date Qua cation Name Expiration Date DMQAStaff Staff D DepartmentID License ID Renew alID Hire Date Position ID LoginID cation ua cation ua License Type Degree Type Issue Date School Expiration Date Graduation Date InstructorEmployment oyment ID FEIN Employment Division has has nstructorID SSN nstructorStartDate has Lecturer nstructo struct o ProfessorType Lecturer Type enure Date CE Course CECourse ID FEIN Qual Course Number Course Name Course Hour
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
