Objectives

The purpose of this assignment is to create result tables with SQL SELECT statements. Most of the questions in this assignment require you join together the underlying tables in your database. Some of the questions require the use of a view or CTE - I recommend you use this assignment to try out your knowledge of those SQL constructs.

Condition manages PK ConditionID ConditionDescription is managed by -H Purchase Order PC is on has Employee Database PK EmpID 8 EmpLastName receives Receiver EmpFirstName EmpEmail PK ReceiverID -H- EmpPhone ProductType FK1 EmpMgrID DateReceived QtyReceived PK ProductTypelD FK2 ConditionID FK1 ReceiveEmpID Description FK5 POLinelD places - -H is is of is for received on Product PK ProductID PurchaseOrder PurchaseOrderLine ProductDescription PK PONumber PK POLinelD contains contains UOM H- EOQ PODatePlaced - H OFK1 PONumber PODateNeeded FK2 ProductID is on QOH Terms DateNeeded QOHDateUpdated QtyOrdered FK1 ProductTypelD Conditions FK1 BuyerEmpID Price FK2 VendorID was purchased is placed with was PurchaseHistory purchased Vendor from PK HistoryID PK VendorID - H- 04 FK1 productID DatePurchased VendorName Qty VendorAddress Price VendorAddress2 QtyReceivedOn Time VendorCity FK2 VendorID VendorState VendorZip VendorEmail Is reviewed VendorReview VendorContact . H- OPK ReviewID VendorPhone Is reviewed FirstBuyDate ReviewDate Review Title ReviewRating ReviewComments FK1 ProductID FK2 VendorIDCondition manages PK ConditionID ConditionDescription is managed by -H Purchase Order PC is on has Employee Database PK EmpID 8 EmpLastName receives Receiver EmpFirstName EmpEmail PK ReceiverID -H- EmpPhone ProductType FK1 EmpMgrID DateReceived QtyReceived PK ProductTypelD FK2 ConditionID FK1 ReceiveEmpID Description FK5 POLinelD places - -H is is of is for received on Product PK ProductID PurchaseOrder PurchaseOrderLine ProductDescription PK PONumber PK POLinelD contains contains UOM H- EOQ PODatePlaced - H OFK1 PONumber PODateNeeded FK2 ProductID is on QOH Terms DateNeeded QOHDateUpdated QtyOrdered FK1 ProductTypelD Conditions FK1 BuyerEmpID Price FK2 VendorID was purchased is placed with was PurchaseHistory purchased Vendor from PK HistoryID PK VendorID - H- 04 FK1 productID DatePurchased VendorName Qty VendorAddress Price VendorAddress2 QtyReceivedOn Time VendorCity FK2 VendorID VendorState VendorZip VendorEmail Is reviewed VendorReview VendorContact . H- OPK ReviewID VendorPhone Is reviewed FirstBuyDate ReviewDate Review Title ReviewRating ReviewComments FK1 ProductID FK2 VendorID