Data item.................................................................................MYSQL DATA TYPE

1. What are the data elements from the image of an invoice below that a computer could store in a database? What MySQL data type would you use for each data element? Company Name INVOICE LOGO Street Address] City, State/Province, Country, Postal Code] Phone: [000-000-0000] Fax: [000-000-0000] Website: somedomain.com DATE INVOICE # CUSTOMER ID DUE DATE 6/15/16 23456 123 7/15/16 BILL TO Name] [Company Name] Street Address [City, State/Province, Country, Postal Code] Phone] UNIT PRICE QTY TAXEDAMOUNT DESCRIPTION Service Fee] Labor @ $75/hr] Parts] 150.00 75.00 5 25.003 150.00 375.00 75.00 Subtotal Taxable Tax rate Tax due Other TOTAL604.69 600.00 75.00 6.250% 4.69 OTHER COMMENTS 1. Total payment due in 30 days 2. Please include the invoice number on your check Make all checks payable to [Company Name] If you have any questions about this invoice, please contact [Name, Phone #, E-mail] Thank You For Your Business! DATA ITEM MYSQL DATA TYPE