Question: ( 5 pts ) What relationship is it between SHIP and CRUISE relations? ( 5 pts each, 2 5 pts total ) What would happen

(5pts) What relationship is it between SHIP and CRUISE relations?
(5pts each, 25pts 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 012 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 005 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 012 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 005 in the SHIP relation?
. The delete rule between the SHIP and CRUISE relations is set-to-null and an
attempt is made to delete the record for ship number 012 in the SHIP relation?
. The delete rule between the SHIP and CRUISE relations is set-to-null and an
attempt is made to delete the record for ship number 005 in the SHIP relation?
O). Example Answer: Nothing would be deleted because two records of the
CRUISE relation refer to that ship.
2.1).
2.2).
2.3).
2.4).
2.5).
Due on Oct 12,202411:59 PMPLEASE ANSWER QUESTIONS 1 and 2 FULLY. I MUST GET 100% ON THIS ASSIGNMENT PLEASE CONSULT BOTH IMAGES FOR INSTRUCTIONS AND SUBSEQUENT QUESTIONS ON ASSIGNMENT.
( 5 pts ) What relationship is it between SHIP

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!