Create a set of normalized relations given the invoice shown below. Start with a single table (could be in NNF) and then proceed to 1NF, 2NF and 3NF. If the first table is in NNF, explain why it is NNF and the steps to take it to 1NF. Do not draw a dependency diagram for NNF; only the relational schema is needed. At each subsequent NF show the relational schema and the dependency diagram for each table. Write out the dependencies. State clearly any (reasonable) assumptions you may make.

3. Create a set of normalized relations given the invoice shown below. Start with a single table (could be in NNF) and then proceed to 1NF, 2NF and 3NF. If the first table is in NNF, explain why it is NNF and the steps to take it to 1NF. Do not draw a dependency diagram for NNF: only the relational schema is needed. At each subsequent NF show the relational schema and the dependency diagram for each table. Write out the dependencies. State clearly any (reasonable) assumptions you may make. (34 points) Parts Invoice Invoice # Company Name Date Address # Used Price Total abor ID Description Labor Subtotal Parts+Labor Subtotal Tax rate Business Rules . The tax rate is based on the customers state. All subtotals, the tax amount, and the invoice total are computed