Data item.......................................................................

Question

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

Explanation / Answer

Phone

Data Item MySql Data Type CompanyName varchar(30) StreetAddress varchar(60) City varchar(20) State varchar(20) Country varchar(30) PostalCode int

Phone

varchar(20) Fax varchar(30) Website varchar(30) Invoice# int Date date CustomerID int DueDate date UnitPrice decimal(5,2) Qty int Taxed boolean Amount decimal(5,2) ServiceFee decimal(5,2) Labor decimal(5,2) Parts decimal(5,2) Taxable decimal(5,2) TaxRate decimal(5,2) TaxDue decimal(5,2) OtherCharges decimal(5,2) ContactName varchar(30) Phone# varchar(20) Email varchar(30) OtherComments char(100)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.