Scenario of web shop application: A supplier (with Supp-#) processes many purchase orders (with PO-#) and sells a number

[answerhappygod]

Scenario Of Web Shop Application A Supplier With Supp Processes Many Purchase Orders With Po And Sells A Number 1 (16.09 KiB) Viewed 11 times

Scenario of web shop application: A supplier (with Supp-#) processes many purchase orders (with PO-#) and sells a number of products (with Prod-#). A product is sold by only one supplier. Each of the purchase orders that a supplier may process includes several products. The relationship between order and product is defined as "Line Item". A customer (with Cust-#) may place one or more purchase orders. A purchase order may be placed by only one customer. Design a complete ER diagram for the above verbal description of web shop application.