IST 210: Organization of Data

Assignment: Problem # 3 from Chapter # 6.

(Be sure to note that this is PROBLEM and not REVIEW QUESTION).

Normalize a set of data to 1st, 2nd and 3rd normal form by creating relational schemas, dependency diagrams and an Entity Relationship Diagram (crows foot notation).

For this lab, complete problem # 3 in Chapter 6. Be sure to complete each letter (a thru d) for the problem. The ERD for letter d must be completed with the use of Microsoft Visio.

Remember to include headers on all documents you submit to include a brief descriptive title, you name and a date.

Attach all files as a single submission to Canvas.

Groups

please help thank you

238 Part 2 Design Concepts 3. Using the INVOICE table structure shown in Table P6.3, do the following: TABLE P6.3 ATTRIBUTE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE NAME INV NUM PROD NUM AA-E3422QW SALE_DATE 15-Jan-2016 PROD LABEL Rotary sander VEND CODE 211 VEND NAME NeverFail, Inc. QUANT SOLD 1 PROD PRICE $49.95 211347 211348 211347 QD-300932X 15-Jan-2016 0.25-in. drill bit 211 NeverFail, Inc. 8 $3.45 211347 RU-995748G 15-Jan-2016 211349 GH-778345P 16-Jan-2016 Power drill 157 ToughGo, Inc. AA-E3422QW 15-Jan-2016 Band saw Rotary sander 309 BeGood, Inc. NeverFail, Inc. 2 $39.99 $49.95 $87.75 a. 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 ref erences more than one product. (Hint: This table uses a composite primary key.) b. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created