DBS211 Lab 07 - Entity Relationship Diagrams ( Database Design ERDs ) Objective : Students work with a simple scenario to find the entities and the relationship between entities. . Students learn to define the relationship cardinality and optionality. . Students learn to design a simple database using an ERD model. Students learn how to fix many-to-many relationships in an ERD. Submission : Students MAY work in partners for this lab. It is best to complete this lab through collaboration and shared thought . Using the draw.io website, save your lab file as a PDF file. You need to submit a single PDF file for this lab. Both names, studentID's of the students, and the current date must be in the output document (make a box on the page and put the info in it). Submission without names and the date will receive a mark of zero (0). ONLY ONE SUBMISSION PER PARTNERSHIP PLEASE Tasks : Draw the corresponding crow's foot ERD for the following scenario. M: N relationships should be broken into two 1:M relationships using a bridge entity. Label PK attributes and FK when applicable. Bridge/Junction Entity: The bridge /junction entity is used to eliminate the many-to-many relationships. This entity sits between the two entities with the many to many relationships and this composite entity shares the primary keys from both tables. Show all PK's and FK's with your solution First you need to find all entities. Next, list the attributes for each entity. Next , you need to find the relationship between each two entities if there is any relationship. Fix all many-to-many relationships. Finally, make sure all PKs and FKs are properly defined