Create an ER Diagram that describes the following requirement: John is trying to help his price-conscious mother by creating an app that will save the prices of goods in their place. This app will have all the stores in their place that are categorized. Each store will have a name. A store can have multiple categories. There are some stores that have multiple branches. It is possible that other branches will have different prices for their goods or products. The addresses of the branches will also be saved. For every product that his mother wants to monitor, it will be saved in the app . She wants the product’s name to be saved including the product’s variants. She also wants the product to be categorized so that it will be easy to search for specific products. Every time her mother buys something from that store, they will save or update the prices of the items for that branch store. She also wanted to include the date when the prices were updated. With these features, his mother can easily know where to buy the cheapest goods. Provide an explanation on the cardinality ratio and participation constraints used on the ERD.
Create an ER Diagram that describes the following
requirement: John is trying to help his price-conscious mother by creating an app that will save the prices of goods in their place. This app will have all the stores in their place that are categorized. Each store will have a name. A store can have multiple categories. There are some stores that have multiple branches. It is possible that other branches will have different prices for their goods or products. The addresses of the branches will also be saved. For every product that his mother wants to monitor, it will be saved in the app . She wants the product’s name to be saved including the product’s variants. She also wants the product to be categorized so that it will be easy to search for specific products. Every time her mother buys something from that store, they will save or update the prices of the items for that branch store. She also wanted to include the date when the prices were updated. With these features, his mother can easily know where to buy the cheapest goods.
Provide an explanation on the cardinality ratio and participation constraints used on the ERD.
Step by step
Solved in 2 steps with 1 images
