Consider the LIBRARY relational database schema shown in Figure 6.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.

Data from figure 6.6

Transcribed Image Text:

воок Book id Title Publisher_name ВОOK AUTHORS Book id Author_name PUBLISHER Name Address Phone вооK COPIES Book id Branch_id No_of_copies вооK LOANS Book_id Branch_id Card_no Date_out Due date LIBRARY_BRANCH Branch_id Branch_name Address BORROWER Card no Name Address Phone