Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started