Questions answered by you
ER Diagram:
The database records all the teams, players and matches stored in teams, players and matches tables respectively.
players_in_match, teams_in_match and teams_players are junction tables denoting many-to-many relationship. These tables denote many-to-many relationships.
For every match, the database also includes information about each delivery bowled. This information is stored in the innings, overs, deliveries, wickets,runs, and extras tables. There being a one-to-many relationship between. As in, one match has many innings, one inning has many overs, one over has many deliveries, etc.