Question: In the database for a supermarket ER diagram, I need an ER diagram with (( 9 entities )) using the following requirement: costumer purchase employee
In the database for a supermarket ER diagram, I need an ER diagram with (( 9 entities )) using the following requirement:
- costumer
- purchase
- employee
- sales
- store
- branch
- suppliers
- product
- department

1. Keep track of different types of users (at least two types of users): a. Admin: people who have full privileges of accessing data and running operations. b. Users: Individuals/Organizations who have limited privileges to access data and run data. 2. Information about each entity-type should be stored with different data types. 3. Your application's database should include the following: a. Strong and weak entity types. b. Relationships of all types: i. 1-to-1 relationships. ii. 1-to-N relationships. iii. N-to-M relationships. c. Relationships with total and partial participation. d. Entity types' attributes should be from different types: i. Computed column(s). ii. Multi-value column(s). iii. Composite attribute. 4. Use rules to map your ER into tables, and assure they are in high design standards using dependencies check
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
