Given the following scenario and level 1 diagram, create the physical level 2 diagram.
Mavisbank High School has a library that lends books to staff and students. Pupils are allowed to borrow six books and teachers are allowed to borrow ten. When someone borrows a book the library book file is updated, as is the borrower file. Everyone issued with a book has it for a period of one month, after which time they are sent a reminder. If, after six months, they haven't returned the book, they are sent a bill for the cost of recovery of the book.
The answer is given on the next page, but don't look at it until you've tried to answer yourself.
Next: Answer to Activity 7