Question-2 i. Generate ERD of following Scenario: • Identify 5- attributes per Entity excluding Primary, Foreign and Unique Key. In Mall-Management System, there are multiple shops having multiple...

Extracted text: Question-2 i. Generate ERD of following Scenario: • Identify 5- attributes per Entity excluding Primary, Foreign and Unique Key. In Mall-Management System, there are multiple shops having multiple products. Each Product can be supplied by multiple vendors (suppliers) to one or more shops. Each shop can place orders for products to one or more suppliers when inventory is shop reaches minimum level in the shop. Orders for products are automatically generated to selected suppliers by Shop. Each Product is associated with at-most one category but category can have multiple products. Shop can create different campaigns in which they can offer discounts on different products for Customers. Each Campaign have specific start and end date, after expiry of Campaign end date discounts on particular products are automatically removed. Customer can place atmost 5 orders during campaign and at-most 20 products overall during the Campaign. Each campaign is run using Google Adwords and conversion from Customer Website visit to placing order is tracked using GTM (Google Tag Manager). Suppliers have their own inventory and supplier can further place order to their sub- suppliers also.