Share
Explore BrainMass

Data modeling tools

How can data modeling tools such as an E-R diagram help identify inconsistencies early on in the data modeling process? How can the data modeling process encourage accountants and other users to get more involved in database design?

What techniques might an auditor employ to evaluate the reliability and integrity of an accounting information system?

Solution Preview

How can data modeling tools such as an E-R diagram help identify inconsistencies early on in the data modeling process? How can the data modeling process encourage accountants and other users to get more involved in database design?

The E-R diagram is a conceptual data model that views the real world as consisting of entities and relationships and makes it possible to answer questions and generate the reports for the business' needs. It is used to document large-scale database relationships. Output designs are documented through the use of a variety of reporting tools such as report writers, data extraction tools, query tools, and on-line analytical processing tools. The E-R diagram can also help us to identify inconsistencies. The process of constructing an E-R diagram also helps us to identify inconsistencies and uncover them. For example data redundancy may lead to data inconsistency and results with errors when obsolete data is used for management decisions. Some of them can also be resolved as the initial E-R diagram is constructed while others are resolved by performing a series of transformations on the diagram after its initial construction. Data should be stored and ...

Solution Summary

This solution discussing data modeling tools and techniques an auditor might employ to evaluate the reliability of the accounting system.

$2.19