I'm creating an ERD for my graduation project creating a website that sells coffee machines and lets you download a mobile app that controls them remotely:
I will add the attributes and the relation for an entity "payment".
How can I improve this ERD?
We cannot judge if the entities and relationships are correct, as we don't have the requirements.
However, it is already possible to suggest improvements:
Website
only one Coffee Machines
or several? And is a Coffee machine
had by only one website
or can a same machine belong to several sites? This is essential to understand the nature of the relationships but also to derive a database implementation.offee machine
and Order
shall not be directly related: a relationship is missing in-between.Website
registers Membership
or Customer
orders Order
or Website
proposes Coffee machine