Question: I would like an ERD , done prefersbly using a drawing tool eg draw.io or Visio, what was fonr previously does not cut it .

I would like an ERD , done prefersbly using a drawing tool eg draw.io or Visio, what was fonr previously does not cut it . I would like an ERD , done prefersbly using a drawing tool
Sorry meant the snswer i hit before does not meet the requirements if the ERD

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. Order Num 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 $399.99 21613 10/21/2010 KL62 Dryer $329.95 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 $150.00 21619 10/23/2010 DR93 Gas Range $495.00 21523 10/23/2010 KV29 Treadmill $1290.00 1 4 4 1 N 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. Order Num 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 $399.99 21613 10/21/2010 KL62 Dryer $329.95 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 $150.00 21619 10/23/2010 DR93 Gas Range $495.00 21523 10/23/2010 KV29 Treadmill $1290.00 1 4 4 1 N

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!