Question: The table here contains data for performances and their entertainers; it has not been normalized to any degree. It includes dates and venues (locations) for
The table here contains data for performances and their entertainers; it has not been normalized to any degree. It includes dates and venues (locations) for the performances, and information about the entertainers. Note that more than one entertainer can be booked for a single performance; and that we can assume that salary is a standard charge for each entertainer (not performance-specific). Advance the table to third normal form. Your resulting solution will contain multiple tables; ensure that each one has its primary key column(s) labeled inRED and any FKs have (FK) after the names. PERFORMANCE DATE VENUE ADDRESS ENTERTAINER TALENT SALARY 125 9/30/2023 Schnitzer 1037 SW Broadway Ave Storm Large Singing $1,000.00 125 9/30/2023 Schnitzer 1037 SW Broadway Ave Lucy Liu Acting $1,500.00 126 10/7/2023 Doug Fir 830 E Burnside St Bob Goldthwait & Yo-Yo Ma Comedy & Cello $1,500 & $5,000 127 10/14/2023 Aladdin 3017 SE Milwaukie Ave David Copperfield Magic $400.00 128 10/28/2023 Aladdin 3017 SE Milwaukie Ave Lucy Liu Acting $1,500.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
