How to design a database for a library management system identified by ISBN

Design a database for a library management system. The library has a vast collection of books, each
identified by a unique ISBN (International Standard Book Number). The library also has multiple
branches across different locations, and each branch has its own inventory of books. Users can borrow
and return books from any branch, and the system should keep track of the borrowing history.
Design a database schema that efficiently manages the library’s inventory, tracks user borrowing history,
and supports the ability to search for books by title, author, and ISBN. Consider the relationships
between entities, data types, and any additional features you might incorporate to enhance the
systems functionality and performance. Additionally, address potential challenges such as handling
book copies, managing user accounts, and ensuring data integrity in the system.