
(3) Notify borrower that reservation is now in stock.
(4) Change borrower’s status.
(5) Find books written by a given author.
The model appears to be capable of supporting these transactions.
Step 11 A detailed analysis of each transaction must be made so that the adequacy of
the model can be checked. For example, a loan might be recorded simply by storing a
new Loan occurrence; alternatively the Borrower and Copy tables could be checked
first to ensure that the accessionNo and borrowerNo are valid. Deletion of the last copy
of a given book implies deletion of not only the Copy occurrence
1
, but also the
associated Book occurrence
1
and perhaps Publisher ...