Consider the files included in this homework folder.

Customer

Order

Purchase Order Details

Products

Your job:

Use the DBMS of your choice:

$1.$ Load these files into tables that you create for them specifying all primary and foreign keys.

$2.$ Using Customer and Order tables: Write SQL queries to do the following:

a$.$ Retrieve the Last Name of the Customer and the OrderID and StatusID of all orders in the Order relation. Print out the Last Name only of Customers that have placed at least one order.

i$.$ Do this with INNER JOIN

ii$.$ Do this with NATURAL JOIN

b$.$ Retrieve the Last Name of the Customer and OrderID an StatusID for all orders in the Order relation AND the Last Name of Customers that have not placed any orders.

$3.$ Using Purchase Order Details and Products tables: Write SQL queries to do the following:

a$.$ Retrieve from the

i$.$ Purchase Order Details table: ProductID, Unit Cost and ProductName

ii$.$ Products table: Product Code, Product Name

Only for all products that are in the Purchase Order Details table.

$4.$ Using Purchase Order Details and Products tables: Write SQL queries to do the following:

a$.$ Retrieve from the

i$.$ Products table: Product Code, Product Name

Only for all products that are NOT in the Purchase Order Details table.

Grading Rubric:

$1.$ To receive full credit for your responses, ensure that the syntax of each query is correct. Include all required parentheses and other delimiters, where required.

$2.$ Remember, this homework helps you assess your understanding of SQL$.$ Make sure that your responses are written using SQL$.$