Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 violation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 22nd European Conference Adbis 2018 Budapest Hungary September 2 5 2018 Proceedings Lncs 11019

Authors: Andras Benczur ,Bernhard Thalheim ,Tomas Horvath

1st Edition

3319983970, 978-3319983974

More Books

Students also viewed these Databases questions

Question

Question What are the advantages of a written bonus plan?

Answered: 1 week ago