ER Diagram for Excel database

For my Wix website, I have created a database in excel with two tables for which then I created an Entity Relationship (ERD) to illustrate the connection between the two tables.

My ER diagram contains two entities product and customer. Each entity has four attributes that characterize the entity. Between them, two entities is a relationship which I label as "Has a". Cardinality in my ERD is set to "many to many" because every product in my database has many customers and many customers will have one or many products (Lucidchart, 2022).





Reference:
Lucidchart, 2022. What is an Entity Relationship Diagram (ERD)?. [online] Lucidchart. Available at: <https://www.lucidchart.com/pages/er-diagrams> [Accessed 2 September 2022].

Comments