Question: Hello, please could you help me with solving this assignment? Thank you Question 4 Entity Relationship Diagram Review ( Marks: 2 0 ) Thato, being
Hello, please could you help me with solving this assignment? Thank you
Question Entity Relationship Diagram Review Marks:
Thato, being ever curious and wanting to learn more about anything and everything, decided to try his hand at creating a UML ERD for a relational database too. You made it look so easy after all, so he was confident he could do it too. So he wrote some new rules about a fictional manufacturing company and created the below ERD based on some web pages he consulted.
Each product requires different components during the manufacturing process. A
component can be used in multiple different products.
The quantity of each component that is used for a specific product must be stored in
the database.
The name of each product and each component must be stored in the database.
Each component is bought from a specific supplier, and a supplier can supply many
different components.
The name and address of each supplier must be stored in the database.
Each production line manufactures exactly one type of product at a time.
A colour is allocated to each production line to make them easy to distinguish.
Comment on his diagram, explaining which changes you recommend to improve the diagram to align with the business rules. Explain why you would make each change too, so he can learn from his mistakes. Also, include improvements that would make it possible to implement the design in a relational database.
Hint: Include the diagram and add letters to the diagram that you can refer to in your comments.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
