Performance_Events

EventIDNameTypeAudition_RoomID
(→ AuditionRooms.RoomID)
1Dance RecitalRecital1
2Dance RecitalCompetition2
3Talent ShowShowcase1
4Talent ShowFestival2

Talents

TalentIDName
1Acting
2Singng

Performers

PerformerIDNameAgeTalentID
(→ Talents.TalentID)
1John Doe301
2Jane Smith282

Participants

ParticipantIDPerformerIDEventID
(→ Performers.PerformerID)(→ Performance_Events.EventID)
111
222
313
424

AuditionRooms

RoomIDNumber
1Room 101
2Room 102

Schedules

ScheduleIDEventIDRoomIDStartTimeEndTime
(→ Performance_Events.EventID)(→ AuditionRooms.RoomID)
11119:00:0022:00:00
22217:00:0020:00:00
33116:00:0019:00:00
44214:00:0017:00:00