Explain the type of validation rule you would add to a Salary field with a Number data type.

What will be an ideal response?


At the very least, a validation rule of >=0 would make sense because people cannot make a negative salary. If there is a maximum salary for the company (say, $150,000), you may want to consider Between 0 and 150000 to ensure it falls in the correct range.

Computer Science & Information Technology

You might also like to view...

The for all together statement is designed specifically for processing each of the items in an array.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A search can be performed on an array of

A) integers. B) strings. C) objects. D) all of the above, but only if the data is in order. E) all of the above whether the data is in order or not.

Computer Science & Information Technology

The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Answer the following statements true (T) or false (F)

1. Examining policies allows the systems analyst to gain an awareness of the values, attitudes, and beliefs that are guiding the corporation. 2. Observation is an information gathering technique that allows the analyst to see firsthand how managers process and use information. 3. A policy handbook is an organized and systematic approach that demands that analysts understand and articulate the action taken by decision makers being observed. 4. A form of structured observation having roots in film criticism is known as ROBE.

Computer Science & Information Technology