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:

Annual Amortization

The process of gradually writing off the initial cost of an intangible asset over its useful life on a yearly basis.

Investment Balance

The total value of all investments held by an individual or entity at a given time, including stocks, bonds, and other securities.

Equity Method

An accounting technique used to record investments in other companies when the investing company has significant influence but does not control the investee.

Total Excess Amortization

Refers to the amount of amortization that exceeds the net carrying value of the intangible asset being amortized.

Related Questions