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. Project ACME Grey – Business Rules 1. 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 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.
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
You can make annotations on the diagram and/or describe the changes in text.
Project ACME Grey – Business Rules
1. 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 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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
