Thato, being ever curious and wanting to learn more about anything and everything, decided to try...

 

Transcribed Image Text:

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. Item Item ID EPK Component Nome Name Colour Supplier Comment on his diagram, explaining which 10 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. 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. Item Item ID EPK Component Nome Name Colour Supplier Comment on his diagram, explaining which 10 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.