I need erd diagram(Conceptual Diagram) and logical model for this question Imagine that your town library wants

 

I need erd diagram(Conceptual Diagram) and logical model  for this question

Transcribed Image Text:

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 mail. 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 (we assume that this library has no other resource). Each book has a title and any number of authors. Also, more than one book in the library might have the same title. Similarly, multiple authors might have the same name. (hint, we can use ISBN, International Standard Book Number, to identify the book) 4. A writer could be the author of more than one book. 5. A book will be checked out repeatedly as time goes on. Suppose the library only has one copy for each book. 6. The library must be able to identify whether a book is checked out. 7. 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. 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 mail. 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 (we assume that this library has no other resource). Each book has a title and any number of authors. Also, more than one book in the library might have the same title. Similarly, multiple authors might have the same name. (hint, we can use ISBN, International Standard Book Number, to identify the book) 4. A writer could be the author of more than one book. 5. A book will be checked out repeatedly as time goes on. Suppose the library only has one copy for each book. 6. The library must be able to identify whether a book is checked out. 7. 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.