I only need help with B. The template is bellow. thank you!

Questions: 1. Using the business case below in this assignment, complete the following requirements: Business Case: Montreal High School League (MHSL) The Montreal high school league (MHSL) is a volleyball league in Montreal. Each neighborhood in the city has one team in this league that is named for that neighborhood. The city council plans to develop a database to help track players and their parents, coaches, and teams. Each team has a maximum of 9 and minimum of 6 players. It is not mandatory to have a player in the team, as long as the team is registered with the league No player can join the league without being part of a team and can not play for multiple teams. Each team can have a minimum of one and a maximum of 4 coaches, but a coach can only be assigned to one toam. . During the season, each team plays 2 games (home and visitor) against each of the other teams, The scores and wins/losses are tracked after each game by the teams Each team has a number assigned to it automatically at the beginning of the league. it is important for the teams to follow the guidelines regarding the age of the players. In case of emergencies, teams are required to contact the parents of the players. Players will not be registered without contact information of at least one parent. HINT: Many-to-many relationships must be split into two one-to-many relationships a. Draw the ERD of the database that could be used to support the operations of the business described in the case (7 marks). The ERD should identify: Primary keys and Foreign keys; Entities and at least three Attributes for each entity: 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 business case does not provide the information necessary to know for certain whether one design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions. b. Create the data dictionary for your database (3 marks). To do this, you can use the template given with this assignment (datadictionary Template.xls) c. Implement the ERD using Microsoft Access 2010/2013/2016 or LibreOffice (10 marks) Microsoft Access is installed in the SCBTM computer labs. LibreOffice can be downloaded from the link below (Windows or Mac), https://www.libreoffice.org/download download, JOIN (Name M 10 M League Name 10 player plays & Team Has Man-player (Minplayers Lassigned Name (10 location IM Coach ) Name Rance FK Referenced table Format 1999 Required Pk or TK PK Y Y www.mod 9999.10 Y IY w ontworted wwwdd CHANNEL 90 V FK PK FK PK CHANNEL TYPE 99 99 V 99 PK 99999 999999999 Y + Table Name Atribute Name Contents 2 CUSTOMER custid Customer account number utane Customer ante custame Customer finne State Customer at biling date ba Customer count balance sustadores Customer maling address una Customer email address custa Customer services 10 cust surveydet Customer survey submissionate 11 channum Favorite channel 2 CHANNEL channum Channe Number chanted Chand Type 6 CHANNEL TYPE changed Chand Type ID chantve marre Channel Ten PACKAGE ped Daca name e cont Package cont 19 SUBSCRIPTION cust Customer costumber 20 Pack 21 PACKAGE CHANNEhanum Chandu Pack PROGRAM pe Progrunto Programme 25 Program Description en liten Progun time thin minutes chante Chandlet es In code Rain Code Support 30 RATING Rating Code 11 dee Rutin Description 2 SUPPLIER SD De Supplier Name 14 Open Super mailing address 25 Upcontact Suppler Contact Name fuss Phone and * SCHEDULE chaum Chand Numb whate hedviedrog under PKK PROK PKK DKK PK CUSTOMER PACKAGE GIA LA PACKAGE 9 Y Y Type Auto Number Short T25 Short Tex25 Date/Time Curry Short Text501 Shorts Short Text Dame Number(Bytel Number Numbebyte Numbertel Short Text 501 Number(Byte! Short 25 Curry Auto Number Numbebiyat Number Number Number bal Short Text251 Short Top Numberin Number Number Number Short Tal Short Text Auto Number Short Texto Short TOP Shorts Short Test Number Deine Numberly Automber Short Top Number Dan/Time Short To shorts Number Numberlang Numberbel V 9 V 90 FK FK IK PE CHANNEL TYPE RATING SUPPLER Y Y 9999 PK Y KRIKE 1991 CHANNEL www.dn v PER TPK INK PK PROGRAM 99999999 10 AGENT 1 1 ACCOUNT MOD w PK UD Username MED Modification date Mode ACCO od te mod moddane mode modate Ltd 99 wydd NEW ADO' SUBSTRO DELITE MERE 9999 V V FK IFK Customer combe 36 17 10 19 USER CUSTOMER PACKAGE PE Questions: 1. Using the business case below in this assignment, complete the following requirements: Business Case: Montreal High School League (MHSL) The Montreal high school league (MHSL) is a volleyball league in Montreal. Each neighborhood in the city has one team in this league that is named for that neighborhood. The city council plans to develop a database to help track players and their parents, coaches, and teams. Each team has a maximum of 9 and minimum of 6 players. It is not mandatory to have a player in the team, as long as the team is registered with the league No player can join the league without being part of a team and can not play for multiple teams. Each team can have a minimum of one and a maximum of 4 coaches, but a coach can only be assigned to one toam. . During the season, each team plays 2 games (home and visitor) against each of the other teams, The scores and wins/losses are tracked after each game by the teams Each team has a number assigned to it automatically at the beginning of the league. it is important for the teams to follow the guidelines regarding the age of the players. In case of emergencies, teams are required to contact the parents of the players. Players will not be registered without contact information of at least one parent. HINT: Many-to-many relationships must be split into two one-to-many relationships a. Draw the ERD of the database that could be used to support the operations of the business described in the case (7 marks). The ERD should identify: Primary keys and Foreign keys; Entities and at least three Attributes for each entity: 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 business case does not provide the information necessary to know for certain whether one design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions. b. Create the data dictionary for your database (3 marks). To do this, you can use the template given with this assignment (datadictionary Template.xls) c. Implement the ERD using Microsoft Access 2010/2013/2016 or LibreOffice (10 marks) Microsoft Access is installed in the SCBTM computer labs. LibreOffice can be downloaded from the link below (Windows or Mac), https://www.libreoffice.org/download download, JOIN (Name M 10 M League Name 10 player plays & Team Has Man-player (Minplayers Lassigned Name (10 location IM Coach ) Name Rance FK Referenced table Format 1999 Required Pk or TK PK Y Y www.mod 9999.10 Y IY w ontworted wwwdd CHANNEL 90 V FK PK FK PK CHANNEL TYPE 99 99 V 99 PK 99999 999999999 Y + Table Name Atribute Name Contents 2 CUSTOMER custid Customer account number utane Customer ante custame Customer finne State Customer at biling date ba Customer count balance sustadores Customer maling address una Customer email address custa Customer services 10 cust surveydet Customer survey submissionate 11 channum Favorite channel 2 CHANNEL channum Channe Number chanted Chand Type 6 CHANNEL TYPE changed Chand Type ID chantve marre Channel Ten PACKAGE ped Daca name e cont Package cont 19 SUBSCRIPTION cust Customer costumber 20 Pack 21 PACKAGE CHANNEhanum Chandu Pack PROGRAM pe Progrunto Programme 25 Program Description en liten Progun time thin minutes chante Chandlet es In code Rain Code Support 30 RATING Rating Code 11 dee Rutin Description 2 SUPPLIER SD De Supplier Name 14 Open Super mailing address 25 Upcontact Suppler Contact Name fuss Phone and * SCHEDULE chaum Chand Numb whate hedviedrog under PKK PROK PKK DKK PK CUSTOMER PACKAGE GIA LA PACKAGE 9 Y Y Type Auto Number Short T25 Short Tex25 Date/Time Curry Short Text501 Shorts Short Text Dame Number(Bytel Number Numbebyte Numbertel Short Text 501 Number(Byte! Short 25 Curry Auto Number Numbebiyat Number Number Number bal Short Text251 Short Top Numberin Number Number Number Short Tal Short Text Auto Number Short Texto Short TOP Shorts Short Test Number Deine Numberly Automber Short Top Number Dan/Time Short To shorts Number Numberlang Numberbel V 9 V 90 FK FK IK PE CHANNEL TYPE RATING SUPPLER Y Y 9999 PK Y KRIKE 1991 CHANNEL www.dn v PER TPK INK PK PROGRAM 99999999 10 AGENT 1 1 ACCOUNT MOD w PK UD Username MED Modification date Mode ACCO od te mod moddane mode modate Ltd 99 wydd NEW ADO' SUBSTRO DELITE MERE 9999 V V FK IFK Customer combe 36 17 10 19 USER CUSTOMER PACKAGE PE