Create a DRAWN ERD digram not a uml or code. Follow the requirments please. If possible create the schema as well. Use the right notations for ERD for example using rectangles for entities,cirlces for attributes i also want the cardinalties

Case $4$: Library Management System

Overview:

The university library is one of the central hubs for student resources. To improve its services and streamline operations, the library administration has decided to implement a digital Library Management System $($LMS$).$ The LMS will handle book inventory, member information, borrowing, returns, fines, and various reporting features. Your task is to design and implement a relational database for the LMS$,$ ensuring it can handle complex queries and maintain data integrity.

Objectives

Design a normalized relational database schema that accommodates:

Books: Each book has a unique ID$,$ title, author$($s$),$ genre, publication date, and availability status.

Members: Each member $($student or faculty$)$ has an ID$,$ name, email, phone number, department, and type $($student$,$ faculty$).$

Borrowing and Returning Records: Track which members have borrowed books, including borrow and return dates, and calculate fines based on overdue books.

Fines: Maintain records of fines imposed on members, with details on whether they have been paid.

Librarians: Include librarian data to record who processed each borrowing$/$return transaction. Key Functionalities

Book Management:

Add, update, and delete book records.

View available books by genre, author, or title.

Member Management:

Register new members $($students and faculty$)$ with their details.

Update member information as needed.

Borrowing$/$Returning Books:

Process book borrow requests and update book availability.

Track due dates and calculate fines for overdue books.

Record the librarian responsible for each transaction.

Fine Management:

Automatically calculate fines for overdue books and add them to the member's account.

Enable fine payment updates to clear the member's record.

Reports and Queries:

Generate daily, weekly, or monthly reports on the most borrowed books, overdue books, members with unpaid fines, and library usage patterns.

Extra deliverables for this case

User Interface:

Create an application interface for librarians and members to interact with the system.

Allow librarians to log in$,$ add$/$remove books, manage members, and view reports.

Allow members to check their borrowing history and fines.