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 |