7) Need help with 3 tables, Identify the Primary Keys, Composite primary keys, and Foreign Keys.

Production.Product

Production.ScrapReason

Production.WorkOrder Notice when I look at the WorkOrderID, there is only one product for each WorkOrder. So WorkOrderID is enough to uniquely identify a row in the table, so its the primary key.

Part 2: Need help 3 Tables, identify the Primary Keys, Composite primary keys and Foreign Keys.

Production.Product

Sales.SpecialOfferProduct

Sales.SpecialOffer

What is the name of the linking table from question # 7?

Part 3 - Need help 2 tables, identify the Primary Keys, Composite primary keys, and Foreign Keys.

Recipes.Recipes

Recipes.Recipe_Classes

Part 4 - Need help 3 tables, identify the Primary Keys, Composite primary keys, and Foreign Keys.

School.Class_Rooms

School.Classes

School.Subjects

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 ScrapReasonid 1 2 4 5 6 3 7 8 9 Name Brake assembly not as ordered Color incorrect Drill pattern incorrect Drill size too large Drill size too small Gouge in metal Handling damage Paint process failed Primer process failed Seat assembly not as ordered Stress test failed Thermoform temperature too high Thermoform temperature too low Trim length too long Trim length too short Wheel misaligned 10 11 12 13 14 15 16 WorkOrderlD 1 2 3 4 productid 722 725 726 729 730 5 startdate enddate 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 2005-07-04 00:00:00.000 2005-07-14 00:00:00.000 8 9 732 733 738 741 742 10 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 SpecialOfferID 1 1 1 ProductID 680 706 707 707 1 N 3 8 707 707 707 11 1 1 708 708 708 SpecialOfferID 1 DiscountPct 0.00 0.02 2 3 0.05 4 0.10 5 Description No Discount Volume Discount 11 to 14 Volume Discount 15 to 24 Volume Discount 25 to 40 Volume Discount 41 to 60 Volume Discount over 60 Mountain-100 Clearance Sale Sport Helmet Discount-2002 Road-650 Overstock Mountain Tire Sale StartDate 2005-06-01 00:00:00.000 2005-07-01 00:00:00.000 2005-07-01 00:00:00.000 2005-07-01 00:00:00.000 2005-07-01 00:00:00.000 2005-07-01 00:00:00.000 2006-05-15 00:00:00.000 2006-07-01 00:00:00.000 2006-07-01 00:00:00.000 2007-06-15 00:00:00.000 0.15 0.20 0.35 EndDate 2008-12-31 00:00:00.000 2008-06-30 00:00:00.000 2008-06-30 00:00:00.000 2008-06-30 00:00:00.000 2008-06-30 00:00:00.000 2008-06-30 00:00:00.000 2006-06-30 00:00:00.000 2006-07-31 00:00:00.000 2006-08-31 00:00:00.000 2007-08-30 00:00:00.000 6 7 8 0.10 9 0.30 0.50 10 Recipe ClassID 1 w N 5 5 2 Recipeld RecipeTitle 1 Irish Stew 2 Salsa Buena Machos Nachos 4 Garlic Green Beans 5 Fettuccini Alfredo 6 Pollo Picoso 7 Mike's Summer Salad 8 Trifle 9 Roast Beef 10 Yorkshire Pudding 1 Preparation Cut the beef into 1" chunks Braise the meat Add... Coarsely dice the jalapenos. Mix all ingredients ... Slice the jalapenos crosswise (in circles) and set ... Snap off and discard the ends of the beans, then... Fill a large pot two thirds full with water. Add one t... Wash chicken pieces thoroughly in cold water. P... Rinse lettuce and cut into bite size pieces. You c... Prepare the Jello and custard per package directi... Place the beef on a roasting rack in a roasting pa... Place the eggs and water in a blender. While run... 1 4 6 1 3 RecipeClass D RecipeClassDescription 1 Main course 2 Vegetable 3 Starch 4 Salad 5 Hors d'oeuvres 6 Dessert 7 Soup classroomid 1131 1142 Capacity 30 PhoneAvailable 1 0 1 60 20 1231 1 1514 1515 20 25 40 1 1519 0 15 25 1 1 1 1525 1530 1532 1619 0 50 40 0 classid credits subjectid classroomid 1000 5 11 1231 1002 4 12 1619 1004 4 4 13 1627 1 4 13 1627 1012 4 14 1627 1020 4 15 3404 1030 5 1 1231 1031 5 1 1231 1156 5 37 3443 1162 5 37 3443 3 SubjectID SubjectName SubjectDescription 1 Financial Accounting Fundamentals I Introduces basic accounting concepts, principles a... 2 Financial Accounting Fundamentals I Applications of basic accounting concepts, princip... Fundamentals of Managerial Accounting Analysis of accounting data as part of the manageri... Intermediate Accounting In-depth review of financial accounting principles. ... Business Tax Accounting Basic principles, practices and governmental regula... 6 Introduction to Business Survey of businss practices. Covers business termi... 7 Developing A Feasibility Plan With the aid of a counselor, a feasibility plan will be ... Introduction to Entrepreneurship Overview of the entrepreneurial process, examinati... Information Technology Uses Word for Windows word processing skills, do... 10 Information Technology II Uses intermediate Word features including formattin... 9