Indexing I have written notes on indexing that I have included in your course in D2L. A link to these notes (Indexes Explained.docx) is provided in the Ch3 Required Reading & Notes" section of the course. Please read and study these notes. Resolving a Many-to-many (M:N) Relationship (18 pts.) A M:N relationship can exist in theory only. It cannot be implemented in a relational database. Both sets of the tables of FLEET and EMPLOYEE show a M:N relationship, as many employees can be assigned to many vehicles 4. Using the examples in your text, create the ERD that shows the M:N relationship between FLEET and EMPLOYEE. Then create the resolved ERD. 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 3. Following are the same two tables of FLEET and EMPLOYEE, but we have changed our business to now share vehicles. Also, more employee records are shown. Reference these updated tables, shown below, to complete the tasks that follow below. Table Name: FLEET Table Name: EMPLOYEE VEH ID 1 2 VEH_ID VEH_TYPE 1 1 Truck-FLOATER 2 Truck 3 Truck 4 Truck 5 Truck 6 Van 7 Line Service Truck EMP_CODE 10 20 30 40 En 50 CA 60 70 Putting it all together: Create the ERD (25 pts.) 5. 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 from your text and the ENROLLS table from your completed Visio tutorial to help 3 4 L_NAME Davolio Grubb Leverling Penn Buchanan Smith King Callahan Dodsworth Klein Johnston Phillips Basil Sunn Barker 1 5 80 Using the shipping tool, paste your completed ERD here. ALSO include the Visio (VSD) file in the drop box. 1 90 100 110 120 130 140 150 1 2 2 4