02: Red the following business case and answer the following questions (50 Marks) Case: Montreal College Championship 0 Montreal College Championship is a yearly soccer championship. Each neighbourhood in the city has one team in this championship that is named for that neighbourhood. The city council plans to develop a database to help track players and their colleges. sponsors, and teams. 0 Each team has a maximum of 1B and a minimum of 12 players. 0 It is not mandatory to have a player in the team, as long as the team is registered with the championship. o No player can join the championship without being part ofa team and cannot play for multiple teams. 0 Each team can have one to three sponsors. and each sponsor can support multiple teams. 0 Each team has a number assigned to it automatically at the beginning of the championship. o It is important for the teams to follow the guidelines regarding the age of the players. 0 In case of emergencies, teams are required to contact the schools of the players. Players will not be registered without contact information of their school. ( ' - . ' c i u i eConcordIa E'Concordla itlbpiniisiiraitmr_ 2 a) Draw the ERD of the database that could be used to support the operations of the business described in the case (20 Marks) The ERD should identify: a Primary keys and Foreign keys; - Entities and at least three Attributes for each entity; 0 Relationships and Cardinalities (e.g., one-to-one, one-to-many). Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the above case does not provide the information necessary to know which design choice should be made over another, the choice you make will be accepted if it correctly reects your assumptions. HINT: Many-to-many relationships must be split into two one-to-many relationships. Player Team POK Player _JD JK Team_JD Player_Name Team Name Player_Ape Team_Number Player School Team Neighborhood Player_Position Sponsor College POK Sponsor_10 FK Callage_ID Sponsor_Horne College Name Spomor_Address Sponsor Website Player Attends College POK Player_ID Team Sponsor College ID fox Team_ID Spotor_10