Question: Draw an E - R diagram for the scenario below. A grocery shop management system includes several entities: Products ( including product D , name,
Draw an ER diagram for the scenario below. A grocery shop management system includes several entities: Products including product D name, price, category, and supplier ID; Suppliers including supplier ID name, contact information, and products supplied; Employees including employee ID name position, and shift timings; Sales including sale ID product ID employee ID date, and transaction details; and Inventory Records including record ID product ID quantity, and stock date The system needs to track sales transactions, manage inventory updates, and maintain employee details. Each product may be supplied by multiple suppliers and sold in various transactions. Employees are assigned specific shifts and roles within the shop. Inventory records are updated regularly to reflect current stock levels. Each sale records the specific employee responsible for that transaction
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
