Case 3 There Is the Database Designer and the People

question 52

Multiple Choice

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

---

Definitions:

James Madison

The fourth President of the United States (1809-1817) known as the "Father of the Constitution" for his pivotal role in drafting and promoting the U.S. Constitution and the Bill of Rights.

Articles of Confederation

The first written constitution of the United States, in force between 1781 and 1789, which outlined a confederal government giving significant power to states.

Protecting Liberties

The act of safeguarding individual freedoms and rights from infringement or restriction, often considered a fundamental aspect of democratic governance.

Communal Ideas

Concepts or ideologies that emphasize the importance of community and collective ownership or participation over individualism.