Master Computers and Technology with Fun Quizzes & Brain Teasers!
A grocery franchise has one or more stores identified by a location. At each store, many products are available. Each product has a numeric ID, name, price, category, and aisle stock. Products belong to two broad classifications: perishable and non-perishable. Perishable products have an expiration date. Products are displayed in exactly one of many aisles that are identified by their aisle number. An aisle contains several products. Aisles are restocked by inventory at the back of the store. Each product has an associated product inventory with a store stock; this stock is used to resupply the product stock in an aisle. Some products may be out of stock. Customers purchase products from the store. Customer data is collected, primarily their name, address, and payment card (if they do not use cash). All transactions are archived in the database, connecting the product and customer along with the day and time of purchase.Required:a. Create an Entity-Relationship Diagram that accurately models this data. Your diagram should include appropriate entities, relationships, and inheritance if necessary.b. Create a Relational Diagram based on the ER Diagram from Part 1.