Having looked at 0.7 and 0.7B, I realize that the DEPARTMENT information has gone missing. Is this information relevant to the library management system?

For Borrowed books, it would be a good idea to store the username from useraccount table. This is to help you know which librarian checked out the book for the patron.