Database management

Individual Assignment ERD: Logical Entity Relationship Diagram Choose one of the below scenarios and Create the logical level ERD. You must create the ERD using Microsoft Visio or other diagram drawing software as indicated by your professor. Make sure to submit a PDF version of your diagram along with the actual diagram file (in case your professor can't open your Visio file, they can use the PDF file to grade). Make sure to submit the diagram by the due date as specified by your professor. Scenario 1: 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 and attributes and design a logical level Entity Relationship Diagram for this company. OrderNum OrderDate PartNum Description NumOrdered QuotedPrice 21608 10/20/2010 AT94 Iron 11 $21.95 21610 10/20/2010 DR93 Gas Range 1 $495.00 21610 10/20/2010 DW11 Washer 1 $399.99 2161 10/21/2010 KL62 Dryer 4 $329.95 tel:21610%2021613 21614 10/21/2010 KTO3 Dishwasher 2 $595.00 21617 10/23/2010 BV06 Home Gym 2 $794.95 21617 10/23/2010 CD52 Microwave Oven 4 $150.00 21619 10/23/2010 DR93 Gas Range $495.00 21523 10/23/2010 KV29 Treadmill 2 $1290.00 OR