Question: What would happen if: The delete rule between the SHIP and CRUISE relations is restrict and an attempt is made to delete the record for
What would happen if:
The delete rule between the SHIP and CRUISE relations is restrict and an attempt is made to delete the record for ship number in the SHIP relation?
The delete rule between the SHIP and CRUISE relations is restrict and an attempt is made to delete the record for ship number in the SHIP relation?
The delete rule between the SHIP and CRUISE relations is cascade and an attempt is made to delete the record for ship number in the SHIP relation?
The delete rule between the SHIP and CRUISE relations is cascade and an attempt is made to delete the record for ship number in the SHIP relation?
The delete rule between the SHIP and CRUISE relations is settonull and an attempt is made to delete the record for ship number in the SHIP relation?
The delete rule between the SHIP and CRUISE relations is settonull and an attempt is made to delete the record for ship number in the SHIP relation?
The delete rule between the SHIP and CRUISE relations is restrict and an attempt is made to delete the record for cruise number in the CRUISE relation?
The delete rule between the SHIP and CRUISE relations is cascade and an attempt is made to delete the record for cruise number in the CRUISE relation?
The delete rule between the SHIP and CRUISE relations is settonull and an attempt is made to delete the record for cruise number in the CRUISE relation?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
