## Artists

ArtistID | Name | Genre
--- | --- | ---
1 | The Beatles | Rock
2 | Michael Jackson | Pop
3 | Adele | Pop

## Albums

AlbumID | Title | ReleaseYear | ArtistID
--- | --- | --- | ---
|  |  | (→ Artists.ArtistID)
1 | Abbey Road | 1969 | 1
2 | Thriller | 1982 | 2
3 | 21 | 2011 | 3

## Concerts

ConcertID | Date | City | Country | VenueName | HeadlineArtistID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Artists.ArtistID)
1 | 2021-07-15 20:00:00 | London | UK | Wembley Stadium | 2
2 | 2021-08-01 20:00:00 | New York | USA | MetLife Stadium | 1
3 | 2021-09-10 20:00:00 | Paris | France | Stade de France | 3

## Tickets

TicketID | PurchaseDate | SeatNumber | CustomerID | ConcertID | Price
--- | --- | --- | --- | --- | ---
|  |  | (→ Customers.CustomerID) | (→ Concerts.ConcertID) |
1 | 2021-07-15 12:00:00 | Section A, Row 1, Seat 10 | 1 | 1 | 100
2 | 2021-07-15 12:00:00 | Section B, Row 1, Seat 10 | 2 | 1 | 75
3 | 2021-08-01 12:00:00 | Section C, Row 1, Seat 10 | 3 | 2 | 150
4 | 2021-08-01 12:00:00 | Section D, Row 1, Seat 10 | 4 | 2 | 100

## Customers

CustomerID | FirstName | LastName | Email | PhoneNumber | AddressLine | PostalCode
--- | --- | --- | --- | --- | --- | ---
1 | John | Doe | johndoe@example.com | +1234567890 | 123 Main St | 60601
2 | Jane | Smith | janesmith@example.com | +9876543210 | 456 Elm St | 90001
3 | Emily | Williams | emilywilliams@example.com | +1357924680 | 789 Oak St | 02110
4 | Peter | Jackson | pjackson@example.com | +19876543210 | 123 Maple Ave | 19101