Create the Physical ERD using Microsoft Visio or other diagram drawing software You will design a database for this company so that they wont 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 physical 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 21613 10 21 2010 KL62 Dryer 4 $329 95 21614 10 21 2010 KT03 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 1 $495 00 21523 10 23 2010 KV29 Treadmill 2 $1290 00

The Answer is in the image, click to view ...

Question: Create the Physical ERD using Microsoft Visio or other diagram drawing software. You will design a database for this company so that they wont be

Create the Physical ERD using Microsoft Visio or other diagram drawing software.

You will design a database for this company so that they wont 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 physical 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
21613	10/21/2010	KL62	Dryer	4	$329.95
21614	10/21/2010	KT03	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	1	$495.00
21523	10/23/2010	KV29	Treadmill	2	$1290.00

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 Databases Questions!

I need help with this, I am lost! and all I can find is people doing Physical Level ERDs not logical. Huiviuudl Assignment ERD: Logical Entity Relationship Diagram Choose one of the below scenarios...

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...

Hello i need help with my assignment ASAP!!! Design a conceptual database model without redundancy for the above company. Draw the ERD using Crows foot diagram. A screenshot with the outcome would be...

I need help on all parts, But mainly Part 4 (Enter Data) and (Update and List Data) PART II. CONCEPTUAL DATABASE MODEL (50%) GeoTab Company has contacted you to create a database for their conference...

PART II. CONCEPTUAL DATABASE MODEL (30%) GeoTab Company has contacted you to make a database for their conference schedule and registration. A sample of a conference schedule is provided in the...

Part II. Conceptual Database Model (30%) GeoTab Company has contacted you to create a database for their conference schedule and registration. A sample of a conference schedule is provided in the...

Hello, i need help with my Assignment. I will upload a part where there has to be an ERD diagram included by using Crow foots notation. For the answer, a screenshot of the outcome would be very...

ABC inc. has contacted you to create a database for their conference schedule and registration. A sample of a conference schedule is provided in the appendix. Through interviews with the manager, you...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

can you please make the answer the how it order in last page exactly appreciate your help Part 1: (20 points) Use Microsoft Visio to create and ERD. Julia, a recent graduate of UToledo has launched...

Amazon story. Identify the business models Amazon used and at which level of e-business commitment each falls (Exhibit 2.3).

Some organizations set up a selection process that is long and complex. In some people's opinion, this kind of selection process not only is more valid but also has symbolic value. What can the use...

4. After seven years of negotiations, 12 countriesincluding the United States, Japan, Vietnam, and nine other Pacific Rim countriescrafted the Trans-Pacific Partnership (TPP). A key feature of the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

13-2 What are the core activities in the systems development process?

13-1 How does building new systems produce organizational change?

12-15 Describe three kinds of decisions that can be supported using Predix. What is the value to the firm of each of those decisions? Explain.