Question
Download Solution PDFLet relation R2 has a Foreign Key that refers to Primary Key of relation R1. Which of the following operations may cause violation of referential integrity constraints?
I: insert into R1
II: insert into R2
III: delete from R1
IV: delete from R2
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDF|
Table R1(Having Primary Key) |
||
|
A |
B |
C |
|
1 |
|
|
|
2 |
|
|
|
3 |
|
|
|
Table R2(Having Foreign Key) |
||
|
A |
B |
C |
|
1 |
|
|
|
2 |
|
|
|
3 |
|
|
- Insert into R1 cannot cause any violation.
- Insert into R2 can cause violation if any value is inserted into D of R2 which value is not in A in R1
- Delete from R1 can cause violation if any tuple is deleted which is referenced to by D in R2.
- Delete from R2 cannot cause any violation
Last updated on Jun 6, 2025
-> The HTET TGT Applciation Portal will reopen on 1st June 2025 and close on 5th June 2025.
-> HTET Exam Date is out. HTET TGT Exam will be conducted on 26th and 27th July 2025
-> Candidates with a bachelor's degree and B.Ed. or equivalent qualification can apply for this recruitment.
-> The validity duration of certificates pertaining to passing Haryana TET has been extended for a lifetime.
-> Enhance your exam preparation with the HTET Previous Year Papers.