Question: ( 5 pts ) What relationship is it between SHIP and CRUISE relations? ( 5 pts each, 2 5 pts total ) What would happen
pts What relationship is it between SHIP and CRUISE relations?
pts each, pts total 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?
O Example Answer: Nothing would be deleted because two records of the
CRUISE relation refer to that ship.
Due on Oct : PMPLEASE ANSWER QUESTIONS and FULLY. I MUST GET ON THIS ASSIGNMENT PLEASE CONSULT BOTH IMAGES FOR INSTRUCTIONS AND SUBSEQUENT QUESTIONS ON ASSIGNMENT.
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
