K. Provide an inventory report that lists the most costly items first. The inventory report should include product identification numbers, product descriptions, unit prices, supplier names, cost, and quantity supplied. Hint: the most costly item is the one in which the product of cost and quantity yields the largest value. Be careful not to confuse cost with price. Price is the value that the products are sold to the customers, and cost is the value that is paid to purchase the products from the suppliers. Also, be aware that the word "product" above refers to the result of multiplication (i.e., the product of cost and quantity) L. List all of the employees in alphabetical order and each course they have completed in order of date completed. Hint: some employees might not have taken any courses. Database Diagrams Tables System Tables FileTables External Tables Graph Tables dbo.COURSE_T Columns mo CourselD (PK, int, not null) CourseDescription (varchar(450), null) Keys Constraints Triggers Indexes Statistics dbo.CUSTOMER_T Columns no CustomerlD ( PK, int, not null) CustomerName (varchar(100), null) G CustomerStreet (varchar(59), null) CustomerCity (varchar(50), null) CustomerState (varchar(50), null) CustomerZip (varchar(50), null) CreditLimit (money, null) EmployeelD ( FK, int, null) Keys Constraints Triggers Indexes Statistics dbo.EMPLOYEE_COURSE_T Columns G CompletionDate (date, null) o EmployeelD (PK, FK, int, not null) o CourselD ( PK,FK, int, not null) Keys Constraints Triggers Indexes Statistics dbo.EMPLOYEE_T Columns o EmployeelD (PK, int, not null) MangerlD (FK, int, null) EmployeeFirstName (varchar(100), null) EmployeelastName (varchar(100), null) EmployeelobTitle (varchar(100), null) EmployeeStreet (varchar(100), null) EmployeeCity (varchar(100), null) EmployeeState (char(2), null) EmployeeZip (varchar(20), null) EmployeeHireDate (date, null) Keys Constraints Triggers Indexes Statistics dbo.FABRICATED_T Columns G PartQTY (float, null) mo ProductID (PK, FK, int, not null) mo PartID (PK, FK, int, not null) Columns OrderQTY (int, null) mo OrderlD (PK, FK, int, not null) mo ProductID (PK, FK, int, not null) Keys Constraints Triggers Indexes Statistics dbo.ORDER_T Columns mo OrderlD (PK, int, not null) CustomerPONumber (int, null) OrderDate (date, null) G DueDate (date, null) ShipDate (date, null) CustomerlD (FK, int, not null) Keys Constraints Triggers Indexes Statistics dbo.PRODUCT_ID Columns ProdDesc (varchar(455), null) UnitPrice (money, null) StockQTY (int, null) mo ProductID (PK, int, not null) Keys Constraints Triggers Indexes Statistics dbo.PRODUCT_SUPPLIER_T Columns VendorPartID (varchar(455), null) ProductCost (money, null) PurchasedQuanlity (decimal (18,0), null) mo SupplierID (PK, FK, int, not null) mo ProductID (PK, FK, int, not null) Keys Constraints Triggers Indexes Statistics dbo.SALES_REPRESENTATIVE_T Columns CommissionRate (real, null) o EmployeelD (PK, FK, int, not null) Keys Constraints Triggers Indexes Statistics dbo.SUPPLIER_T Columns SupplierName (varchar(50), null) SupplierStreet (varchar(50), null) SupplierCity (varchar(50), null) SupplierState (varchar(50), null) SupplierZip (varchar(100), null) \%o SupplierID (PK, int, not null)
