MIS 605 Topic 8 DQ 2 (Latest Update) Verified and Rated A+

MIS 605 Topic 8 DQ 2 Explain how keeping an up-to-date ERD ensures data integrity. If someone looks over the ERD and finds and error, explain how the error could be fixed and the update/change communicated to other stakeholders. Discuss the potential backlash that could result from a misreported dataset. Audits of the ERD, reporting the findings, and making recommendations to management, ensure data integrity. As the data and combinations of deriving information grows (implementation of additional modules, entities, etc.), constant and consistent assessments and revisions to the ERD are necessary. The ERD gives a graphic representation of the application of those aspects of the database elements, their correlation with each other, and possible combinations for deriving information that can be relied upon. Relied upon being mandatory. It allows the DBA to understand the current and possible combinations of the data to ensure integrity and reliability. For example, the implementation of a payroll module to an accounting system. Data integrity is the foundational component of information that relies on the accuracy and consistency of data stored in a database. This foundation is established when a database is developed, implemented, and defines the purpose, rules, relationships of the elements within the database. Though, these aspects may be static, their application is not. The ERD is established during the initial development of the database. The consequences from the reliance on bad information can take many forms, from internal discipline, loss of market share, trust, moral, etc. All leading to lost revenue and valuable resources. •