THE RELATIONAL DATABASE MODEL: ADDITIONAL CONCEPTS - Fundamentals of Database Management Systems - page 156

delete the record for ship number 005 in the
SHIP relation?
iii. 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?
iv. 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?
v. 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?
vi. 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?
vii. The delete rule between the SHIP and CRUISE
relations is restrict and an attempt is made to
delete the record for cruise number 26964 in the
CRUISE relation?
viii. The delete rule between the SHIP and CRUISE
relations is cascade and an attempt is made to
delete the record for cruise number 26964 in the
CRUISE relation?
ix. The delete rule between the SHIP and CRUISE
relations is set-to-null and an attempt is made to
delete the record for cruise number 26964 in the
CRUISE relation?
2. Super Baseball League
a. In the Super Baseball League database of Chapter
5, Minicase 2, assume that instead of having
coaches who are different from players, now some

of the players serve as coaches to other players.
A player/coach can have several players whom
he coaches. Each player is coached by only one
player/coach. Reconstruct the database structure to
reflect this change.
b. In the Super Baseball League database of Chapter
5, Minicase 2, assume that the TEAM relation has
a record for team number 17 and that the COACH
relation has records for three coaches on that team.
What would happen if:
i. The delete rule between the TEAM and COACH
relations is restrict and an attempt is made to
delete the record for team 17 in the TEAM
relation?
ii. The delete rule between the TEAM and COACH
relations is cascade and an attempt is made to
delete the record for team 17 in the TEAM
relation?
iii. The delete rule between the TEAM and COACH
relations is set-to-null and an attempt is made
to delete the record for team 17 in the TEAM
relation?
iv. The delete rule between the TEAM and COACH
relations is restrict and an attempt is made to
delete the record for one of team 17's coaches in
the COACH relation?
v. The delete rule between the TEAM and COACH
relations is cascade and an attempt is made to
delete the record for one of team 17's coaches in
the COACH relation?
vi. The delete rule between the TEAM and COACH
relations is set-to-null and an attempt is made to
delete the record for one of team 17's coaches in
the COACH relation?