3. Using the INVOICE table structure shown in Table P6.3, do the following: |SAMPLE VALUE SAMPLES SAMPLE |SAMPLE SAMPLE VALUE ATTRIBUTE NAME INV NUM PROD NUM VALUE 211347 QD- VALUE 211347 RU- VALUE 211349 GH 211347 211348 342 15-Jan-2018 15-Jan-2018 15-Jan 74 342 15-Jan-2018 16-Jan-2018 5P SALE DATE 2018 0.25-in. drill Band saw Rotary PROD_LABEL Rotary Power dril sander sander ND VEND NAME NeverFail, NeverFai, BeGood, NeverFai, ToughGo, Inc Inc 8 Inc Inc nc UANT SOLD1 a. Convert the table to 1NF (define a Primary Key and eliminate any repeating groups) b. Convert 1NF to 2NF-(remove any partial dependencies). If the 1NF table has a single Primary Key, then it is automatically in 2NF. If the 1NF table has a Composite Primary Key, then you will need to convert the 1NF table to 2NF C. Convert 2NF to 3NF- (remove any transitive dependencies) d. Create the Crows Foot Diagram of the tables in 3NF using Lucid Charts