top of page
hand-businesswoman-touching-hand-artificial-intelligence-meaning-technology-connection-go-

QUICK READ FOR BEGINNERS - DATA INTEGRITY

Why did I choose to write about data integrity …I came across this word when I started to learn about SQL and data testing as it was intriguing, I did a little research


What is Data Integrity


Data integrity is the accuracy, completeness, and quality of data as it’s maintained over time and across formats. When creating databases attention needs to be given to data integrity as it ensures that the data maintained would be highest standard of quality


ALOCA Principle


To maintain data Integrity ALOCA principle is followed






Types of Data Integrity





Entity Integrity:


Defines each row to be unique within its table No two rows can be the same


To achieve the same primary key can be defined.


Referential Integrity:


Defines that the foreign key value matches with primary key, if this is not ensured then the foreign key value would have no matching primary key value in primary table which results in orphaned record


Domain Integrity:


Defines the validity of entries for a given column ensuring domain integrity would help us to make sure data type entered for each column is appropriate, rules to define data format, restricting the range of possible values


User Defined Integrity:


Allows the user to apply business rules to the database that aren’t covered by the other 3 integrity


Ensuring data integrity to prevent unintentional changes to information.

16 views0 comments
bottom of page