PLEASE ANSWER for $100\%.$ I MUST ACHIEVE A $100$ ON THIS ASSIGNMENT.

Instructions

$($Chapter $5,$ Minicase $1)$ Happy Cruise Lines

a$.$ Look at the Happy Cruise Lines database of Chapter $5,$ Minicase $1$ but, for this

question, consider only the following SHIP, PORT, and PASSENGER relations. The

company wants to keep track of which passengers visited which ports on which ships

on which dates. Reconstruct this relationship and add additional relation$($s$)$ if needed

to store this information. $($Hint: the problem describes a ternary relationship among

these three relations. An additional relation is needed to represent the ternary

relationship. Construct that new relation $($give it a name, with its necessary

attributes$/$Primary$/$foreign keys$).$

B$)$ Consider the following data from the SHIP and CRUISE relations of the Happy

Cruise Lines database of Chapter $5,$ Minicase.

SHIP Relation

CRUISE Relation

b$\mathrm{.}1)$ What relationship is it between SHIP and CRUISE relations?

b$\mathrm{.}2)$ What would happen if:

$(0)$ 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?

$(1)$The delete rule between the SHIP and CRUISE relations is restricted, and an

attempt is made to delete the record for ship number $005$ in the SHIP relation.

$(2)$ 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?

$(3)$ 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?

$(4)$ 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?

$(5)$ 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