Problem Description-to-ER Diagrams To Relational Model Design a database for each of the following problems. Draw a neat Entity-Relationship Diagram for each problem. USE M.N notation. DO NOT Use crows-feet notation. Translate the diagram into a relational model. It is enough to show the table design like this TABLE NAME (ColumnNamel, ColumnName2, ...) Underline the Primary Key Specify all the Foreign keys like this: ColName FOREIGN KEY REFERENCES ANOTHER TABLE (OtheCoName) . NHL (National Hockey League Database: Create an ERD for NHL database the NHL has many teams each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and zero or more injury records a team captain is also a player a game is played between two teams (referred to as host team and guest. team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2) Problem Description-to-ER Diagrams To Relational Model Design a database for each of the following problems. Draw a neat Entity-Relationship Diagram for each problem. USE M.N notation. DO NOT Use crows-feet notation. Translate the diagram into a relational model. It is enough to show the table design like this TABLE NAME (ColumnNamel, ColumnName2, ...) Underline the Primary Key Specify all the Foreign keys like this: ColName FOREIGN KEY REFERENCES ANOTHER TABLE (OtheCoName) . NHL (National Hockey League Database: Create an ERD for NHL database the NHL has many teams each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and zero or more injury records a team captain is also a player a game is played between two teams (referred to as host team and guest. team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2)