PLEASE REFER TO THE SCREENSHOT OF THE OUTPUT BELOW EACH QUESTION AND THE CODE TO ENSURE THAT THE GIVEN ANSWER MATCHES THE OUTPUT AND USES THE CORRECT TABLES

 

SQL CODE(to long to post in text):

https://pastes.io/fzz3qzhvan

or

https://gist.github.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4

   

Transcribed Image Text:

LGCUSTOMER PK Cust Code Cust Fname Cust Lname Cust Street Cust City Cust_State Cust ZIP Cust Balance places LGINVOICE LGLINE PK,FK1 Inv Num PK Inv Num PK Line Num appears on contains FK1 Cust_Code FK2 Prod SKU Line Qty Inv_Date Inv_Total FK2 Employee ID completes LGEMPLOYEE PK Emp Num Emp Fname Emp Lname Emp_Email Emp Phone Emp Hiredate Emp_Title Emp_Comm FK1 Dept Num employs manlages LGDEPARTMENT PK Dept Num Dept Name Dept_Mail_Box Dept Phone FK1 Emp Num has H + Line Price LGBRAND PK Brand ID Brand Name Brand Type includes LGPRODUCT PK Prod SKU Prod Descript Prod Type Prod Base Prod_Category Prod_Price Prod_QOH Prod Min FK1 Brand_ID provided by LGSALARY HISTORY PK,FK1 Emp Num Sal From PK Sal End Sal_Amount LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU provides LGVENDOR PK Vend_ID Vend_Name Vend_Street Vend City Vend State Vend ZIP LGCUSTOMER PK Cust Code Cust Fname Cust Lname Cust Street Cust City Cust_State Cust ZIP Cust Balance places LGINVOICE LGLINE PK,FK1 Inv Num PK Inv Num PK Line Num appears on contains FK1 Cust_Code FK2 Prod SKU Line Qty Inv_Date Inv_Total FK2 Employee ID completes LGEMPLOYEE PK Emp Num Emp Fname Emp Lname Emp_Email Emp Phone Emp Hiredate Emp_Title Emp_Comm FK1 Dept Num employs manlages LGDEPARTMENT PK Dept Num Dept Name Dept_Mail_Box Dept Phone FK1 Emp Num has H + Line Price LGBRAND PK Brand ID Brand Name Brand Type includes LGPRODUCT PK Prod SKU Prod Descript Prod Type Prod Base Prod_Category Prod_Price Prod_QOH Prod Min FK1 Brand_ID provided by LGSALARY HISTORY PK,FK1 Emp Num Sal From PK Sal End Sal_Amount LGSUPPLIES PK,FK1 Vend ID PK,FK2 Prod SKU provides LGVENDOR PK Vend_ID Vend_Name Vend_Street Vend City Vend State Vend ZIP