What is the data integrity of the relation model?
- The data integrity in the relation model data items has consistency in their values.
- The data integrity allows the purity of the data items in the criteria.
- Integrity of data in the relational model data enter by many users and the data checking by the certain specified rules of the integrity of data.
- Some queries perform the data entering as insertion, selection and updating on the data items in the database which causes the data integrity is maintained by these queries.
- The data integrity checks according to their general rule of integrity of data at the entry level of data itself.
For example of integrity of data in relational model
When you are enter the data item in the relational database such as “student
class” over the student of whole school. All the students are take consistency
of the data as student name by the performing a query or by the rules of
integrity of data.
In the above image the data integrity are performed by the specific query which is the "select" query of the database programming in the relational database management system model.
In the relational model the query has performed on the all over the records or tuples and the keyword which is used to make the data in the consistent form by the "class" from every record.
Finally the "select" query gives you the consists records below the all records of the database.
Here is the name of the consistent records are Rita Singh and Raju Singh which are in the class fourth in the school record of the relational database management system model.
Comments
Post a Comment