RoomID | RoomName |
---|---|
1 | Room 101 |
2 | Room 202 |
RecitalID | Date | Time | RoomID |
---|---|---|---|
(→ Audition_Room.RoomID) | |||
1 | 2023-07-01 | 19:00 | 1 |
2 | 2023-08-15 | 20:00 | 2 |
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 |
ParticipantID | FirstName | LastName | Age | PhoneNumber | 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 |