(LO 4-2, 4-3) Use the ER-diagram to answer the following questions:

a. Identify the primary key in each table.

b. Identify the foreign keys that build the relationship between the tables.

c. Relying on the primary key/foreign key relationships, how would you create a SQL query that would select all the data from both the Purchase_Orders table and the Suppliers table?

d. Relying on the primary key/foreign key relationships, how would you create a SQL query that would select all the data from both the Purchase_Orders table and the Raw_Materials table?

Transcribed Image Text:

Raw Materials Raw Materials Code Raw Materials Description Raw Materials Price Purchase Orders Purchase Order_ID Purchase Order Date Purchase Employee ID Supplier_ID Raw Materials Code Quantity Purchased Raw Material Purchase Price Suppliers Supplier_ID Supplier_Company_name Supplier Address Supplier City Supplier St Supplier Zip Supplier Phone Notes