Private Library Management Information System You as a systems analyst and designer were asked to analyze and design a Private Library Management Information System (PLMIS). The proposed system should keep track of the following data items: Library member ID_ No, library member name, library member civil no, civil-card expire date, mobile, address, library member E-mail address, library member nationality, first date of joining the library. The library incorporates books from different knowledge categories. Each category has many books. The system should keep track of book serial number, ISBN (International Standard Book Number), book index number, book title, publishing year, book language, book edition number, book price in OMR, book purchasing date, and book category. If a book has many copies, each copy has a different book serial number. An author may write more than one book, and each book may be written by more than one author, so the system should keep track of author name(s). Each book is published by only one publisher, so the system should keep track of publisher name, publisher E-mail address, and publisher web site address. Each library member can borrow more than one book, and each book can be borrowed by more than one library member in different periods, so the system should keep track of book borrowing date, and book returning back date. The librarian is responsible for indexing books (sticking book index number on each book) and putting them on the right places on different shelfs in the library. Library membership should be renewed annually after paying annual membership fees, so the system should record different dates of paying annual membership for each library member. The proposed system should notify the librarian for library members (borrowers) who borrowed books for more than three weeks. If a borrower borrowed a book for more than 3 weeks, he/she would pay a fine (OMR5). If a borrower returned a book in a bad state (damaged book), he/she would pay a fine (OMR40). So the system should record the history of all fines paid by different library members (date of paying the fine, paid fine value in OMR, and the reason of paying the fine).A librarian can add, delete, modify, search by book name, author name(s), book-category, or ISBN, index, lend, and return back a book. A librarian is responsible for issuing and renewal of library memberships, and collecting the fines. A library member can search books by book name, author name(s), book category, or ISBN. Also they (a librarian and a library member) can check book status (available/ borrowed). Assume any mandatory, optional, and relationships from the previous case study and from your logical point of view. For the above case study, and using Sybase Power Designer S/W, or one of the open-source S/W that supports UML (such as draw.io, click chart, star UML, etc.,) draw the following diagrams: 1. Entity Relationship Diagram (ERD), OR Domain Model Class
Private Library Management
You as a systems analyst and designer were asked to analyze and design a Private Library Management Information System (PLMIS). The proposed system should keep track of the following data items: Library member ID_ No, library member name, library member civil no, civil-card expire date, mobile, address, library member E-mail address, library member nationality, first date of joining the library. The library incorporates books from different knowledge categories. Each category has many books. The system should keep track of book serial number, ISBN (International Standard Book Number), book index number, book title, publishing year, book language, book edition number, book price in OMR, book purchasing date, and book category. If a book has many copies, each copy has a different book serial number. An author may write more than one book, and each book may be written by more than one author, so the system should keep track of author name(s). Each book is published by only one publisher, so the system should keep track of publisher name, publisher E-mail address, and publisher web site address. Each library member can borrow more than one book, and each book can be borrowed by more than one library member in different periods, so the system should keep track of book borrowing date, and book returning back date. The librarian is responsible for indexing books (sticking book index number on each book) and putting them on the right places on different shelfs in the library. Library membership should be renewed annually after paying annual membership fees, so the system should record different dates of paying annual membership for each library member. The proposed system should notify the librarian for library members (borrowers) who borrowed books for more than three weeks. If a borrower borrowed a book for more than 3 weeks, he/she would pay a fine (OMR5). If a borrower returned a book in a bad state (damaged book), he/she would pay a fine (OMR40). So the system should record the history of all fines paid by different library members (date of paying the fine, paid fine value in OMR, and the reason of paying the fine).A librarian can add, delete, modify, search by book name, author name(s), book-category, or ISBN, index, lend, and return back a book. A librarian is responsible for issuing and renewal of library memberships, and collecting the fines. A library member can search books by book name, author name(s), book category, or ISBN. Also they (a librarian and a library member) can check book status (available/ borrowed). Assume any mandatory, optional, and relationships from the previous case study and from your logical point of view.
For the above case study, and using Sybase Power Designer S/W, or one of the open-source S/W that supports UML (such as draw.io, click chart, star UML, etc.,) draw the following diagrams:
1. Entity Relationship Diagram (ERD), OR Domain Model Class
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)