Question
Question 2: Points possible:30 Convert the following table to be in BCNF Form by step-by-Step method CUSTOMER_NUM CUSTOMER_NAME BALANCE CREDIT_LIMIT REP_NUM LAST_NAME FIRST_NAME 126 Toys
Question 2: Points possible:30
Convert the following table to be in BCNF Form by step-by-Step method
CUSTOMER_NUM | CUSTOMER_NAME | BALANCE | CREDIT_LIMIT | REP_NUM | LAST_NAME | FIRST_NAME |
126 | Toys Galore | $1,210.25 | $7,500.00 | 15 | Campos | Rafael |
502 | Cards and More | $5,000.00 | $5,000.00 | 15 | Campos | Rafael |
713 | Cress Store | $10,000.00 | $10,000.00 | 15 | Campos | Rafael |
893 | All season gifts | $7,500.00 | $7,500.00 | 15 | Campos | Rafael |
260 | Brookings Direct | $10,000.00 | $10,000.00 | 30 | Gradey | Megan |
386 | Johnson Department Store | $7,500.00 | $7,500.00 | 30 | Gradey | Megan |
665 | Cricket gift shop | $7,500.00 | $7,500.00 | 30 | Gradey | Megan |
824 | Klines | $15,000.00 | $15,000.00 | 30 | Gradey | Megan |
334 | The Everything Shop | $7,500.00 | $7,500.00 | 45 | Tim | Hui |
440 | Grove historical museum store | $5,000.00 | $5,000.00 | 45 | Tim | Hui |
586 | Almondron general store | $15,000.00 | $15,000.00 | 45 | Tim | Hui |
796
| Unique gifts | $7,500.00 | $7,500.00 | 45 | Tim | Hui |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started