The description and ER diagram below capture information about UQ's new Got Talent show, which is...

Transcribed Image Text:

The description and ER diagram below capture information about UQ's new Got Talent show, which is being launched in 2023 to bring some fun and competition to campus. Convert the given ER to a relational schema including any foreign keys which were created in the process. Contestants are assigned an ID to go with their name & group size when they register to the competition. Their acts are classified as either Variety, Music, or both. Variety acts record the specific type of act, as well as any props required, while the music acts record the style, song, and song length for scheduling purposes. UQ's Got Talent staff have an ID, name and phone number recorded in the system. As this is a large event, there will be both paid and volunteer staff. Each act will have staff assigned to assist them with the process in several different roles. Paid staff will be responsible for managing the event and volunteers, or they will be specialist performers engaged as coaches for the musical acts. Each volunteer staff member will have one member of administrative staff assigned to be their manager. Each musical contestant will have a single coach assigned to them Type Variety Props Name Group Size Contestant Style Music Song M Song Length Role Assists M N Coaches) Coach Paid ID Name f Staff Member Administrative Volunteer M Manages Phone The description and ER diagram below capture information about UQ's new Got Talent show, which is being launched in 2023 to bring some fun and competition to campus. Convert the given ER to a relational schema including any foreign keys which were created in the process. Contestants are assigned an ID to go with their name & group size when they register to the competition. Their acts are classified as either Variety, Music, or both. Variety acts record the specific type of act, as well as any props required, while the music acts record the style, song, and song length for scheduling purposes. UQ's Got Talent staff have an ID, name and phone number recorded in the system. As this is a large event, there will be both paid and volunteer staff. Each act will have staff assigned to assist them with the process in several different roles. Paid staff will be responsible for managing the event and volunteers, or they will be specialist performers engaged as coaches for the musical acts. Each volunteer staff member will have one member of administrative staff assigned to be their manager. Each musical contestant will have a single coach assigned to them Type Variety Props Name Group Size Contestant Style Music Song M Song Length Role Assists M N Coaches) Coach Paid ID Name f Staff Member Administrative Volunteer M Manages Phone

Answer rating: 100% (QA)

The relational schema for the given ER diagram including foreign keys is as follows Contestant table ... View the full answer