Question

Given the tables PRODUCT (ProductID. Description. Cost) SUPPLIER (Supplier D. ContactName, Phone Number) as shown in the figure below, which of the following would represent the correct placement of foreign keys? PRODUCT SUPPLIER ProductD Supplier Description Contact Name Cost Phone Number PRODUCT (ProductiD. Description. Cost) SUPPLIER (Supplier D. ContactName PhoneNumber, Productio) PRODUCT (ProductID. Description, Cost ContactName) SUPPLIER (Supplier D. ContactName, PhoneNumber) PRODUCT (ProductID. Description. Cost) SUPPLIER (Supplier D. ContactName, PhoneNumber) PRODUCT (Product Description, CostSupplier) SUPPLIER (Supplieri. ContactName, Phone Number, ProductID) PRODUCT (ProductID. Description Cost Supplieri) SUPPLIER (Supplierib. ContactName, PhoneNumber)

Answer 1

CREATE PROCEDURE sp_Q1

"at"country1 NVARCHAR(15),

"at"country2 NVARCHAR(15)

SELECT SupplierID, CompanyName, Phone, Country FROM suppliers where Country in ("at"country1,"at"country2)

 SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Product

     where SupplierID in(

 SELECT SupplierID FROM suppliers

where Country in ("at"country1,"at"country2)) ORDER BY SupplierID

What is product supplier?

PRODUCT SUPPLIER ProductD Supplier Description Contact Name Cost Phone Number PRODUCT (ProductiD. Description. Cost) SUPPLIER (Supplier D. ContactName PhoneNumber, Productio) PRODUCT (ProductID. Description, Cost ContactName) SUPPLIER (Supplier D. ContactName, PhoneNumber)

PRODUCT (ProductID. Description. Cost) SUPPLIER (Supplier D. ContactName, PhoneNumber) PRODUCT (Product Description, CostSupplier) SUPPLIER (Supplieri. ContactName, Phone Number, ProductID) PRODUCT (ProductID. Description Cost Supplieri) SUPPLIER (Supplierib. ContactName, PhoneNumber)

Therefore,  SELECT ProductID, ProductName, UnitPrice, SupplierID FROM Product

     where SupplierID in(

 SELECT SupplierID FROM suppliers

where Country in ("at"country1,"at"country2)) ORDER BY SupplierID

Learn more about SupplierID on:

brainly.com/question/15698840

#SPJ1