## Sponsors

id | name
--- | ---
1 | Nike
2 | Adidas

## Tennis_Players

id | playerName | tennisTournaments
--- | --- | ---
|  | (→ Tennis_Tournaments.id)
1 | Roger Federer | 10
2 | Novak Djokovic | 20
3 | Stan Wawrinka | 15
4 | Andy Murray | 30
5 | Dominic Thiem | 18

## Golf_Players

id | playerName | golfTournaments
--- | --- | ---
|  | (→ Golf_Tournaments.id)
1 | Tiger Woods | 79
2 | Phil Mickelson | 46
3 | Rory McIlroy | 19
4 | Jordan Spieth | 14
5 | Justin Rose | 20

## Tennis_Tournaments

id | tournamentName | sponsorID
--- | --- | ---
|  | (→ Sponsors.id)
1 | US Open | 1
2 | Wimbledon | 2
3 | Australian Open | 1
4 | French Open | 2
5 | ATP Finals | 1

## Golf_Tournaments

id | tournamentName | sponsorID
--- | --- | ---
|  | (→ Sponsors.id)
1 | Masters Tournament | 1
2 | US Open | 2
3 | The Open Championship | 1
4 | PGA Championship | 2
5 | BMW PGA Championship | 1

## Matches

matchId | tennisPlayerID | golferID | score | date
--- | --- | --- | --- | ---
| (→ Tennis_Players.id) | (→ Golf_Players.id) |  |
1 | 1 | 1 | 6-3, 7-5 | 2021-09-11
2 | 2 | 2 | 6-4, 6-7, 6-4 | 2021-09-12
3 | 3 | 3 | 6-3, 6-2 | 2021-09-13
4 | 4 | 4 | 6-4, 7-6 | 2021-09-14
5 | 5 | 5 | 6-3, 6-3 | 2021-09-15