SYM 400 Topic 3 DQ1
docx
keyboard_arrow_up
School
Grand Canyon University *
*We aren’t endorsed by this school
Course
400
Subject
Information Systems
Date
Nov 24, 2024
Type
docx
Pages
1
Uploaded by PeanutButterEater102
Data integrity refers to the process of maintaining and assuring the accuracy of the data within a database. What "built-in" architecture techniques promote data integrity? Why is this important? Provide examples to justify your opinions.
Hello professor and class,
Data integrity helps with the overall accuracy, completeness, and consistency of data (Talend, n.d.). Data integrity also helps the database to stay compliant with organizations like GDPR (General Data Protection
Regulation) and to stay secure. A guideline of rules, processes and standards are followed while the data is being integrated in the design phase. Once the integrated data is secure, the data will remain complete, reliable and accurate regardless of how long it is stored or when it is accessed, while protecting the information from unauthorized sources. Each business has its own set of rules and policies that must be true or false like policies on salaries, EIN (Employee ID Numbers), job title/ department, and much more. It is important for the database administer or person creating the database to follow the data integrity policies to keep the data organized and meeting compliance. When a database application is created, there are four ways the designer can guarantee the integrity of the data. They are:
“Enforcing business rules with triggered stored database procedures
Using stored procedures to completely control access to data
Enforcing business rules in the code of a database application
Using Oracle Database integrity constraints, which are rules defined at the column or object level that restrict values in the database (Ashdown & Kyte, 2011).”
While there are two types of integrity (physical & logical), there are 4 types of logical integrity that protect the data from human error and hackers. They include Entity integrity, Referential integrity, Domain integrity, and User-defined integrity. Entity integrity relies on primary keys to uniquely identify data and ensure there is no null data. Referential integrity embeds rules in the database structure to ensure the data is not modified, added on to, or deleted. Domain integrity sets policies on the values that can go into the database like the format, type, and amount of data entered. User-defined integrity are rules and constraints entered into the database manually by the user. This can be useful if the entity, referential, and domain integrity rules are not enough to secure the data. References
Ashdown, L., & Kyte, T. (2011). Data integrity - 11g release 2 (11.2). Moved. https://docs.oracle.com/cd/E25054_01/server.1111/e25789/datainte.htm
Talend. (n.d.). What is data integrity and why is it important? https://www.talend.com/resources/what-
is-data-integrity/
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help