Artists

ArtistIDNameGenre
1The BeatlesRock
2Michael JacksonPop
3AdelePop

Albums

AlbumIDTitleReleaseYearArtistID
(→ Artists.ArtistID)
1Abbey Road19691
2Thriller19822
32120113

Concerts

ConcertIDDateCityCountryVenueNameHeadlineArtistID
(→ Artists.ArtistID)
12021-07-15 20:00:00LondonUKWembley Stadium2
22021-08-01 20:00:00New YorkUSAMetLife Stadium1
32021-09-10 20:00:00ParisFranceStade de France3

Tickets

TicketIDPurchaseDateSeatNumberCustomerIDConcertIDPrice
(→ Customers.CustomerID)(→ Concerts.ConcertID)
12021-07-15 12:00:00Section A, Row 1, Seat 1011100
22021-07-15 12:00:00Section B, Row 1, Seat 102175
32021-08-01 12:00:00Section C, Row 1, Seat 1032150
42021-08-01 12:00:00Section D, Row 1, Seat 1042100

Customers

CustomerIDFirstNameLastNameEmailPhoneNumberAddressLinePostalCode
1JohnDoejohndoe@example.com+1234567890123 Main St60601
2JaneSmithjanesmith@example.com+9876543210456 Elm St90001
3EmilyWilliamsemilywilliams@example.com+1357924680789 Oak St02110
4PeterJacksonpjackson@example.com+19876543210123 Maple Ave19101