Sponsors

idname
1Nike
2Adidas

Tennis_Players

idplayerNametennisTournaments
(→ Tennis_Tournaments.id)
1Roger Federer10
2Novak Djokovic20
3Stan Wawrinka15
4Andy Murray30
5Dominic Thiem18

Golf_Players

idplayerNamegolfTournaments
(→ Golf_Tournaments.id)
1Tiger Woods79
2Phil Mickelson46
3Rory McIlroy19
4Jordan Spieth14
5Justin Rose20

Tennis_Tournaments

idtournamentNamesponsorID
(→ Sponsors.id)
1US Open1
2Wimbledon2
3Australian Open1
4French Open2
5ATP Finals1

Golf_Tournaments

idtournamentNamesponsorID
(→ Sponsors.id)
1Masters Tournament1
2US Open2
3The Open Championship1
4PGA Championship2
5BMW PGA Championship1

Matches

matchIdtennisPlayerIDgolferIDscoredate
(→ Tennis_Players.id)(→ Golf_Players.id)
1116-3, 7-52021-09-11
2226-4, 6-7, 6-42021-09-12
3336-3, 6-22021-09-13
4446-4, 7-62021-09-14
5556-3, 6-32021-09-15