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

question 120

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.

-To prevent inconsistent formatting,Kate needs to ask the database designer to make the database automatically reject any entry that was typed in the wrong format.What should Kate request be applied to the telephone number field to solve this problem?

• A) field format
• B) consistency rule
• C) lookup routine
• D) structured query

---

Definitions:

Sensory Neurons

Nerve cells that are responsible for converting external stimuli from the environment into corresponding internal stimuli.

Motor Neurons

Nerve cells that initiate and control the movement of muscles by transmitting signals from the brain or spinal cord.

Serotonin

A neurotransmitter that affects mood, appetite, and sleep, playing a significant role in regulating emotional well-being.

Parkinson's Disease

A neurodegenerative disorder characterized by motor symptoms such as tremors, stiffness, and bradykinesia due to the loss of dopamine-producing cells in the brain.