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 |