Need help ! I am taking database management course. here is the question. Question - Design a database for a retail store that orders different products from various vendors and sells them to the customers. The data requirements: maintain the customer information, product inventory, product vendors, orders placed with vendors and sales to the customers. Functional requirements: product inventory information, monthly sales, profits from sales Present a conceptual database design using Entity-Relationship diagram (ERD). Determine the attributes of all the data sources from the functional requirements. Show all the entity types with possible primary keys and attributes identify the relationships with cardinality numbers and any attributes applicable to relationships. [You can use any ER online tool available for drawing the ER diagram. Eg: draw.io, ERD plus, Lucidchart etc. Refer Canvas to find other available online tools as well] thank you!
Need help ! I am taking
here is the question.
Question - Design a database for a retail store that orders different products from various vendors and sells them to the customers.
The data requirements: maintain the customer information, product inventory, product vendors, orders placed with vendors and sales to the customers.
Functional requirements: product inventory information, monthly sales, profits from sales
Present a conceptual database design using Entity-Relationship diagram (ERD). Determine the attributes of all the data sources from the functional requirements. Show all the entity types with possible primary keys and attributes identify the relationships with cardinality numbers and any attributes applicable to relationships.
[You can use any ER online tool available for drawing the ER diagram. Eg: draw.io, ERD plus, Lucidchart etc. Refer Canvas to find other available online tools as well]
thank you!
Step by step
Solved in 2 steps
