Consider the LIBRARY relational database schema of Figure 4.6. Choose the appropriate action (reject, cascade, set to

Question:

Consider the LIBRARY relational database schema of Figure 4.6. Choose the appropriate action (reject, cascade, set to null, set to default) for each referential integrity constraint, both for the deletion of a referenced tuple, and for the update of a primary key attribute value in a referenced tuple. Justify your choices.