It is relational database concept in which multiple tables shares consistent relationship based on the data stored on tables.
For example, a school X has 2 tables, a student table, and a student fee table. In the student table we have 2 columns – the student ID and the student name. In the student fee table, we have 2 columns – the student ID and the fee for the given ID.
Now, suppose we want to remove a student because he no longer study at school X. So we need to remove that student from student table. As the student ID from student table exists in student fee table then from that table we need to delete too manually. That’s a big deal if there are too many table attached.
By referential integrity we can solve this problem. Lets define the student ID column in the student table to be our primary key. Then define the student ID column in the student fee table to be a foreign key that points to a primary key that is the student ID column in the student table.
Once we define our foreign to primary key relationship, we need to add ‘constraint’ on student fee table i.e. ‘cascading delete’. Whenever an student is removed from the student table, any data that student has in the student fee table would automatically be removed from the student fee table.
ALTER TABLE `tbl_1` ADD CONSTRAINT `tbl_std_constr` FOREIGN KEY (`student_id`) REFERENCES `tbl_2` (`student_id`) ON DELETE CASCADE ON UPDATE CASCADE;
Glass at height is easy to overlook, in both senses. It is out of reach,…
Almost every rental business starts the same way. A handful of items, a notebook or…
When it comes to designing the office interior you need a highly professional designer. Your…
Emergencies can happen anywhere, whether at home, in the workplace, at school, or during outdoor…
A dental practice’s website is essential, but it is only one place where prospective patients…
Golf is often described as a game of patience, practice, and precision. That is true,…