Question: The e - commerce order management system stores details about products, customers, and orders. This simplified version models how an online store might manage its

The e-commerce order management system stores details about products, customers, and orders. This simplified version models how an online store might manage its core operations.Consider the following requirements list:The system manages one or more products.Each product has a unique product ID, a name, a description, a price, and a stock quantity.A customer has a unique customer ID, a first name, last name, email address, and shipping address.A customer can place multiple orders. Each order has a unique order ID, a date, and a total amount.Each order contains one or more products. The system needs to track the quantity of each product ordered.A product can be part of multiple orders.Each products stock quantity should be updated after an order is placed to reflect the new availability.TaskDraw the entity-relationship model. Describe your modeling choices in detail, including entities, attributes, relationships, and cardinalities. DRAW THE ERM!!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!