Answered step by step
Verified Expert Solution
Link Copied!

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 . image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Evaluation Of An Internal Audit Department The Case Of SOTELMA

Authors: Oumar Bah

1st Edition

6204486039, 978-6204486031

More Books

Students also viewed these Accounting questions

Question

Develop successful mentoring programs. page 400

Answered: 1 week ago