Now that Tshepo knows that you are an expert with ERDs, he wants you to review a UML ERD thatan intern created for another project. Below is the UML ERD and the business rules used to createit. Which 10 changes would you propose should be made to the ERD to improve its quality, sothat it can be successfully implemented in a relational database? You can make annotations on the diagram and/or describe the changes in text. please find the attach photos Project ACME Grey - Business Rules1.All tables in the database must have surrogate primary keys.2. A product consists of one or more parts. Not all parts captured in the system are part of aproduct yet, and a part can be used in many products.3. Each part is supplied by at least one supplier, but multiple suppliers could potentiallysupply the same part.4. The following information must be stored for each product: description.Proprietary information of ACME Technologies™. Do not communicate with unauthorised thirdparties. containedProduct ID E FK3Part ID EFt}inPraduct ID EPKSPfoducerPartNoumeAddressलवीकड0. Part ID EPE3Splier ID {AC}Pesriptian

each table should have a primary key but producer table does not have a primary key so add primary…

Answered: Now that Tshepo knows that you are an…

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

Now that Tshepo knows that you are an expert with ERDs, he wants you to review a UML ERD that
an intern created for another project. Below is the UML ERD and the business rules used to create
it. Which 10 changes would you propose should be made to the ERD to improve its quality, so
that it can be successfully implemented in a relational database?
You can make annotations on the diagram and/or describe the changes in text. please find the attach photos