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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!