This is a 3 step Question, on Database Design. It addresses the following: E-R diagram to represent common business solutions

Distinguish between relationship types: 1 to 1, 1 to many, and many to nun

please answer in order of the attachment

Task 1 ( Walmart has asked us to help them track inventory of school Supplies at their Omaha stores, The managers agreed on the following business rules to guide our model Each store is identified by its store ID . It will be helpful to treck the phone number and address of each store A store contains a number of items. . Items have a product number that uniquely identifies each item, . Managers would like to track the manufacturer of items It will be helpful to track the quantity and location of items in each store The same items may be sold in several Omaha stores . . . Based on these business rules, you have identified 2 entities store and item Whet kind of relationship will exist between these entities? Fill in the ERD below with the primary keys and relationship based on the business rules. Use the shapes on the insert ribbon or the pen on the draw ribbon to add the relationship following crow's foot notation Store Item PK PK METROPOLITAN Revised; Winter 2020 Com INFO 16201 Asianment2 Task 2 1221 To prepare to meet with the stakeholders on the project, you are going formalize your design by creating an ERD in LucidChad The free tier account should be sufficient to accomplish this Make sure to convert any M.N to relationships to use an associative entity When you have completed your diagram, export it as a .jpg and paste it here