Description: You will be creating and populating tables in your MySQL database for a football league game schedule during the 2021 season. Drawing an ER diagram and table schemas is recommended, but not required! Each football team has a name, a stadium, and a city. Each team has one coach and multiple players. Each coach and player can coach/play for only one team per year. Each player has a name, a jersey number, and a position. Each coach has a name and a current contract end date. A game is played by two teams and has a location (one of the two teams' stadiums), scores, and a date. No team can play more than one game in a given week. Some teams will not play during a given week. Obviously, no team can play against itself. A city can have one or more football teams; a city can also have one or more stadiums. Each game played will have one quarterback from each team designated as starting quarterback. Questions: 1. Create tables that capture the stated information. Your table structure should include necessary constraints, either in the CREATE statement or by modifying the table. 2. Write INSERT statements to populate your tables with at least: a. 4 teams (which will have corresponding cities and stadiums); b. 3 players (of which one is starting QB) and 1 coach for each team; and C. 3 games. 3. You can make up your own names, use a different sport, or go to www.nfl.com for some suggestions