Draw an ERD for the following situations: A department store has a wedding registry. This registry keeps information about the customer, the products that the store carries, and the products for which each customer registers. Customers typically registers for a large number of products and many customers register for the same products.
Here the entities we have are Customer and Products.
The relationship between Customer and Product is M:N since a customer order many products while a same product can be ordered by more than one customer.
Let primary key for Customer be CustID and the order attribute be FName, LName, Address.
Let the primary key of Product be ProdID and other attribute be description. Here the Quantity of a product ordered will be attribute of relationship ORDER.
The ERD diagram is
If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks
Get Answers For Free
Most questions answered within 1 hours.