Case 3 There is the database designer and the people who enter the data. Sometimes this is the same person, but in Kate's large banking firm, the actual database entries are not made by the people who designed the database. A data entry operator might enter a telephone number as 555-555-7777, (555) 555-7777, or 1-555-555-7777. If multiple data entry operators enter telephone numbers in different reports, it becomes difficult to produce nicely formatted reports or locate a particular telephone number. To prevent inconsistent formatting, a database designer can specify a ____, so that now if someone attempts to enter data in the wrong format, the database rejects that entry.
A) field format
B) field validation rule
C) lookup routine
D) structured query

Question

Quizplus · Accepted Answer

The Answer of Case 3 There is the database designer and the people who enter the data. Sometimes this is the same person, but in Kate's large banking firm, the actual database entries are not made by the people who designed the database. A data entry operator might enter a telephone number as 555-555-7777, (555) 555-7777, or 1-555-555-7777. If multiple data entry operators enter telephone numbers in different reports, it becomes difficult to produce nicely formatted reports or locate a particular telephone number. To prevent inconsistent formatting, a database designer can specify a ____, so that now if someone attempts to enter data in the wrong format, the database rejects that entry.
A) field format
B) field validation rule
C) lookup routine
D) structured query

Case 3 There Is the Database Designer and the People