In Some Business Environments, the Database Designer Also Enters the Data

question 112

Multiple Choice

In some business environments, the database designer also enters the data into the database. In Kate’s large banking firm, however, the actual database entries are not made by the database designers.

After perusing the database, Kate has discovered that one data entry operator might enter a telephone number as 555-555-7777, another as (555) 555-7777, and a third as 1-555-555-7777. When multiple data entry operators enter telephone numbers in different formats, it becomes difficult to produce nicely formatted reports or to locate a particular telephone number.

-Kate would also like to request that the database developer ensure that the data entry operators cannot enter a dollar amount of less than $0.00 in any currency fields.What should she ask be applied to those fields?

• A) case rule
• B) field validation rule
• C) field format
• D) lookup routine

---

Definitions:

Burden of Proof

The obligation to present evidence to support one's claim or defense in a legal dispute, determining which party must prove the truth of their assertions to achieve a favorable outcome.

Due Diligence Meeting

A meeting conducted to carefully review and investigate a potential investment, business deal, or partnership to ensure all facts are known before proceeding.

Misstatements

False or inaccurate statements or entries, often referring to errors or inaccuracies in financial documents or reporting.

Registration Statement

A set of documents filed with securities regulatory bodies detailing information about a company's financial situation and the securities it wishes to issue.