| id | TypeName |
|---|---|
| 1 | Improvised Theatre |
| 2 | Musical |
| 3 | Concert |
| 4 | Play |
| 5 | Dance Recital |
| id | Name |
|---|---|
| 1 | Cambridge Theatre |
| 2 | Broadway Theater |
| 3 | West End Theatre |
| 4 | Off Broadway Theatre |
| 5 | Royal Albert Hall |
| id | TypeID | VenueID | Date |
|---|---|---|---|
| (→ PerformanceTypes.id) | (→ Venues.id) | ||
| 1 | 1 | 1 | 2024-03-13 12:35:54 |
| 2 | 1 | 2 | 2024-03-13 12:35:54 |
| 3 | 2 | 1 | 2024-03-13 12:35:54 |
| 4 | 2 | 3 | 2024-03-13 12:35:54 |
| 5 | 3 | 5 | 2024-03-13 12:35:54 |
| id | FirstName | LastName | BirthDate | Biography |
|---|---|---|---|---|
| 1 | John | Smith | 1980-06-15 | Born in London, John Smith is a talented musician. |
| 2 | Jane | Doe | 1978-03-22 | A famous actress known for her work in theater. |
| 3 | Michael | Jackson | 1958-08-29 | The King of Pop, Michael Jackson, has left an indelible mark on music history. |
| 4 | Emma | Watson | 1990-04-15 | English actress best known for playing Hermione Granger in the Harry Potter series. |
| 5 | Leonardo | DiCaprio | 1974-11-11 | One of Hollywood's most versatile actors, Leonardo DiCaprio has won numerous awards throughout his career. |
| id | ArtistID | PerformanceID | Role |
|---|---|---|---|
| (→ Artists.id) | (→ Performances.id) | ||
| 1 | 1 | 3 | Lead Singer |
| 2 | 2 | None | Actress |
| 3 | 3 | 5 | Main Act |
| 4 | 4 | None | Supporting Actress |
| 5 | 5 | None | Actor |
| id | PerformanceID | Price | Quantity |
|---|---|---|---|
| (→ Performances.id) | |||
| 1 | 1 | 30 | 100 |
| 2 | 2 | 40 | 150 |
| 3 | 3 | 45 | 200 |
| 4 | 4 | 50 | 250 |
| 5 | 5 | 60 | 300 |