as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
design a database schema for a library that tracks book lending.
user
the database should have a books table that contains information such as book title, author, isbn, etc. it should also have a borrowers table that contains borrower information such as name, address, and phone number. the main table should be a loans table that links each book with a borrower. the loans table should also contain information such as loan date and return date.
assistant