What is the database integrity?
Database integrity is a practice to ensure that the data stored in the database is accurate, consistent and without errors. The smallest spelling error or repeating information can cause massive problems for database, so the database integrity is taken seriously. Three proponents of integrity are entity integrity, domain integrity and reference integrity. Together with these three, normalization and errors are applied to further ensure integrity. Most of these processes are automated, but administrators also often check manually to ensure that there are no errors in the database. Incorporating or changing any information may be disastrous because the data can have far -reaching effects on other tables and parts of the database. In order to ease the chance and keep the information in the database accurate, the integrity is Always checked before any changes.
Entity integrity is the first limit of database integrity. This checks the table with which the administrator wants to work with and looks at the names of the lineat. If the rows in the same table have the same name, it will create redundant information, which is confusing for the database.
Another comes the domain integrity. This controls the data type consistently added to the table or section and ensures that the new data corresponds to this data type. For example, if a table that is given only for holding data is listed only and someone is trying to enter the word, then the domain integrity process will alert the administrator to the consistency error. This is because the table is intended only for data processing, so having the word spoils regular processing and can cause errors in the future.
The third database integrity restriction is a reference integrity. The tables in the database are rarely themselves - other tables often refer to other tables. If the administrator orders one table to refer to the other, but the second table is incorrectly written or does not exist, it causes processing errors. ContaminationRole reference integrity to ensure that all references are valid.
In addition to these three integrity problems, the rules of normalization are also used and errors are used to integrate the actual database. Normalization is looking for redundant information and unnecessarily long tables, eliminates redundancy and converts long tables into several short tables. Error checking the database analysis to any other potential errors and ensures that all data is valid.