Question
ABC is a network of Electronics stores across the Country. Also, ABC is having an online shop from where any electronic appliance can be bought which will be delivered at the address given by the Customer or delivery can also be taken from the store selected by the Customer. There is also provision to visit any store and also buy goods. Whenever, goods are bought online or at store in person, the software that consists of information about the quantity of appliance that is available will be reduced appropriately. Assume that you need to develop a software system that encompasses the above mentioned acativities. Make assumptions, wherever necessary. Also, list them very clearly.
Now, with reference to the above, answer the following:
(1) List the Entities
(2) For each Entity, list Attributes
(3) Define relationships between the Entities
(4) Finally, draw the Entity Relationship Diagram
Answer :
Word Count : 525
To develop the software system for ABC electronics stores and online shopping, certain assumptions are made. It is assumed that each customer must register before placing an online order. Each store has a unique Store ID and maintains its own inventory. Each product has a unique Product ID and can be available in multiple stores. Orders can be delivered to a customer address or picked up from a selected store. A customer can purchase products either online or directly from a store. Inventory is automatically updated whenever a purchase is made. Each order may contain multiple products, and each product may appear in multiple orders. The main entities in the system are Customer, Product, Store, Order, Order_Item, Inventory, and Payment. Customer entity represents the person who buys products. Its attributes include __________ _____ ____ ______ ___ ____ ___ _________ __________.
_______ ______ _____ _________ _________ _____.
_________ ___ __________ ________ ___ ___ ____ ______ _______.
_________ _______ __________ ___ ______ ________ ____ _______ __________ _______ ___.
________ _________ ___ _______ __________ _________ ________ ____ ____.
__________ _______ ____ _____ ________ _______ _______ ___ ______ ___ __________ ________.
_____ _________ _______ _______ _______ __________ __________ _______ ________ ______.
__________ _______ ______ ____ ______ __________ _____ ____ _____ ____ ____.
________ ___ ________ ________ _____.
____ _______ ______ __________ _______ ______ _______.
_____ _____ ___ ____ _________ _________ ___.
___ __________ _____ ___ ________ __________ ____ ____ _________ ____ _____.
_____ __________ _________ ___ ___ _______ __________.
_______ _______ _________ ___ __________ _____ ____ _______ _____ _________ _______ _______.
_________ ___ _______ ____ ____ ___ __________.
______ _____ _____ _____ _____ ________ __________ ________ ____ ____ _______.
_____ _________ __________ ___ __________ _____ _________ _____.
________ _________ ______ ____ ______ _________ _________ __________ ___ ___ _____.
______ _________ ____ ________ ________ __________.
____ _____ ______ ___ _____.
______ __________ ______ ________ ___ _____ ____ __________.
__________ _________ ______ __________ _____ ___ ______.
____ ______ ____ ________ ____ __________.
__________ __________ ______ __________ ___ _____ ________.
_____ ________ __________ _______ ____ ______ _____.
________ _________ _____ ___ ________ _______ ______.
_____ ______ _______ _____ _________ _____.
______ ______ _____ _________ ___ ____ _________ ________ _____ _____ _____ ________.
_________ _____ _______ ___ _____ _______ ______ ______ ___ __________.
_____ ______ _________ _________ ______.
__________ ________ _________ _________ _______ _______ _________ _________.
___ _________ __________ _____ ____ ___ ___.
___ ____ ______ ___ __________ ______ __________ ___ __________ ____ ___.
_______ _______ _____ ____ __________ ____ _________ ____ _______.
_________ _____ ________ ______ ____ ___ ___ _______.
_______ _______ ___ ___ __________ _______ _______.
________ _________ _______ _______ ________.
____ ______ _______ _______ ____.
________ ________ _____ ____ _______ _____ _________ ___ ________ __________ _________ __________.
_______ ______ ______ __________ _____.
__________ ___ ________ _________ _______.
___ __________ _______ ____ _______ _______ _____ _________ ________.
__________ _____ _____ ________ __________ _______ ____ ___.
__________ ____ _______ _______ ____ _________ ___ _____ _______ __________ ______ __________.
__________ ___ _________ _____ ____ ____ _______ ___ ____.
______ ______ __________ ___ _______ _________.
______ _____ _______ __________ ________ ________ _________.
_________ _____ _________ _________ ______ ________ __________.
___ ___ ____ __________ ______.
Get Full Answer on WhatsApp
To develop the software system for ABC electronics stores and online shopping, certain assumptions are made. It is assumed that each customer must register before placing an online order. Each store has a unique Store ID and maintains its own inventory. Each product has a unique Product ID and can be available in multiple stores. Orders can be delivered to a customer address or picked up from a selected store. A customer can purchase products either online or directly from a store. Inventory is automatically updated whenever a purchase is made. Each order may contain multiple products, and each product may appear in multiple orders. The main entities in the system are Customer, Product, Store, Order, Order_Item, Inventory, and Payment. Customer entity represents the person who buys products. Its attributes include __________ _____ ____ ______ ___ ____ ___ _________ __________.
_______ ______ _____ _________ _________ _____.
_________ ___ __________ ________ ___ ___ ____ ______ _______.
_________ _______ __________ ___ ______ ________ ____ _______ __________ _______ ___.
________ _________ ___ _______ __________ _________ ________ ____ ____.
__________ _______ ____ _____ ________ _______ _______ ___ ______ ___ __________ ________.
_____ _________ _______ _______ _______ __________ __________ _______ ________ ______.
__________ _______ ______ ____ ______ __________ _____ ____ _____ ____ ____.
________ ___ ________ ________ _____.
____ _______ ______ __________ _______ ______ _______.
_____ _____ ___ ____ _________ _________ ___.
___ __________ _____ ___ ________ __________ ____ ____ _________ ____ _____.
_____ __________ _________ ___ ___ _______ __________.
_______ _______ _________ ___ __________ _____ ____ _______ _____ _________ _______ _______.
_________ ___ _______ ____ ____ ___ __________.
______ _____ _____ _____ _____ ________ __________ ________ ____ ____ _______.
_____ _________ __________ ___ __________ _____ _________ _____.
________ _________ ______ ____ ______ _________ _________ __________ ___ ___ _____.
______ _________ ____ ________ ________ __________.
____ _____ ______ ___ _____.
______ __________ ______ ________ ___ _____ ____ __________.
__________ _________ ______ __________ _____ ___ ______.
____ ______ ____ ________ ____ __________.
__________ __________ ______ __________ ___ _____ ________.
_____ ________ __________ _______ ____ ______ _____.
________ _________ _____ ___ ________ _______ ______.
_____ ______ _______ _____ _________ _____.
______ ______ _____ _________ ___ ____ _________ ________ _____ _____ _____ ________.
_________ _____ _______ ___ _____ _______ ______ ______ ___ __________.
_____ ______ _________ _________ ______.
__________ ________ _________ _________ _______ _______ _________ _________.
___ _________ __________ _____ ____ ___ ___.
___ ____ ______ ___ __________ ______ __________ ___ __________ ____ ___.
_______ _______ _____ ____ __________ ____ _________ ____ _______.
_________ _____ ________ ______ ____ ___ ___ _______.
_______ _______ ___ ___ __________ _______ _______.
________ _________ _______ _______ ________.
____ ______ _______ _______ ____.
________ ________ _____ ____ _______ _____ _________ ___ ________ __________ _________ __________.
_______ ______ ______ __________ _____.
__________ ___ ________ _________ _______.
___ __________ _______ ____ _______ _______ _____ _________ ________.
__________ _____ _____ ________ __________ _______ ____ ___.
__________ ____ _______ _______ ____ _________ ___ _____ _______ __________ ______ __________.
__________ ___ _________ _____ ____ ____ _______ ___ ____.
______ ______ __________ ___ _______ _________.
______ _____ _______ __________ ________ ________ _________.
_________ _____ _________ _________ ______ ________ __________.
___ ___ ____ __________ ______.
Get Full Answer on WhatsApp
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★