When evaluating database management practices, which of the following controls would MOST effectively support data integrity?
Click on the arrows to vote for the correct answer
A. B. C. D.B.
When evaluating database management practices, the most effective control to support data integrity is System edit checks.
Explanation:
System edit checks ensure that data entered into the system conforms to predefined rules and criteria. These checks help prevent the entry of invalid, incomplete, or inaccurate data that could compromise data integrity. For example, a system edit check might prevent the entry of a negative number into a field that is supposed to contain positive values.
System processing output balanced to control totals is a control that verifies that the sum of a particular field in a set of records is equal to a predefined total. This control is useful for detecting errors that may have occurred during processing, such as the omission of a record or the entry of incorrect data.
User access controls limit access to the system and its data to authorized users. This control is important for ensuring the confidentiality of sensitive data and preventing unauthorized changes to data, but it does not directly support data integrity.
System-generated duplicate transaction reports provide a record of all transactions processed by the system. This control is useful for detecting and correcting errors or fraud, but it does not prevent the entry of invalid data or ensure data integrity.
In conclusion, while all of the listed controls are important for database management practices, System edit checks would be the most effective control to support data integrity.