Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ERD (entity relationship diagram) for the following 5 tables. Existing Data Set Order ORDNUM ORDDATE CUSTNUM 12489 03/14/02 124 12490 03/14/02 311 1249103/16/02

Create an ERD (entity relationship diagram) for the following 5 tables.image text in transcribed

Existing Data Set Order ORDNUM ORDDATE CUSTNUM 12489 03/14/02 124 12490 03/14/02 311 1249103/16/02 412 12492 03/16/02 256 12493 03/17/02 522 12494 03/20/02 124 12495 03/20/02 522 104 Part PARTNUM PARTDESC QONHAND AX12 IRON AZ52 SKATES BA74 BASEBALL BH22 TOASTER BT04 STOVE BZ66 WASHER CA 14 SKILLET CB03 BIKE 44 CX11 MIXER CZ81 WEIGHTS 208 REORDQ CLASS WRHSNUM LISTPRCE 80 HW 17.95 10 SG 24.95 20 SG 4.95 50 HW 34.95 10 AP 402.99 40 AP 311.95 2 HW 19.95 40 SG 187.50 50 HW 3 57.95 50 SG 108.99 N 112 Customer CUSTNUM CUSTNAME CUSTADDR BEGBAL CREDLIM SLSRNUM 124 ADAMS, SALLY 481 OAK, LANSING, MI 418.75 500 256 SAMUELS, ANN 215 PETE, GRANT, MI 1 0.75 800 311 DANIELS, TOM 914 CHERRY,KENT, MI 320.75 300 366 ADAMS, SALLY 16 ELM, LANSING, MI 9 08.75 1000 405 WILLIAMS, AL 519 WATSON, GRANT, MI 201.75 800 412 ROBERTS, JUDY 481 OAK LANSING, MI 215.25 500 522 NELSON, MARY 108 PINE, ADA, MI 49.50 800 BAKER, JOE 808 RIDGE, HARPER, MI 201.20 300 622 MARTIN, DAN 419 CHIP, GRANT, MI 5 75.50 500 WOWOW 567 PartOrd ORDNUM PARTNUM QUANTITY 12489 AX12 12490 BT04 12490 BZ66 12491 CB03 12492 CX11 12493 AZ52 12493 BA74 12493 CB03 12494 BT04 12495 C2812 NANANNA QUOTPRCE 14.95 402.99 311.95 175.00 22.95 22.95 4.95 175.00 402.99 108.99 Sales Rep SLSRNUM SLSRNAME SLSRADDR TOTCOMM COMMRATE JONES, MARY 123 MAIN, GRANT, MI 2150 0.05 SMITH, WILLIAM 102 RAYMOND, ADA, MI 4912.5 0.05 12 BROWN, SAM 419 HARPER, LANSING, MI 2150 0.07 0.0 Existing Data Set Order ORDNUM ORDDATE CUSTNUM 12489 03/14/02 124 12490 03/14/02 311 1249103/16/02 412 12492 03/16/02 256 12493 03/17/02 522 12494 03/20/02 124 12495 03/20/02 522 104 Part PARTNUM PARTDESC QONHAND AX12 IRON AZ52 SKATES BA74 BASEBALL BH22 TOASTER BT04 STOVE BZ66 WASHER CA 14 SKILLET CB03 BIKE 44 CX11 MIXER CZ81 WEIGHTS 208 REORDQ CLASS WRHSNUM LISTPRCE 80 HW 17.95 10 SG 24.95 20 SG 4.95 50 HW 34.95 10 AP 402.99 40 AP 311.95 2 HW 19.95 40 SG 187.50 50 HW 3 57.95 50 SG 108.99 N 112 Customer CUSTNUM CUSTNAME CUSTADDR BEGBAL CREDLIM SLSRNUM 124 ADAMS, SALLY 481 OAK, LANSING, MI 418.75 500 256 SAMUELS, ANN 215 PETE, GRANT, MI 1 0.75 800 311 DANIELS, TOM 914 CHERRY,KENT, MI 320.75 300 366 ADAMS, SALLY 16 ELM, LANSING, MI 9 08.75 1000 405 WILLIAMS, AL 519 WATSON, GRANT, MI 201.75 800 412 ROBERTS, JUDY 481 OAK LANSING, MI 215.25 500 522 NELSON, MARY 108 PINE, ADA, MI 49.50 800 BAKER, JOE 808 RIDGE, HARPER, MI 201.20 300 622 MARTIN, DAN 419 CHIP, GRANT, MI 5 75.50 500 WOWOW 567 PartOrd ORDNUM PARTNUM QUANTITY 12489 AX12 12490 BT04 12490 BZ66 12491 CB03 12492 CX11 12493 AZ52 12493 BA74 12493 CB03 12494 BT04 12495 C2812 NANANNA QUOTPRCE 14.95 402.99 311.95 175.00 22.95 22.95 4.95 175.00 402.99 108.99 Sales Rep SLSRNUM SLSRNAME SLSRADDR TOTCOMM COMMRATE JONES, MARY 123 MAIN, GRANT, MI 2150 0.05 SMITH, WILLIAM 102 RAYMOND, ADA, MI 4912.5 0.05 12 BROWN, SAM 419 HARPER, LANSING, MI 2150 0.07 0.0

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

Step: 3

blur-text-image

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

Beginning C# 2005 Databases

Authors: Karli Watson

1st Edition

0470044063, 978-0470044063

More Books

Students also viewed these Databases questions

Question

7. List behaviors to improve effective leadership in meetings

Answered: 1 week ago

Question

6. Explain the six-step group decision process

Answered: 1 week ago