The organizers of National Football League (NFL) have decided to store information about their teams, players and games (as well as other information) in a database. You have been assigned to design and develop a database to serve that purpose. As the first step, you need to listen to their requirements and create a conceptual design. Following are their requirements: O NFL has number of teams. Each team has a unique name and their city, coach's name are also recorded. o Each player is a member of only one team. Such player has a name(first name, last name), a position which he plays at (ex: center, guard, tackle), expert class (a value in scale 1-5) and uniquely identified by player id assigned by NFL. o Each player has a set of injury records where each record associates with a record id (a unique number across the records of single player) and a description of the injury. o Each team has a captain who is also a player. o One game is played between two teams (called as host team and guest team) and also the date and the result for each game are recorded. Construct an ER diagram for NFL. Indicate all key and cardinality constraints and any assumptions that you make. The organizers of National Football League (NFL) have decided to store information about their teams, players and games (as well as other information) in a database. You have been assigned to design and develop a database to serve that purpose. As the first step, you need to listen to their requirements and create a conceptual design. Following are their requirements: O NFL has number of teams. Each team has a unique name and their city, coach's name are also recorded. o Each player is a member of only one team. Such player has a name(first name, last name), a position which he plays at (ex: center, guard, tackle), expert class (a value in scale 1-5) and uniquely identified by player id assigned by NFL. o Each player has a set of injury records where each record associates with a record id (a unique number across the records of single player) and a description of the injury. o Each team has a captain who is also a player. o One game is played between two teams (called as host team and guest team) and also the date and the result for each game are recorded. Construct an ER diagram for NFL. Indicate all key and cardinality constraints and any assumptions that you make