Choose below scenarios and Create the physical level ERD.

Scenario :

This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts {in other words, not a database but a flat one table file). You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, identify the separate entities an attributes and design a physical level Entity Relationship Diagram for this company.

OrderNum 21608 21610 21610 21613 21614 21617 21617 21619 21523 PartNum Description AT94 DR93 OrderDate 10/20/2010 10/20/2010 10/20/2010 DW11 10/21/2010 KL62 10/21/2010 KT03 10/23/2010 BV06 10/23/2010 CD52 10/23/2010 10/23/2010 DR93 KV29 Iron Gas Range Washer Dryer Dishwasher Home Gym Microwave Oven Gas Range Treadmill NumOrdered 11 1 1 4 2 2 4 1 2 QuotedPrice $21.95 $495.00 $399.99 $329.95 $595.00 $794.95 $150.00 $495.00 $1290.00