4.Resolving a Many-to-many (M N) Relationship (10 pts.) A MN relationship can exist in theory only. It cannot be implemented in a relational database. In the table shown below, the tables of JOB_CLASS and EMPLOYEE show a MNrelationship, as many employees can be assigned to many vehicles. Compared to he previous tables, more rows have been added to the Employee table. Use the table below to answer question 4 Table Name: Employee Table Name: Job Class EMP LNAME OB ID OB ID OB CLASS TYPE 1 PT Permanent 2 FT 3 FT 4 PT Tem 5 FT 6 FT 7 FT Temp 2020 2021 Smith 2022 Penn 2024 Snyder 2025 Jordan 2026 oliver 2029 Buchanan 2030 Matthew 2030Matthew 2036 Lamar 2038 Dillon 4a. Using the example in your text on page 97, Figure 3.26, create the ERD that shows the M:N relationship. Then create a resolved relationship. Use the snipping tool to copy/paste each ERD from Visio, below, just as is shown in the figure. Be sure that both ERDs contain all of the components shown. Putting it all together: Create the ERD (25 pts.) 4b. Now, expanding on what you have already created for the second ERD for #4, create a complete ERD. Include all attribute names, and identify all PK and FK attributes, such that is looks similar to what you completed for the Visio tutorial. As a hint for what constitutes your PKFK values on the resolved ERD for #4, look at the contents of the ENROLL table on page 98 AND the ENROLLS table from your completed Visio tutorial. Using the snipping tool, paste your completed ERD here. ALSO include the Visio (VSD) file in the drop box. 4.Resolving a Many-to-many (M N) Relationship (10 pts.) A MN relationship can exist in theory only. It cannot be implemented in a relational database. In the table shown below, the tables of JOB_CLASS and EMPLOYEE show a MNrelationship, as many employees can be assigned to many vehicles. Compared to he previous tables, more rows have been added to the Employee table. Use the table below to answer question 4 Table Name: Employee Table Name: Job Class EMP LNAME OB ID OB ID OB CLASS TYPE 1 PT Permanent 2 FT 3 FT 4 PT Tem 5 FT 6 FT 7 FT Temp 2020 2021 Smith 2022 Penn 2024 Snyder 2025 Jordan 2026 oliver 2029 Buchanan 2030 Matthew 2030Matthew 2036 Lamar 2038 Dillon 4a. Using the example in your text on page 97, Figure 3.26, create the ERD that shows the M:N relationship. Then create a resolved relationship. Use the snipping tool to copy/paste each ERD from Visio, below, just as is shown in the figure. Be sure that both ERDs contain all of the components shown. Putting it all together: Create the ERD (25 pts.) 4b. Now, expanding on what you have already created for the second ERD for #4, create a complete ERD. Include all attribute names, and identify all PK and FK attributes, such that is looks similar to what you completed for the Visio tutorial. As a hint for what constitutes your PKFK values on the resolved ERD for #4, look at the contents of the ENROLL table on page 98 AND the ENROLLS table from your completed Visio tutorial. Using the snipping tool, paste your completed ERD here. ALSO include the Visio (VSD) file in the drop box
