Audition_Room

RoomIDRoomName
1Room 101
2Room 202

Dance_Recital

RecitalIDDateTimeRoomID
(→ Audition_Room.RoomID)
12023-07-0119:001
22023-08-1520:002

Talent_Show

ShowIDNameDescriptionRoomID
(→ Audition_Room.RoomID)
1Summer Talent ExtravaganzaA showcase of local talent.1
2Fall Variety NightAn evening of diverse acts and performances.2

Participant

ParticipantIDFirstNameLastNameAgePhoneNumberEmailRoleRecitalIDShowID
(→ Dance_Recital.RecitalID)(→ Talent_Show.ShowID)
1JaneSmith25555-1234janesmith@email.comDancer11
2JohnDoe30555-5678john.doe@email.comSinger22
3EmilyJohnson22555-8910emily.johnson@email.comMusician11
4MichaelBrown28555-1314michaelbrown@email.comActor22
5OliviaWilson18555-2323oliviawilson@email.comComedian11