Question
Relationships:
Each order is placed by one customer.
Each order can have multiple products.
Each product can be part of multiple orders.
Draw an ER-diagram for this application.
Answer :
Word Count : 224
______ _______ _________ ___ _________ _______ __________ ___ ________.
____ _______ ___ ______ __________ _____ ______ ____ ___.
_______ _________ ____ ________ ______ ________ _____ _______ ________.
________ _________ _______ _________ ___ _____ ___ __________ _____.
__________ _____ __________ __________ _____ _________ _______ _________ _________ _____ ______ _____.
______ ____ _____ ____ _____ _________ __________ _______.
___ _________ _________ _______ __________ _________ ___ _______ ____ _________ ____ ________.
_____ _______ _____ ______ ____.
________ ____ ___ ___ ____.
_________ _____ _____ _______ ______ __________ ______ _____ _________.
_______ ___ _____ _______ ______ _______ _______ ______ _____ _______ __________ ________.
_________ ________ __________ _______ ___ ___.
_______ _____ _______ ________ ________ _________ ________ __________ ____ ________ ____ __________.
___ ________ ___ ________ ____ _______ ____ ___ __________.
_________ _________ _______ ____ _________ __________.
_____ _____ ________ _____ ____ ____.
______ ___ _____ _____ ___ ________ ______ ____ __________ __________ _____ _____.
___.
Skip in 10
To represent the given relationships in an ER-diagram, the following entities and relationships are identified: Entities: 1. Customer * Attributes: Customer\_ID (Primary Key), Name, Email, Phone 2. Order * Attributes: Order\_ID (Primary Key), Order\_Date, Total\_Amount 3. Product * Attributes: Product\_ID (Primary Key), Product\_Name, Price Relationships: 1. Places (between Customer and Order) * Type: One-to-Many * A Customer can place many Orders. * Each Order is placed by
________ ______ _____ __________ _________ __________.______ _______ _________ ___ _________ _______ __________ ___ ________.
____ _______ ___ ______ __________ _____ ______ ____ ___.
_______ _________ ____ ________ ______ ________ _____ _______ ________.
________ _________ _______ _________ ___ _____ ___ __________ _____.
__________ _____ __________ __________ _____ _________ _______ _________ _________ _____ ______ _____.
______ ____ _____ ____ _____ _________ __________ _______.
___ _________ _________ _______ __________ _________ ___ _______ ____ _________ ____ ________.
_____ _______ _____ ______ ____.
________ ____ ___ ___ ____.
_________ _____ _____ _______ ______ __________ ______ _____ _________.
_______ ___ _____ _______ ______ _______ _______ ______ _____ _______ __________ ________.
_________ ________ __________ _______ ___ ___.
_______ _____ _______ ________ ________ _________ ________ __________ ____ ________ ____ __________.
___ ________ ___ ________ ____ _______ ____ ___ __________.
_________ _________ _______ ____ _________ __________.
_____ _____ ________ _____ ____ ____.
______ ___ _____ _____ ___ ________ ______ ____ __________ __________ _____ _____.
___.
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.