Examlex

Solved

Case 1 - MaidToOrder
the Database for a Cleaning Service

question 52

Multiple Choice

Case 1 - MaidToOrder
The 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 6311302001/15/2013200.00Y6321541101/20/2013685.00Y6331000201/23/201375.00 N6341310401/23/2013150.00 N6351212401/26/201375.00Y6361332802/02/2013350.00Y6371020602/02/2013175.00 N6381033402/07/2013450.00Y\begin{array} { | l | l | l | l | l | } \hline \text { InvoiceNum } & \text { CustomerNum } & \text { InvoiceDate } & \text { InvoiceAmt } & \text { InvoicePaid } \\\hline 631 & 13020 & 01 / 15 / 2013 & 200.00 & \mathrm { Y } \\\hline 632 & 15411 & 01 / 20 / 2013 & 685.00 & \mathrm { Y } \\\hline 633 & 10002 & 01 / 23 / 2013 & 75.00 & \mathrm {~N} \\\hline 634 & 13104 & 01 / 23 / 2013 & 150.00 & \mathrm {~N} \\\hline 635 & 12124 & 01 / 26 / 2013 & 75.00 & \mathrm { Y } \\\hline 636 & 13328 & 02 / 02 / 2013 & 350.00 & \mathrm { Y } \\\hline 637 & 10206 & 02 / 02 / 2013 & 175.00 & \mathrm {~N} \\\hline 638 & 10334 & 02 / 07 / 2013 & 450.00 & \mathrm { Y } \\\hline\end{array}
-You need to make sure the user of the application can add records but cannot delete any records.Which of the following needs to be performed?


Definitions:

Deposit

A sum of money placed in an account or with a party as a part of a financial transaction, often securing a service or as a part of a purchase agreement.

W-2 Form

An annual tax form used in the United States to report wages paid to employees and the taxes withheld from them.

Net Pay

The amount of money that an employee takes home after all deductions, such as taxes and retirement contributions, have been subtracted from their gross pay.

FICA-OASDI

A U.S. payroll tax that funds the Social Security and Medicare programs, officially known as the Federal Insurance Contributions Act - Old Age, Survivors, and Disability Insurance.

Related Questions