Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer all three questions as soon as possible!!!!!! PROD_ID 1 P_QOH 8 1 PMIN 5 15 12 2 32 V CODE 101 104 101
please answer all three questions as soon as possible!!!!!!
PROD_ID 1 P_QOH 8 1 PMIN 5 15 12 2 32 V CODE 101 104 101 101 3 18 3 15 8 4 23 5 P_CODE 11QER/31 13-Q2/P2 14-Q1/L3 1546-QQ2 1558-QW1 2232/QTY 2232/QWE 2238/QPD 23109-HB 23114-AA 54778-2T 89-WRE-Q PVC23DRT PRODUCTS - P_DESCRIPT Power painter, 15 psi., 3-nozzle 7.25-in. pwr. saw blade 9.00-in. pwr. saw blade Hrd. cloth, 1/4-in., 2x50 Hrd. cloth, 1/2-in., 3x50 B&D jigsaw, 12-in. blade B&D jigsaw, 8-in. blade B&D cordless drill, 1/2-in. Claw hammer Sledge hammer, 12 lb. Rat-tail file, 1/8-in. fine Hicut chain saw, 16 in. PVC pipe, 3.5-in., 8-ft 5 8 5 107 6 6 5 6 12 5 111 140 101 106 7 23 10 8 8 5 43 9 138 20 5 11 10 188 75 V_CODE 101 V_ORDER Y N 102 103 104 105 Y V_NAME Bryson, Inc. Superloo, Inc. D&E Supply Gomez Bros. Dome Supply Randsets Ltd. Brackman Bros. ORDVA, Inc. B&K, Inc. Damal Supplies Rubicon Systems V_AREACODE 615 904 615 615 901 901 N VENDOR V_CONTACT Smithson Flushing Singh Ortega Smith Anderson Browning Hakford Smith Smythe Orton 106 V PHONE 223-3234 215-8995 228-3245 889-2546 678-1419 678-3998 228-1410 898-1234 227-0093 890-3529 456-0092 N Y N 615 Y 107 108 109 110 111 615 904 N 615 N Y 904 1. Identify the Primary keys in both tables. If no Primary key is found then find ways to create a Primary Key in that table. (5) 2. Identify the Foreign Key in both tables (5) 2. Identify if there are referential integrity violations in any of the two tables. If yes, Explain why is it a violationStep 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