A database is being constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the...

A database is being constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Implement the logical DB and insert valid set of tuples (on each DB tables created), with relevant set of constraints, keeping the functional requirements in focus, state any assumptions you make.Choose your favourite sport (e.g., soccer, baseball, football).