Part 1: Need help, 3 Tables, Identify the Primary Keys, and Composite Primary Keys.

Production.Product

Production.ProductInventory

Production.Location

For the tables in question #1, what is the name of the linking table?

Part 2: Need help, 2 tables, identify the Primary Keys, Composite Primary Keys, and Foreign Keys.

Sales.SalesPerson

Sales.SalesTerritory

For the two tables, identify the Primary Keys, Composite primary keys, and Foreign Keys. This is an example of a one-to-one relationship since the business rule states you have one password to get in all systems.

Person.Person

Person.Password

Part 3 - Need help 3 Tables, identify the Primary Keys, Composite Primary Keys, and Foreign Keys.

Sales.SalesPerson

Sales.CreditCard

Sales.PesonCreditCard

productid 1 2 3 safetystocklevel 1000 1000 800 800 3 4 316 name Adjustable Race Bearing Ball BB Ball Bearing Headset Ball Bearings Blade LL Crankarm ML Crankarm HL Crankarm Chainring Bolts Chainring Nut makeflag color reorderpoint 0 NULL 750 0 NULL 750 1 NULL 600 0 NULL 600 1 NULL 600 0 Black 375 0 Black 375 0 Black 375 0 Silver 750 0 Silver 750 800 500 317 318 319 320 321 500 500 1000 1000 1 1 1 productid locationid quantity 1 1 408 1 6 324 1 50 353 1 427 6 318 2 50 364 3 585 3 6 443 3 3 324 4 1 512 1 50 1 locationid name 1 Tool Crib Sheet Metal Racks 3 Paint Shop 4 Paint Storage 5 Metal Storage 6 Miscellaneous Storage Finished Goods Storage 10 Frame Forming BusinessEntityID 275 279 284 TerritoryID 2 5 1 9 286 SalesQuota 300000.00 300000.00 300000.00 250000.00 250000.00 250000.00 250000.00 250000.00 250000.00 250000.00 288 289 290 SalesYTD CommissionPct 3763178.1787 0.012 2315185.611 0.01 1576562.1966 0.019 1421810.9242 0.018 1827066.7118 0.018 4116871.2277 0.02 3121616.3202 0.016 1352577.1325 0.01 2458535.6169 0.01 2604540.7172 0.015 0 00 8 10 7 1 280 4 281 282 6 6 territoryid 1 US 4 5 name countryregioncode Northwest US Northeast US Central Southwest US Southeast US Canada CA France FR Germany DE Australia AU United Kingdom GB 6 7 8 9 9 10 BusinessEntityID 1 3 4 5 6 PersonType FirstName MiddleName EM Ken J EM Terri Lee EM Roberto NULL EM Rob NULL EM Gail A EM Jossef EM Dylan A EM Diane L EM Gigi EM Michael NULL LastName Snchez Duffy Tamburello Walters Erickson Goldberg Miller Margheim Matthew Raheem 7 I Z 8 9 10 BusinessEntityID 1 2 3 4 5 passwordhash pbFwXWE 99vobT6g+vPWFy93NTUU/orrlWafF01hccfM= bawRVNIZQYQ059F05G zbVLilnvZmrqBRET TAGAudm0= 8BUXIZIDO1lyHCWOY2YmN1IhTUn3CJMpdx/UCQ3Y= SiLXpiarHS1z+64G+H+4QpB/IPRzras/+9q/5W17tf8= 8FYdAlY6gWuBsgiCFdgoUibtsqOcwHfSTyaHIP7+pa4= u5kbN5n84NRE 1h/a+ktdR1XucigrmfF6wZC4982rjHM= zSzerin8T8eq3nYHC4Lx4vMuxZaxkDylwwnP2ZT604= S+FUWADIZZXBKpcbxe40wL2uilmiLOGJNYXXHvc1X/k= fCVCTy3RwzA2LNhHhYUbT7erkb9Au5wyM2q7ReHrOVO= /8biMrxustETGeluloSrMQHBraZZ+eU2z50J1Fhn6M= Password alt bE3XiWw= EjaC3U- WbPZqMw= PwSunQUE YhZRIM- a9GILUAN 13mu8BA- FICpzTU- FTCZMVQ= K7dMPTY= ModifiedDate 2003-02-08 00:00:00.000 2002-02-24 00:00:00.000 2001-12-05 00:00:00.000 2001-12-29 00:00:00.000 2002-01-30 00:00:00.000 2002-02-17 00:00:00.000 2003-03-05 00:00:00.000 2003-01-23 00:00:00.000 2003-02-10 00:00:00.000 2003-05-28 00:00:00.000 6 7 8 9 10 BusinessEntityID 275 279 284 TerritoryID 2 5 1 9 286 SalesQuota 300000.00 300000.00 300000.00 250000.00 250000.00 250000.00 250000.00 250000.00 250000.00 250000.00 288 289 290 SalesYTD CommissionPct 3763178.1787 0.012 2315185.611 0.01 1576562.1966 0.019 1421810.9242 0.018 1827066.7118 0.018 4116871.2277 0.02 3121616.3202 0.016 1352577.1325 0.01 2458535.6169 0.01 2604540.7172 0.015 0 00 8 10 7 1 280 4 281 282 6 6 CreditCardid 1 2 3 3 4 5 CardType CardNumber ExpMonth ExpYear SuperiorCard 33332664695310 11 2006 Distinguish 55552127249722 8 2005 ColonialVoice 77778344838353 7 2005 ColonialVoice 77774915718248 7 2006 Vista 11114404600042 4 2005 Distinguish 55557132036181 9 2006 Distinguish 55553635401028 6 2007 SuperiorCard 33336081193101 7 2007 Distinguish 55553465625901 2 2005 SuperiorCard 33332126386493 8 2008 6 7 8 9 10 BusinessEntityID 293 CreditCarded 17038 15369 8010 295 297 299 301 303 305 307 309 5316 6653 9010 8937 16124 9478 311 17600