Use the attached image and SQL DDL Commands to query the appropriate tables and populate with four rows of data. Please include explanation for script.

 

Transcribed Image Text:

CUSTOMER PK CustomerID CustomerName Address Phone_Number Email BID PK Bid_Number Bid_Date (Repair_Details) Repair_Completed_Date Rate_Per_Hour New_of_Old_Customer FK Customer_ID CUSTOMER_Payment PK Payment_Number payment_Model Paid_Date Tottal_Bal_Amount Advance_Paid FK Bid Number Item PK Item_no item_Name Supplier_Cost Quantity Purchased Quantity_in_Stock FK Bid Number Re_Order_Level is_Payment_Due FK Supplier_ID t SUPPLIER PK SupplierID Supplier_Name Address Phone_Number Email Supplier Type PK PK, FK1 Supplier_Payment Payment_Number FK item_Number payment_ModePaid_Date Tottal_Bal_Amount Advance_Paid Supplier_ID CUSTOMER PK CustomerID CustomerName Address Phone_Number Email BID PK Bid_Number Bid_Date (Repair_Details) Repair_Completed_Date Rate_Per_Hour New_of_Old_Customer FK Customer_ID CUSTOMER_Payment PK Payment_Number payment_Model Paid_Date Tottal_Bal_Amount Advance_Paid FK Bid Number Item PK Item_no item_Name Supplier_Cost Quantity Purchased Quantity_in_Stock FK Bid Number Re_Order_Level is_Payment_Due FK Supplier_ID t SUPPLIER PK SupplierID Supplier_Name Address Phone_Number Email Supplier Type PK PK, FK1 Supplier_Payment Payment_Number FK item_Number payment_ModePaid_Date Tottal_Bal_Amount Advance_Paid Supplier_ID