1 Using the INVOICE table structure above, do the following:

1. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) a. Example relational schema using the Employee table from the slides: i. EMPLOYEE (EMP_NUM, EMP_NAME, JOB_CLASS) b. The general form is i. TABLE_NAME ( [list of attributes, with keys underlined] )

2. Remove all partial dependencies, write the relational schema (multiple), and draw the new dependency diagrams (for dependency diagrams, refer to the book or slideswe discussed in class). Identify the normal forms for each table structure you created.

3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also, identify the normal forms for each table structure you created.

4. Draw the Crows Foot ERD using draw.io. Submit all responses, including the ERD image from draw.io to the assignment (attach/submit all files at once). To be clear, you should submit at minimum TWO files: a document containing responses to 1-3 and an ERD image for 4.

ITD256 -Adv. DB Design Normalization Exercise (Ch06) Prof. Ammons ATTRIBUTE NAME INV NUM PROD NUM SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE 211347 211347 QD-300932X 15-Jan-2018 0.25-in. drill bit 211 NeverFail, Inc. 211347 RU-995748G 15-Jan-2018 211348 AA-E34220W 15-Jan-2018 Rotary sander 211 NeverFail, Inc 211349 GH-778345P 16-Jan-2018 Power drill 157 AA-E3422QW SALE DATE15-Jan-2018 PROD LABEL VEND CODE 211 VEND NAME NeverFail, Inc QUANTSOLD PROD_PRICE $49.95 sander Band saw BeGood, Inc ToughGo, Inc 3.45 39.99 49.95 $87.75 Using the INVOICE table structure a do the 1. Write the relational schema, draw its dependency diagram, and identify all dependencies including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key) Example relational schema using the Employee table from the slides . EMPLOYEE (EMP NUM, EMP NAME, JOB CLASS) The general form is: i. TABLE NAME list of attributes, with keys underlined] a. b. 2. Remove all partial dependencies, write the relational schema (multiple), and draw the new dependency diagrams (for dependency diagrams, refer to the book or slides-we discussed in class). Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created. Draw the Crow's Foot ERD using draw.io Submit all responses, including the ERD image from draw.io to the assignment (attach/submit all files atonce.To be clear, you should submit at minimum TWO files: a document containing responses to 1-3 and an ERD image for 4. ITD256 -Adv. DB Design Normalization Exercise (Ch06) Prof. Ammons ATTRIBUTE NAME INV NUM PROD NUM SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE 211347 211347 QD-300932X 15-Jan-2018 0.25-in. drill bit 211 NeverFail, Inc. 211347 RU-995748G 15-Jan-2018 211348 AA-E34220W 15-Jan-2018 Rotary sander 211 NeverFail, Inc 211349 GH-778345P 16-Jan-2018 Power drill 157 AA-E3422QW SALE DATE15-Jan-2018 PROD LABEL VEND CODE 211 VEND NAME NeverFail, Inc QUANTSOLD PROD_PRICE $49.95 sander Band saw BeGood, Inc ToughGo, Inc 3.45 39.99 49.95 $87.75 Using the INVOICE table structure a do the 1. Write the relational schema, draw its dependency diagram, and identify all dependencies including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key) Example relational schema using the Employee table from the slides . EMPLOYEE (EMP NUM, EMP NAME, JOB CLASS) The general form is: i. TABLE NAME list of attributes, with keys underlined] a. b. 2. Remove all partial dependencies, write the relational schema (multiple), and draw the new dependency diagrams (for dependency diagrams, refer to the book or slides-we discussed in class). Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created. Draw the Crow's Foot ERD using draw.io Submit all responses, including the ERD image from draw.io to the assignment (attach/submit all files atonce.To be clear, you should submit at minimum TWO files: a document containing responses to 1-3 and an ERD image for 4