Question: Explain the need for each of the actions in Figure 6-29(b). Actions When Child Is Required Child Required Action on Parent Get a child. Prohibit.
Explain the need for each of the actions in Figure 6-29(b).
Actions When Child Is Required
Child Required Action on Parent Get a child. Prohibit. Update the foreign key of (at least one) child. Prohibit. None. Action on Child None. Insert Modify key or foreign key If not last child, OK. If last child, prohibit or find a replacement. If not last child, OK. Delete If last child, prohibit or find a replacement.
Step by Step Solution
3.45 Rating (168 Votes )
There are 3 Steps involved in it
When a Child table is required the Parent table must have at least one associated Child table row at ... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help