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
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 __________ ______ _________ _______ ___ _______ ________ ________ _________.
______ _______ __________ _____ _________.
_________ __________ _______ _______ _______.
____ ______ _____ _______ _________ _______ __________ _________ ____ _________ _____ _____.
__________ _____ ________ ________ __________ __________ _____ ______ ________.
__________ ____ _________ __________ __________ ______ _________ __________ __________.
_______ _______ ____ _________ __________ ____ ______ ___.
_____ ___ _____ _____ ___ _________.
_______ _________ ______ _______ _______ __________ ___ _____ _______ ___ __________.
_________ _________ __________ ____ ______ ______ __________ __________.
______ _____ _______ ______ ______ ___.
___ ________ _______ _____ _______ __________ ____ ___ ______.
_______ ____ __________ ________ ______ _____ _____ _______ ________ ___ __________.
_________ __________ ______ ___ _________.
_________ ____ __________ __________ ___ ________ ________ _______ _______ _________.
_____ _________ __________ _____ ____ ________.
______ _______ ________ _______ _______ ________.
______ _________ ________ ____ _____ _______ _________ ___ _________.
______ _________ ____ __________ _________ ________ ___ ___.
__________ ____ _____ _________ ___ ______ _________ _______ ______ _____ _______ ______.
__________ ___ ________ ______ ________ __________ ________ ____.
____ ___ ____ _________ ____ ___ _____ ______ ___.
________ ___ _________ _______ _______ ________ _____ _________ ______ ____ _____.
_________ _______ ___ _____ __________ __________ ____ _________ ____ ________ ____ ____.
__________ __________ _____ _____ ____ _________.
________ __________ ________ ______ ___ ___ ________ ___ _____ _______.
______ _________ _________ _____ __________ _________ ____ __________ _____ ___ ___ ____.
_________ _______ _______ ____ _______.
_______ _________ __________ ____ __________ ____.
___ __________ _______ ________ ____.
________ ________ ______ ______ ______ ___.
_____ _____ _________ ___ ____ ____ __________ ______ ____ _______ _________ _____.
______ _________ _______ ____ _______ _____ ______ ________ _____ ____ ________.
_________ _______ ________ ______ _____ ______ ________.
______ ________ _________ __________ ___ _______ __________ ___ _________ __________ ______ _______.
________ ___ ____ _____ ___ _________ ___ _______ ________ ___ _________ ________.
________ _______ ______ _________ _____ __________.
__________ _________ ____ ________ ____ ___ _____ ___ ________.
_________ _________ _____ __________ _______ ___ ______ ___.
________ _____ ____ __________ _____ ________ __________ _________ _____ _____ _____ _______.
________ ___ _________ _____ _______ ____ ________ ____ ______.
_______ _____ __________ ______ ___ ________ ______ _______ ___ _______.
_________ ____ _____ ___ _______ _________ ___ ______ _______ __________ _____ ________.
_______ _____ ______ _________ __________ _________ _______.
________ ____ _____ _____ _______ ________ _________ ________ _____.
___ ___ ____ _____ _____ ________ ________ __________ ___ ____ ________.
_______ ____ _____ ___ _______ __________ __________.
_________ ______ ____ _____ _______ ______ _____ ____ ____ _______ _______ _________.
_______ ________ ______ _____ ________ _______ ___ ____ _____ ___.
___ _________ _________ _________ _____ _________ ___.
_______.
Get Full Answer on WhatsApp