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:
-
Product
Attributes:-
Product ID (Primary Key)
-
Product Name
-
Price
-
Quantity in stock
-
Date of Production
-
Date of Expiry
-
-
Customer
Attributes:-
Customer ID (Primary Key)
-
Name
-
Postal Address (including City and Pin code)
-
Phone Number
-
-
Order
Attributes:-
Order ID (Primary Key)
-
Order Date
-
Total Price
-
-
Order_Products (Associative Entity)
Attributes:-
Order ID (Foreign Key)
-
Product ID (Foreign Key)
-
Quantity Ordered
-
Price at the time of order
-
Relationships:
-
Product-Sold-To-Customer
-
A customer can make many orders, and each order can contain many products.
-
_________ _______ __________ ______ ______ _______ ___ _______ _____ _______.
_____ ________ ___ ___ __________ ____ ____.
________ _____ ______ _________ _____ ______ _____.
_________ ____ __________ _____ _______ ________ ______ _______ __________.
________ __________ __________ _________ __________.
__________ _________ _________ ____ ________ ________ __________ _________.
______ ____ ____ ______ ___.
___ ________ ________ ___ _____ ____ _______ _____ ____.
______ _____ _______ ____ ____ _______.
___ _____ ___ _____ ____ ___ _________ ________ ____ ______.
_________ __________ _____ ________ __________ ________ ___ ___.
___ __________ ____ _______ ________ ______ _____.
______ _________ ____ _____ ___.
______ ____ ________ __________ ____ __________ __________ _________ ________ ___.
______ _______ ________ _____ ______ _______ _______.
________ _________ _______ ___ __________.
________ ___ __________ _______ ____ ________ _________ _____.
______ ________ ____ _____ ____ ____ ________ ______ ______.
_______ ____ _______ ______ _______ _____ ____.
___ _________ _________ ______ ________ ___ ___ _________ ____ _____ ______ _____.
_____ ________ ______ __________ ___.
___ _________ ___ _____ ____ ____.
_________ _________ _________ ________ _______.
_____ _____ __________ ________ _________ __________ ____.
________ ________ ______ ____ __________ _______ ______ _________ ___ ___ _________ ________.
___ ___ _____ ____ ___ __________ ___ _________ __________ __________.
_______ _________ _____ ______ ______ ______ _______ _____ __________ __________.
_____ ________ _______ ___ ____ ______ ____.
________ ______ _____ ___ ___.
__________ __________ _____ ____ _____ __________ ____ _______ ________ ____ ___.
_____ _________ _________ ________ ________ _________ _________ ___ ______.
______ _________ _____ _______ _______ ______ _________ _______.
_____ _________ ________ ______ _____ ___ ____ ____ ___.
____ __________ _________ ________ ______ ______ _________.
_____ _______ ___ _______ _________ ______ ____.
____ __________ ________ _____ __________ __________.
_____ _____ _________ ____ ______ _____ __________ ____ _______ _______ ________ _____.
______ ____ ___ ________ _____ _________ ____.
__________ ____ __________ _______.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required