Database - Data Models into Database Designs - Discussion

Discussion Forum : Data Models into Database Designs - True or False (Q.No. 19)
19.
For every relationship, there are six possible referential integrity actions.
True
False
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
2 comments Page 1 of 1.

Pranavkuls said:   1 decade ago
Each relationship there are six possible actions for which referential integrity can be defined:

PARENT INSERT.
PARENT UPDATE.
PARENT DELETE.

CHILD INSERT.
CHILD UPDATE.
CHILD DELETE.

Geek guy said:   1 decade ago
For 1:1 - only 1 referential integrity action is there.
For 1:N - only 1 referential integrity action is there.
For M:N - there are 2 referential integrity actions.

In total there are four. Answer should be false.

Post your comments here:

Your comments will be displayed after verification.