Use draw.io or Visio to create the entity$-$relationship diagram to represent the following database design. Include any needed primary and foreign keys and indicate the cardinality of all the relationships. Be sure to include any bridging entities that might be needed. Links to draw.io and Visio can be found in the "Course Resources" section of the class Blackboard site.

A baseball coach wants to create a database to track players. Players play in many games, and games have many players. Players have many COVID tests, but each test belongs to only one player. Each player has a first and last name, jersey number, year, position, height, weight, home town, home state, and high school. Each game has a date, an opponent, innings played, a location city, a location state, and a final score. For each player in each game, we need to store the at bats, hits, runs, RBI, home runs, and bases on balls. For the COVID tests we need to store the date, the type of test, and the result. You may need to create primary keys for some of these entities.