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
__________ _________ __________ _____ _____ ___ __________ ___.
_______ __________ ________ ____ ______ ______ ____ _________ ___ ______ ______ ______.
____ __________ ______ ________ ________ _______ ___.
_______ ________ ________ __________ _______ ______ __________ _________ ________ _________ __________ ____.
_____ _________ ____ _______ _______ ____ ________ ____ ________.
_________ ___ _______ __________ _________ ___.
___ _____ ___ ______ ____ _________ ______ _____ _________ ___ ___ _____.
_________ ___ ____ _______ ____ ___ ______ ______ _______ ________ ________.
_______ _______ _____ _______ ______ _____ ___ _________ ________ ___ ____ ________.
________ _______ ___ __________ ____ _______ ________ _____ _________ __________ ________.
______ ___ _____ ___ _________ ________ _______.
_____ _______ ________ _____ __________ __________ _____ ___ ______ __________ ___ ___.
_______ ________ ______ ________ _________ _______ _________.
_______ ________ _________ _________ __________ ___ ______ __________ ________ ____ ________.
____ _______ __________ _____ ______ ______ _________ _______ __________ __________.
_______ _________ ____ _________ _____ _______ ____.
__________ ____ ________ ___ _________ ______ _____.
__________ _____ ___ ______ ______ ___ ______ ___ ____ ____.
_______ ______ _______ __________ _________ _________ _________ ____ __________ _______ ___ _________.
______ ____ ___ ________ ____ __________ _______ _____.
_____ __________ ________ ________ ____ __________ ____ ____ ______.
__________ ___ _________ ___ ________ _______ ___ ______ _________.
__________ _____ ___ __________ _____ ___ ________ ________ ____ ______.
______ ________ _________ ________ ________ ____ ____ ________.
__________ __________ ________ ______ ____.
________ __________ ___ __________ ____ ________ ___ ___.
___ ____ __________ ____ __________ __________ ___ __________ _______ ____ ____.
___ ___ _______ _______ ___.
___ __________ _____ ___ __________.
____ ____ _________ ____ ____ __________ _______ ___ ___ __________.
_______ _______ _______ _________ ____ _________.
____ ______ ________ _______ ____.
_______ ______ __________ ___ ________.
____ __________ ________ ______ ________.
_______ ____ _______ _______ ____ _________ _________ ____ ________.
___ _____ ____ _________ _________ ______ _____ ____ _____ ______ ___ ________.
_____ ___ _______ ____ _________.
_________ _________ ________ _______ __________ _____ _________ _____.
__________ ______ ______ _____ _________ ____ ____ ________ ______ _________ ____ _______.
___ __________ ______ _________ __________ ______ _____.
____ _____ _________ ____ ______.
_______ __________ ________ ____ ______ _____ _______ _______ _________.
________ ____ ______ ___ ________ _________ ________.
____ _____ _________.
Skip in 10
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 Customer_ID (Primary Key), Name, Email, Phone_Number, Address, and Registration_Date. Product entity represents the electronic appliance available
_________ ___ __________ _________ ___ ___ ____ ______ ____.__________ _________ __________ _____ _____ ___ __________ ___.
_______ __________ ________ ____ ______ ______ ____ _________ ___ ______ ______ ______.
____ __________ ______ ________ ________ _______ ___.
_______ ________ ________ __________ _______ ______ __________ _________ ________ _________ __________ ____.
_____ _________ ____ _______ _______ ____ ________ ____ ________.
_________ ___ _______ __________ _________ ___.
___ _____ ___ ______ ____ _________ ______ _____ _________ ___ ___ _____.
_________ ___ ____ _______ ____ ___ ______ ______ _______ ________ ________.
_______ _______ _____ _______ ______ _____ ___ _________ ________ ___ ____ ________.
________ _______ ___ __________ ____ _______ ________ _____ _________ __________ ________.
______ ___ _____ ___ _________ ________ _______.
_____ _______ ________ _____ __________ __________ _____ ___ ______ __________ ___ ___.
_______ ________ ______ ________ _________ _______ _________.
_______ ________ _________ _________ __________ ___ ______ __________ ________ ____ ________.
____ _______ __________ _____ ______ ______ _________ _______ __________ __________.
_______ _________ ____ _________ _____ _______ ____.
__________ ____ ________ ___ _________ ______ _____.
__________ _____ ___ ______ ______ ___ ______ ___ ____ ____.
_______ ______ _______ __________ _________ _________ _________ ____ __________ _______ ___ _________.
______ ____ ___ ________ ____ __________ _______ _____.
_____ __________ ________ ________ ____ __________ ____ ____ ______.
__________ ___ _________ ___ ________ _______ ___ ______ _________.
__________ _____ ___ __________ _____ ___ ________ ________ ____ ______.
______ ________ _________ ________ ________ ____ ____ ________.
__________ __________ ________ ______ ____.
________ __________ ___ __________ ____ ________ ___ ___.
___ ____ __________ ____ __________ __________ ___ __________ _______ ____ ____.
___ ___ _______ _______ ___.
___ __________ _____ ___ __________.
____ ____ _________ ____ ____ __________ _______ ___ ___ __________.
_______ _______ _______ _________ ____ _________.
____ ______ ________ _______ ____.
_______ ______ __________ ___ ________.
____ __________ ________ ______ ________.
_______ ____ _______ _______ ____ _________ _________ ____ ________.
___ _____ ____ _________ _________ ______ _____ ____ _____ ______ ___ ________.
_____ ___ _______ ____ _________.
_________ _________ ________ _______ __________ _____ _________ _____.
__________ ______ ______ _____ _________ ____ ____ ________ ______ _________ ____ _______.
___ __________ ______ _________ __________ ______ _____.
____ _____ _________ ____ ______.
_______ __________ ________ ____ ______ _____ _______ _______ _________.
________ ____ ______ ___ ________ _________ ________.
____ _____ _________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.