Please also indicate the relationship, thanks

Instructions: You can use Lucidchart or Powerpoint to draw the diagram. Paste your ER diagram in this worksheet. Imagine that your town library wants to keep track of its business in a database, and that you have been called in to build the database. You talk to the town librarian, review the old paper-based records, and watch people use the library for a few days. You learn the following about the library: 1. Any resident of the town can get a library card simply by asking for one. The library considers each cardholder a member of the library. 2. The librarian wants to be able to contact members by telephone and by email. She calls members when books are overdue or when requested materials become available. She likes to email a thank-you note to each patron on his or her anniversary of becoming a member of the library. Without a database, contacting members efficiently can be difficult; for example, multiple members can have the same name. Also, a parent and a child might have the same first and last name, live at the same address and share a phone. 3. The library stocks thousands of books. Each book has a title and author names. Also, more than one book in the library might have the same title. Similarly, multiple authors might have the same name. 4. A book will be checked out repeatedly as time goes on. For example, Orchids of France could be checked out by one member in March, by another member in July, and by another member in September. 5. The library must be able to identify whether a book is checked out. 6. A member can check out any number of books in one visit. Also, a member might visit the library more than once a day to check out books. A unique number will be generated each time the member checks out a book. 7. All books that are checked out are due back in two weeks, with no exceptions. Design the library's database, following the rules set forth above. Hint: You should create three tables for the library database: a member table, a book table and a book check-out table. You can find the fields, primary key, foreign key and the relationship between tables in the above description