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.
------------------------------------------------------------------------------------------------------------
I hope you from this topic “ What do you mean by data integrity in the relational model of database? ” and you can enjoy this informative post that i have published and provide you to the information technology or computer science related solution or questions/answers provided in the topic to study and happy learning 🙂
"Thank you for taking the time to read this post! I hope you found the information helpful and informative. Don't forget to stay tuned for more exciting updates and insightful content. Your support means the world to me!"

Comments
Post a Comment