Question: a) Write down all primary key name and its table name. b) Then, write down all foreign key names and its table name. PART LINE_ITEM

a) Write down all primary key name and its table name.
b) Then, write down all foreign key names and its table name.
PART LINE_ITEM Part_Number Part_Name Unit_Price Supplier_Number Order_Number Part_Number Part_Quantity 137 Door latch 22.00 8259 3502 137 10 145 Side mirror 12.00 8444 3502 152 20 150 Door molding 6.00 8263 3502 178 5 152 Door lock 31.00 8259 ORDER 155 Compressor 54.00 8281 178 Door handle Order_Number Order_Date 10.00 8259 3502 1/15/2018 3503 1/16/2018 3504 1/17/2018 SUPPLIER Supplier_Number Supplier_Name Supplier_Street Supplier_City Supplier_State Supplier_Zip 8259 CBM Inc. 74 5th Avenue Dayton OH 45220 8261 B. R. Molds 1277 Gandolly Street Cleveland 49345 8263 Jackson Components 8233 Micklin Street Lexington KY 56723 8444 Bryant Corporation 4315 Mill Drive Rochester 11344 OH NYStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
