Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 .
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started