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
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
Get step-by-step solutions from verified subject matter experts
