Case-Based Critical Thinking Questions
?
Case 1: MaidToOrderThe database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
InvoiceNum
CustomerNum
InvoiceDate
InvoiceAmt
InvoicePaid
631
13020
01/15/2013
200.00
Y
632
15411
01/20/2013
685.00
Y
633
10002
01/23/2013
75.00
N
634
13104
01/23/2013
150.00
N
635
12124
01/26/2013
75.00
Y
636
13328
02/02/2013
350.00
Y
637
10206
02/02/2013
175.00
N
638
10334
02/07/2013
450.00
Y
Which data type would you use for the InvoicePaid field?
A. char(1)
B. varchar(10)
C. char(A-F)
D. varchar(A-F)
Answer: A
Computer Science & Information Technology
You might also like to view...
If a document contains several charts, using a chart ________ provides consistency in style and formatting
Fill in the blank(s) with correct word
Computer Science & Information Technology
Many brushes on the Brush panel have been designed with Shape Dynamics as their default setting.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology