Consider two relations
R(a,b,c) and S(d,e,f)
ādā is the foreign key of S that refers to the primary key of R.
Consider the following operations on R and S
- Insert into R
- Insert into S
- Delete from R
- Delete from S
Which of the following is true about the referential integrity constraint above?
1
None of the above cause violation
2
Only 3 can cause violation
3
Only 1 and 4 can cause violation
4
Both 2 and 3 can cause violation