Please create the relational database schema as well

12. Suppose you are given the following requirements for a simple database for the National Hockey League (NHL) . 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 a set of 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 1lth, 1999) and a score (such as 4 to 2) Construct a clean and concise ER diagram for the NHL database. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram