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:

  1. costumer
  2. purchase
  3. employee
  4. sales
  5. store
  6. branch
  7. suppliers
  8. product
  9. department

 In the database for a supermarket ER diagram, I need an

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!