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 DiagramIn 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 typesprimary keys identified CUSTOMERPK cus CODECUST_FNAMECus_UNAMECUS STREET NOCUS STREET_NAMECUS_OTYcus STATECuS ZIPCuS_BALANCEplacesINVOICEPRODUCTINV_NUMfox PRODUCT IDCus_CODEPRODUCT_DESCRIPTIONINV DATE0ont ain:PROD_TYPEINV_TOTALPROD_BASEEMPLOY E IDPROD_CATEGORYPROD_PRICEPROD_aTY_ONHANDompletesBRAND_IDBRAND_NAMEEMPLOYEEBRAND_TYPEEMP_NUMEMP_FNAMEEMP UNAMEprovided byEMP_EMAILEMP_PHONEEMP_HIRED ATEVENDOREMP_TITLEfPK VEND_IDEMP_COMMISSIONVEND_NAMEDEPT NUMVEND_STREET NODEPT NAMEVEND STREET_NAMEDEPT AD DRESSVEND OTYDEPT PHONEVEND STATESALAMOUNTVEND ZIP

Answered: The database stores data for a company…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

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