The database stores data for a company XYZ that sells paint products. The company tracks the sale of products to customers. The database keeps data on customers, sales, products, which products are on which invoices, employees, the salary history of each employee, departments, product brands, vendors, and which vendors supply which product. Attached is pdf (Stage2 pdf) of the above ER Diagram In your group, you will need to submit the following for the above-given ER diagram: The given ER diagram has M:N relationship. Resolve the M:N relationships. Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not in Third Normal Form, explain why. Discuss PK and FK for each relation. Create a 3NF table for each relation. Relational data structures that translate the well-formed relation, which includes (as in the Workshop Slide: Session 7, Slide 18): relation names, attribute names and field types primary keys identified

Question

The database stores data for a company XYZ that sells paint products. The company tracks the sale of products to customers. The database keeps data on customers, sales, products, which products are on which invoices, employees, the salary history of each employee, departments, product brands, vendors, and which vendors supply which product.

Attached is pdf (Stage2 pdf) of the above ER Diagram

In your group, you will need to submit the following for the above-given ER diagram:

The given ER diagram has M:N relationship. Resolve the M:N relationships.
Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not in Third Normal Form, explain why. Discuss PK and FK for each relation. Create a 3NF table for each relation.
Relational data structures that translate the well-formed relation, which includes (as in the Workshop Slide: Session 7, Slide 18):
1. relation names,
2. attribute names and field types
3. primary keys identified