Dance_Recitals

RecitalIDNameDateTimeAudition_Room
1Spring Fling2023-03-2719:00:00Room 101
2Autumn Spectacular2023-10-1520:00:00Studio A

Talent_Shows

ShowIDNameThemeLocationAudition_Room
1Rising StarsMusic TalentsGymnasiumRoom 101
2Creative ExpressionsArtistic TalentsConference HallStage B

Performers

PerformerIDFirstNameLastNameAgeRole
1JohnSmith18Dancer
2JaneDoe22Vocalist
3MichaelBrown26Instrumentalist

Participation

ParticipantIDPerformerIDDance_RecitalIDTalent_ShowID
(→ Performers.PerformerID)(→ Dance_Recitals.RecitalID)(→ Talent_Shows.ShowID)
1111
2212
3321
44None2
55None1