ISYS114 Lecture Notes - Lecture 9: Referential Integrity, Total Quality Management, Organizational Commitment

• School: Macquarie University
• Department: Information Systems
• Course: ISYS114
• Professor: Charanya

Document Summary

High-level organizational groups and processes overseeing data stewardship across the organization. A person responsible for ensuring that organizational applications properly support the o(cid:396)ga(cid:374)izatio(cid:374)"s data quality goals. Sponsorship from both senior management and business units. A data steward manager to support, train, and coordinate data stewards. Data stewards for different business units, subjects, and/or source systems. A governance committee to provide data management guidelines and standards. If the data are bad, the business fails. Sarbanes-oxley (sox) compliance by law sets data and metadata quality standards. Uniqueness means that each entity exists no more than once within the database, and there is a key that (cid:272)a(cid:374) (cid:271)e used to u(cid:374)i(cid:395)uely a(cid:272)(cid:272)ess ea(cid:272)h e(cid:374)tity. That"s o(cid:374)e of the (cid:396)easo(cid:374)s (cid:449)e ha(cid:448)e p(cid:396)i(cid:373)a(cid:396)y keys in database tables. Accuracy means the degree to which data correctly represents the real-life objects it models. Data must be both accurate and precise enough for their intended use.