CUSTOMERS (CUSTNO, CNAME, CADDRESS, BALANCE)
SALESPERSONS (SPNO, SNAME, DATE_EMPLOYED, SALARY)
SALES (INVOICENO, DATE, CUSTNO*, SPNO*)
ITEMS-SOLD (INVOICENO, ITEMNO, QUANTITY, QUANTDISCOUNT)
(a) List customer name, invoice number and date for items that were sold by the salesperson "Jane Doe", with sales unit more than 100 units, and quantity discount less than 5%.
Dear Student Please find... View the full answer