Answer Happy

Now that Tshepo knows that you are an expert with ERDS, he wants you to review a UMLERD 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. 1. 2. All tables in the database must have surrogate primary keys A product consists of one or more parts. Not all parts captured in the system are part of a product yet, and a part can be used in many products. 3. Each part is supplied by at least one supplier, but multiple suppliers could potentially supply the same part. 4. The following information must be stored for each product description. Proprietary information of ACME Technologies. Do not communicate with unauthorised third parties. Project ACME Grey - Business Rules The independent state of Education P 222 21, 22, 23 Product Product ID EPKS Producer Nouve Address supplies 0 Product ID FK3 Part ID {FC} Part Part ID 2PE3 Supplier ID SA Description of 2022