You are to begin the relational database design process for an invoicing system

You are to begin the relational database design process for an invoicing system for a company that sells home improvement equipment. Use the table below to answer the questions listed below the table:
1) Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies.  Assum that an invoice number references more than one product (Hint: This table uses a composite primary key.). Also assume that the table will never contain repeating groups. Clearly label your drawing.
2)  Now, remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal fomrs for each table structure you created.
Note: You can assume that any particular product is provided by one vendor; however, a vendor may provide many products, Thus, you can assume that the following dependency exists:
PROD_NUM –> PROD_LABEL, PROD_PRICE, VEND_CODE, VEND_NAME
You should produce three dependency diagrams.

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount