ArtistID | FirstName | LastName | BirthDate | Nationality |
---|---|---|---|---|
1 | John | Doe | 1980-06-15 | American |
2 | Jane | Smith | 1991-07-23 | British |
ConcertID | VenueID | Date | City | Country |
---|---|---|---|---|
(→ Venues.VenueID) | ||||
1 | 1 | 2022-12-31 22:00:00 | New York | USA |
2 | 2 | 2022-12-30 22:00:00 | Los Angeles | USA |
VenueID | Name | Address | Capacity |
---|---|---|---|
1 | Madison Square Garden | New York | 20000 |
2 | Staples Center | Los Angeles | 19000 |
TourID | ArtistID | StartDate | EndDate | Description |
---|---|---|---|---|
(→ Artists.ArtistID) | ||||
1 | 1 | 2022-01-01 | 2023-01-01 | A world tour promoting their latest album. |
2 | 2 | 2022-02-01 | 2023-02-01 | An acoustic tour featuring their greatest hits. |
SponsorshipID | ConcertID | Sponsor | Amount |
---|---|---|---|
(→ Concerts.ConcertID) | |||
1 | 1 | Adidas | 100000 |
2 | 2 | Puma | 80000 |
ID | EventName | EventType | Sponsor | Participants | PrizeMoney |
---|---|---|---|---|---|
(→ Sponsorships.Sponsor) | |||||
1 | Summer Grand Slam | Tennis Tournament | Nike | 64 | 1000000.0 |
2 | Reebok Open | Tennis Tournament | Reebok | 64 | 1000000.0 |
3 | Nike Golf Classic | Golf Tournament | Nike | 128 | 2000000.0 |
4 | Under Armour Invitational | Golf Tournament | Under Armour | 128 | 2000000.0 |