wants
Chapter8: Mastering Digital Media
Section: Chapter Questions
Problem 2AYK
Related questions
Question
A furniture shop wants to sell different types of furniture in online mode. The customers can view the furniture and place orders online,
The portal sells different type of furniture such as chairs, tables, sofa etc.
For each of the furniture, the portal maintains its unique code, furniture name, the furniture description (such as wooden, plastic), the year it was
manufactured and price.
Customers can place an order for the furniture of their interest. Information about customers such as their name, PAN number, address, phone number and
email are collected during ordering.
A customer can place more than one order. Each order may comprise of more than one furniture. The customers who place orders with order amount
exceeding Rs. 50000 are given a discount of 5% on the order price
In each order, the furniture code, quantity, furniture name, order amount and discount are recorded.
Draw the ER-diagram and make sure to indicate key attributes cardinality and participation constraints.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:
9780357392607
Author:
FREUND
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L