Question: sql Given the CustomerRep relation below with sample data, state the Key and Functional Dependencies. Then normalize the relation to 3NF 3) BalanceCreditlimit RepNum LastName

sql
 sql Given the CustomerRep relation below with sample data, state the

Given the CustomerRep relation below with sample data, state the Key and Functional Dependencies. Then normalize the relation to 3NF 3) BalanceCreditlimit RepNum LastName FirstName CustomerNum 126 502 713 893 260 386 665 824 334 440 586 796 CustomerName Toys Galore Cards and More Cress Store All Season Gifts Brookings Direct Johnson's Department Store Cricket Gift Shop Kline's The Everything Shop $1,210.25 $7,500.00 15 $5,025.75 $5,000.00 15 4,234.60 $10,000.00 15 $935.75 $7,500.00 15 $575.00 $10,000.00 30 $879.25$7,500.00 30 678.90 $7,500.00 30 $2,475.99 $15,000.00 30 $2,345.75 $7,500.00 45 Grove Historical Museum Store $345.00 $5,000.00 45 3,456.75 $15,000.00 45 Campos Rafael Campos Rafael Campos Rafael Campos Rafael GradeyMegan Gradey Megan Gradey Megan GradeyMegan Tian Tian Tian Hui Hui Hui Hui Almondton General Store Unique Gifts $124.75 7,500.00 45Tian

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 Databases Questions!