This is the ER model for the case where there exists the entity of Product, which has the attributes of costPrice, salePrice, Identifier, factoryCode, description. These Products are manufactured by a Factory that has the attributes of description, factoryCode, factoryAddress, and this Factory sells its products to the Distributor entity, which has the attributes of distributorCode, factoryCode, email, description, distributorName. Please do the next thing: The requirement has been expanded with the following information: 'Currently, an Excel sheet is used where we store the information of the products that customers have ordered through orders; information is stored about when an order has been delivered and who or which company has made the delivery of the order.' Expand the ER diagram seen in class to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has." Please do the IMAGE E-R Diagram Expanded
This is the ER model for the case where there exists the entity of Product, which has the attributes of costPrice, salePrice, Identifier, factoryCode, description. These Products are manufactured by a Factory that has the attributes of description, factoryCode, factoryAddress, and this Factory sells its products to the Distributor entity, which has the attributes of distributorCode, factoryCode, email, description, distributorName.
Please do the next thing:
The requirement has been expanded with the following information: 'Currently, an Excel sheet is used where we store the information of the products that customers have ordered through orders; information is stored about when an order has been delivered and who or which company has made the delivery of the order.'
Expand the ER diagram seen in class to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has."
Please do the IMAGE E-R Diagram Expanded
Step by step
Solved in 3 steps
Please, can you DRAW the NEW ER diagram to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has.