Use Figure 7.1 The Database model in the textbook database systems , design implementation and management 12th edition.

1) List the description, date, and price of products with a vendor code of 23119.

2) List product information for the ones with price over 50 dollars and quantity on hand below 10

3) List vendor code, name, and contact information for the vendors in Florida.

4) List customer name and phone number for those with non-zero balance.

Customer Invoice Database ERD INVOICE LINE CUSTOMER |INV-NUMBERI. PK,FK1 PK |INV-NUMBER PK CUS CODE IPK FK1 CUS CODE .9enerates, co ain LINE NUMBER CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS BALANCE INV DATE LINE UNITS LINE PRICE isfound in VENDOR PRODUCT PK V CODE V NAME V_CONTACTH-SUupplies V AREACODE V PHONE P DESCRIPT P INDATE V STATE V ORDER P MIN P PRICE P DISCOUNT FK1 V CODE