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