Overview:

You are tasked with developing a simple Library Management System $($LMS$)$ using Java. The system should allow librarians to manage books and members efficiently. To demonstrate your understanding of Creational Design Patterns, you will need to incorporate at least three of the five patterns discussed: Singleton, Factory Method, Abstract Factory, Builder, and Prototype.

Problem Statement:

Create a Library Management System with the following capabilities:

$1.$ Add$/$Remove$/$Update Books: Books should have attributes like ID$,$ title, author, and status $($Available$,$ Borrowed$).$

$2.$ Manage Members: Add new members, update member information, and remove members. Members should have attributes like ID$,$ name, and the list of borrowed books.

$3.$ Borrowing and Returning Books: Members should be able to borrow and return books.

Design Requirements:

$1.$ Singleton Pattern: Ensure that the database connection $($simulated using a CSV file$)$ is handled using the Singleton pattern. There should only be one instance of the database handler.

$2.$ Factory Method or Abstract Factory Pattern: Use to create different types of users $($e$.$g$.,$ Librarian, Member$)$ or different types of logs $($e$.$g$.,$ BorrowLog, ReturnLog$).$

$3.$ Builder Pattern: Implement the Builder pattern for creating complex objects, such as a Book or a Member with multiple attributes.

$4.$ Prototype Pattern $($Optional$)$: Use for cloning objects, if applicable, such as duplicating book records for multiple copies.

Getting Started:

$1.$ Define Classes and Interfaces: Start by defining the necessary classes and interfaces for Books, Members, Logs, and the Database handler.

$2.$ Implement Design Patterns:

$-$Singleton: Ensure the CSV file handler is implemented as a Singleton.

$-$Factory Method$/$Abstract Factory: Define a factory for creating Users or Logs.

$-$Builder: Implement the Builder pattern for creating Book and Member objects with various attributes.

$-$Prototype: If applicable, implement the Prototype pattern for any suitable use case.