## Audition_Room

RoomID | RoomName
--- | ---
1 | Room 101
2 | Room 202

## Dance_Recital

RecitalID | Date | Time | RoomID
--- | --- | --- | ---
|  |  | (→ Audition_Room.RoomID)
1 | 2023-07-01 | 19:00 | 1
2 | 2023-08-15 | 20:00 | 2

## Talent_Show

ShowID | Name | Description | RoomID
--- | --- | --- | ---
|  |  | (→ Audition_Room.RoomID)
1 | Summer Talent Extravaganza | A showcase of local talent. | 1
2 | Fall Variety Night | An evening of diverse acts and performances. | 2

## Participant

ParticipantID | FirstName | LastName | Age | PhoneNumber | Email | Role | RecitalID | ShowID
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ Dance_Recital.RecitalID) | (→ Talent_Show.ShowID)
1 | Jane | Smith | 25 | 555-1234 | janesmith@email.com | Dancer | 1 | 1
2 | John | Doe | 30 | 555-5678 | john.doe@email.com | Singer | 2 | 2
3 | Emily | Johnson | 22 | 555-8910 | emily.johnson@email.com | Musician | 1 | 1
4 | Michael | Brown | 28 | 555-1314 | michaelbrown@email.com | Actor | 2 | 2
5 | Olivia | Wilson | 18 | 555-2323 | oliviawilson@email.com | Comedian | 1 | 1