Create an ERD for your website database. Identify the entities, attributes, relationships and cardinalities

I'll be discussing about my ERD, which I made using draw.io, on this blog. Entity Relationship Diagrams, or ERDs, are graphical depictions of entities and the connections between them. It is a visual tool that is used in database design to show how entities—which might be people, things, concepts, or events—relate to one another.

 

(Draw.io)

The link between the consumer, the products, and the orders is depicted in the above figure. The order entity has properties like the total, the number of orders, and the payment method. Product name, primary key, and product ID are properties of the product entity. The customer entity, however, has the client's name, address, and email.

(Draw.io)