Answered step by step
Verified Expert Solution
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.
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.0Step 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