create an 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,

A basketball 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, position, height, home town, and home state. Each game has a date, an opponent, a location city, a location state, and the opponent's final score. For each player in each game, we need to store the points scored, the minutes played, field goals made, field goals attempted, 3-point shots made, 3-point shots attempted, free throws made, free throws attempted, and the values for rebounds, blocks, assists, and steals. For the COVID tests we need to store the date, the type of test, and the result.