Question: ASAP PLEASE!! Draw ERD for the following scenario ) : A retail company keeps tracks of Customer, Order, Line Item, Part, Supplier, Nation. For customers,
ASAP PLEASE!!
Draw ERD for the following scenario:
A retail company keeps tracks of Customer, Order, Line Item, Part, Supplier, Nation.
For customers, we keep track of name, id and market segment.
Customers make orders. The system stores order number, order total price and date of the order.
Each order can have multiple line items. for each line item, we store quantity, extended price, and return flag.
Each line item with in an order is identified by line no corresponds to a part, we store id for this part, its size, and its retail price. The Supplier supplies these parts. We store supplierid name, address and account balance for supplier.
Both suppliers and customers belong to a nation. We store nation name, capital and region.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
