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 order for the furniture of their interest.
- 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 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 constraint
Step by step
Solved in 2 steps with 1 images