Identify all of the primary keys and foreign keys for each table.

Create the appropriate relationships between the tables in Access.

This should be based on your analysis the analysis you completed for question 2. Enter the data that currently resides in the data set. Write a query that displays the name and address for each customer's sales representative. This should combine the SLSREP and the CUSTOMER tables, and reports CUSTNUM, CUSTNAME, SLSRNAME and SLSRADDR information. Construct another query, which reports the same information as in number 5, but now only for sales representative 3. Construct a query that shows exactly what each customer has ordered. The information should include customer number, name, description of each item, quantity and quote price of each item and the total price (which is the quantity times the quote_price). Create a form that allows for easy creation of new customers.

Insert Format Tools Table Window Help Project 1 - Saved to my Mac View an Layout References Mailings Review 5 - A Aav Erin x x AD AE E 2 T Qv Ev AalbCcDE AaBbCcDdEt AaBbCcDc AaBb CcDdEt Aal No Spacing Heading 1 Heading 2 Title Normal Existing Data Set 311 Order ORDNUM ORDDATE CUSTNUM 12489 03/14/02 124 12490 03/14/02 12491 03/16/02 412 12492 03/16/02 256 12493 03/17/02 522 12494 03/20/02 124 12495 03/20/02 522 Part PARTNUM PARTDESC QONHAND AX12 IRON AZ52 SKATES BA74 BASEBALL BH22 TOASTER BT04 STOVE B2B8 WASHER CA14 SKILLET CB03 BIKE CX11 MER CZB1 WEIGHTS 208 REORDQ 80 HW 10 SG 20 SG 50 HW 10 AP 40 AP 2 HW 40 SG 50 HW 50 SG CLASS WRHSNUM LISTPRCE 17.95 2 24.95 4.95 3 34.95 2 402.99 311.95 19.95 187.50 57.95 2 108.99 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 10.75 800 311 DANIELS, TOM 914 CHERRY.KENT, MI 3 20.75 300 366 ADAMS, SALLY 16 ELM, LANSING, MI 908.75 1000 405 WILLIAMS, AL519 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 567 BAKER, JOE 808 RIDGE, HARPER, MI 201.20 300 622 MARTIN,DAN 419 CHIP, GRANT, MI 575.50 www 500 English (United States) Focus 3 MacBook Pro BIU A E EDO ab X, X A P A A = = = = = AaBbCeDdEt Aa Bb CcDdEt Normal No Spacing 522 567 622 NELSON, MARY 108 PINE, ADA, MI BAKER, JOE 808 RIDGE, HARPER, MI MARTIN,DAN 419 CHIP, GRANT, MI 49.50 201.20 800 300 575.50 500 PartOrd ORDNUM PARTNUM QUANTITY QUOTPRCE 12489 AX12 14.95 12490 BT04 12490 402.99 B266 12491 311.95 CB03 12492 CX11 12493 AZ52 12493 22.95 BA74 12493 4.95 CB03 12494 BT04 175.00 12495 402.99 175.00 22.95 CZB1 108.99 Sales Rep SLSRNUM SLSRNAME SLSRADDR TOTCOMM COMPRATE JONES, MARY 123 MAIN, GRANT, MI 6 SMITH, WILLIAM 102 RAYMOND, ADA, MI 4912.5 0.05 12 BROWN, SAM 419 HARPER, LANSING, MI 2150 2150 0.05 0.07 is English (United States) Ilms 23 JIO O 0. 12 tv MacBook Pro B