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 Entity)
   Attributes:

   • Order ID (Foreign Key)

   • Product ID (Foreign Key)

   • Quantity Ordered

   • Price _______ _______ ____ __________ _____ _____ ________ ___ _________.
     ________ _____ ____ _________ ________ _______.
     ______ ____ ______ _______ _______ ______.
     _________ _______ ______ ________ _________ _______ ____ _______.
     _______ _______ __________ ___ ____ _____ ____ __________ ______ _____ _________.
     _____ ________ _________ _________ ___ ___.
     ____ ______ ____ ________ ________ _________ ___ _______ ________.
     _______ ________ ____ _______ ________ _________ _________ ______ ________ ________.
     __________ ________ ______ ____ __________.
     __________ _________ __________ _____ ___ ___ ________ ___ _______ ____ ________ _________.
     __________ _________ ____ ______ ______ ________ ___ ___ ________ ___ ______ ________.
     ______ ______ ____ ______ ________ _________ ______ ___ ___ ____ _________.
     ________ ________ ___ _____ _____ __________ ___ _________ __________ __________ _________.
     ______ ____ _____ _________ ________ ______ _______ ________ ___ ____.
     __________ _______ ________ _____ _________ ____ ____ _________ _____ ____.
     _______ ________ _________ _____ ____ _____ ____ _____.
     __________ ___ ______ ___ __________ ________ ________ _______.
     ____ ____ ___ ____ _______ ______ ________.
     ______ ____ ______ ____ __________ _______ __________ __________ ______.
     _________ ____ _____ _________ _________ ___ _____ ____ ______ __________ ___ _____.
     ___ _____ ___ __________ ________ ________.
     _____ ______ ____ _______ ______ _____ ________ ______ ____.
     __________ _____ __________ ______ _______ _____ ___.
     _____ ____ ____ _______ __________ __________ ______ _________ _________ _____.
     __________ ___ ___ ______ ______.
     _______ ___ _____ _________ _______ ______ ______ ______ __________.
     ___ _______ _________ __________ ______ ____ ________ ________.
     ____ __________ __________ ___ __________.
     _______ _____ __________ ____ _______ ________ __________ ___ ____.
     ________ __________ __________ _____ _______ _________ _______ _________ ________ _____.
     __________ __________ ________ _________ ________ __________ __________ ________.
     _________ __________ ________ _____ _____ ___ __________.
     ________ __________ __________ ___ _____ __________.
     ______ ________ ___ ____ ____ ________ _____ __________ ______.
     ___ ____ _________ _____ ________.
     _________ _____ ______ ______ ____ _________ ______ ________ __________ _________ ______ ________.
     ____ ________ ________ __________ ______ _____ _______ _______.
     ________ __________ ___ _______ __________ ___.
     ______ ____ _________ ________ __________.
     __________ _______ ______ _____ __________ _________ ________ ______ _________ _____ ___ _______.
     __________ ____.
     Get Full Answer on WhatsApp