Dance_Recitals
RecitalID | Name | Date | Time | Audition_Room |
1 | Spring Fling | 2023-03-27 | 19:00:00 | Room 101 |
2 | Autumn Spectacular | 2023-10-15 | 20:00:00 | Studio A |
Talent_Shows
ShowID | Name | Theme | Location | Audition_Room |
1 | Rising Stars | Music Talents | Gymnasium | Room 101 |
2 | Creative Expressions | Artistic Talents | Conference Hall | Stage B |
Performers
PerformerID | FirstName | LastName | Age | Role |
1 | John | Smith | 18 | Dancer |
2 | Jane | Doe | 22 | Vocalist |
3 | Michael | Brown | 26 | Instrumentalist |
Participation
ParticipantID | PerformerID | Dance_RecitalID | Talent_ShowID |
| (→ Performers.PerformerID) | (→ Dance_Recitals.RecitalID) | (→ Talent_Shows.ShowID) |
1 | 1 | 1 | 1 |
2 | 2 | 1 | 2 |
3 | 3 | 2 | 1 |
4 | 4 | None | 2 |
5 | 5 | None | 1 |