These are just possible requirements for ER diagram of a supermarket.
Bold are entities.
- Employee
- Employee ID
- Employee fullname
- Name
- Surname
- Patronymic
- Salary
- Job
- Product
- Product ID
- Price
- Expiry date
- Section
- Section ID
- Dimensions
- Length
- Width
Some employees(e.g. assist clients or weigh products) work only in a specific section.
Products are selled only in a specific section.