Performance_Events
EventID | Name | Type | Audition_RoomID |
| | | (→ AuditionRooms.RoomID) |
1 | Dance Recital | Recital | 1 |
2 | Dance Recital | Competition | 2 |
3 | Talent Show | Showcase | 1 |
4 | Talent Show | Festival | 2 |
Talents
TalentID | Name |
1 | Acting |
2 | Singng |
Performers
PerformerID | Name | Age | TalentID |
| | | (→ Talents.TalentID) |
1 | John Doe | 30 | 1 |
2 | Jane Smith | 28 | 2 |
Participants
ParticipantID | PerformerID | EventID |
| (→ Performers.PerformerID) | (→ Performance_Events.EventID) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 1 | 3 |
4 | 2 | 4 |
AuditionRooms
RoomID | Number |
1 | Room 101 |
2 | Room 102 |
Schedules
ScheduleID | EventID | RoomID | StartTime | EndTime |
| (→ Performance_Events.EventID) | (→ AuditionRooms.RoomID) | | |
1 | 1 | 1 | 19:00:00 | 22:00:00 |
2 | 2 | 2 | 17:00:00 | 20:00:00 |
3 | 3 | 1 | 16:00:00 | 19:00:00 |
4 | 4 | 2 | 14:00:00 | 17:00:00 |