Design an ER diagram for a departmental Store. This store sells many products. The store keeps multiple quantities of these products. Each product is uniquely identified by a Product ID. In addition, the store maintains the Product Name, Price, Quantity in stock, Date of production, and Date of expiry of each product. The store sells these products to registered customers of the store. The store maintains the Customer ID, Name, Postal Address with City and Pin code, and Phone number of every customer. All the orders made by different customers are recorded in an order table. An order may consist of many products.

Identify and list the entities, attributes, relationships, cardinality, and key constraints for the description of the store given above. Make and state suitable assumptions.

Entities:

1. Product
   Attributes:

   • Product ID (Primary Key)

   • Product Name

   • Price

   • Quantity in stock

   • Date of Production

   • Date of Expiry

2. Customer
   Attributes:

   • Customer ID (Primary Key)

   • Name

   • Postal Address (including City and Pin code)

   • Phone Number

3. Order
   Attributes:

   • Order ID (Primary Key)

   • Order Date

   • Total Price

4. Order_Products (Associative _____ _______ ________ _____ _________ _______ ___ ______.
   ______ ____ __________ __________ _______ _____ _________ ____ _____ ____ _____.
   __________ ________ ________ ________ __________ ___.
   _______ ______ _______ _____ _______.
   _______ ______ ______ __________ _______ __________ _________ ______.
   ____ __________ ______ _____ ______ ______ ________.
   _____ ______ ______ ___ _________ ________ ______ _________.
   _______ ________ ___ _________ ______ _______ __________ _____ ________ ___.
   ___ _________ ______ _________ ____ ______.
   ___ _____ ____ ___ ____ _______ _____ __________ ____ _______.
   _________ _____ ________ __________ ___ _________ ______ _________ _____ ____.
   _______ ____ _____ _______ ____.
   ________ _____ _________ __________ ________ _________ _______ _____.
   __________ _____ _________ _______ ____ _____.
   ____ ________ ______ ________ ____ ____ ___ ____ ___ _____.
   ___ _________ __________ ____ _______ ____ ___.
   _________ __________ ____ _____ ____ ______ _______ _________ ________ ___ _____ _______.
   __________ _____ _____ _______ __________ ___ ___ ________ ____ __________ _________ ______.
   _________ ______ __________ ________ __________ __________ _________ ____ ________ ______ ________ ______.
   ______ _______ _____ ________ ________.
   ______ ___ ________ ________ _____ ______ __________ _____ ____ _________ _______.
   _________ _______ ______ _____ ___ ____ ________ ________ _________.
   _________ ___ _________ _______ ___ __________ ____ __________ __________ __________.
   _________ __________ ______ ______ __________ __________ __________ _____ ___ ___ __________.
   ______ _______ _____ ____ ______ ________ ____ __________.
   ________ ____ _______ _____ ________ ___ ________ _______ _________.
   ________ ___ ____ ______ ________ ____ _________ _________ __________ ___ _____ ________.
   ________ ______ _________ ______ ___ ____ ______ ________.
   ______ ____ _________ ______ ____ _____.
   _____ _________ _____ _________ ______ _________.
   _______ ______ _____ ________ ______ _______ ________ ______.
   _____ ________ ________ ______ _________ ___ ________.
   ________ _________ _____ _________ ______ ________ _______ _____ __________ ___ _________.
   ____ ___ ___ ______ _________.
   ________ __________ ________ ________ ________ __________ ________ _____.
   ____ ______ ________ _________ __________ _________ ____ _____ _______ ______ _____.
   _________ _________ ______ __________ ____ _____ ______.
   ________ _________ _______ ______ ________ _______.
   _______ __________ ______ ______ __________ _____ __________ _______ ______ ____ __________ _________.
   ________ _________ ________ _____ __________ ______ ____ ______.
   ______ __________ _________ ____ ________ __________.
   _________ ________ _______ _________ ______.
   _____ _______ __________ __________ ________ __________ ________ _________ _________ ________.
   Get Full Answer on WhatsApp