Observe the following table then proceed to complete the points listed below the table:
CUST_ CODE CUST_ LNAME CUST_ AREACODE CUST_ PHONE INV_ DATE INV_ AMOUNT PROD_ CODE PROD_DESCRIPT
10010 Ramas 615 844-2573 16-Mar-09 $5,000.00 11QER/31 Power painter, 15 psi., 3-nozzle
10011 Dunne 713 894-1238 16-Mar-09 $4,260.00 13-Q2/P2 7.25-in. pwr. saw blade
10012 Smith 615 894-2285 16-Mar-09 $3,800.00 14-Q1/L3 9.00-in. pwr. saw blade
10013 Olowski 615 894-2180 17-Mar-09 $2,300.00 1546-QQ2 Hrd. cloth, 1/4-in., 2x50
10014 Orlando 615 222-1672 17-Mar-09 $1,587.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
10015 O'Brian 713 442-3381 17-Mar-09 $4,500.00 2232/QTY B&D jigsaw, 12-in. blade
10016 Brown 615 297-1228 17-Mar-09 $3,600.00 2232/QWE B&D jigsaw, 8-in. blade
10017 Williams 615 290-2556 17-Mar-09 $6,720.00 2238/QPD B&D cordless drill, 1/2-in.
10018 Farriss 713 382-7185
10019 Smith 615 297-3809 20-Mar-09 $2,300.00 1546-QQ2 Hrd. cloth, 1/4-in., 2x50
10014 Orlando 615 222-1672 18-Mar-09 $2300.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
10011 Dunne 713 894-1238 16-Mar-09 $3,600.00 2232/QWE B&D jigsaw, 8-in. blade
10010 Ramas 615 844-2573 16-Mar-09 $1,587.00 1558-QW1 Hrd. cloth, 1/2-in., 3x50
Using the above Table complete the following listed below:
1. What is wrong with the table above and what anomalies arise when implementing this table?
2. What is the primary key (currently) of the table?
3. Create a dependency diagram and go through the normalisation process to convert to 3NF to eliminate these anomalies.
Include all necessary primary keys/foreign keys for the 3NF stage.