
3. Which links between table types are implied by posted identifiers, even though
there is no direct connection on the E-R type diagram? (2 min)
4. Draw up a transaction/attribute grid for each of the following transactions:
(a) List the ISBNX and title of all books written by a named author. (2 min)
(b) Delete all details of a borrower, given the borrowerNo, provided that the
borrower has no copies out on loan. If the borrower is deleted, all reservations by
that borrower should also be deleted. (2 min)
(c) Store details of a new acquisition. Some acquisitions may be additional copies of
books already in stock. (2 min)
5. Redesign the library E-R model ...