Description of the library management system (LMS) is as follows: LMS offers a user-friendly way of issuing books and also viewing different books and titles available under a category. You are required to create a Database Application and use SQL queries that enable quick retrieval of the required information. The library system should have the following features: 1. A book catalogue with search by name, author and category of the books. Note there may be more than one copy of each book, and a book may even be published by different publishers. 2. The ability to deactivate a patron's account if he/she does not return books after a specific period of time passes. 3. Records of books checked out as well as placed on hold (i.e. "reserved" by a patron to make sure the book is there when he/she gets to the library to check it out). 4. Notifications when the desired book becomes available and reminders that a book should be returned to the library. Both could be sent by email and/or when patron logs in to the LMS. 5. Provide analysis report to management to review the system. (Note: You may have your assumptions/suggestions to decide what kind of the analysis report to be generated. For example, to find out the peak hour(s) of the library so that management could arrange enough manpower; etc.) a. According to the description of the Library Management System, provide an ER diagram to define clearly for all necessary entities, for example, which entities are "weak" or "strong" as well as the relationships (especially the many-to-many relationship and the N-ary relationship) among the entities. (Note: You should have your assumptions to design your database application.) b. Based on the ER diagram, generate a relational schema for the Library Management System. c. A project plan or a project schedule should be prepared and submitted. Description of the library management system (LMS) is as follows: LMS offers a user-friendly way of issuing books and also viewing different books and titles available under a category. You are required to create a Database Application and use SQL queries that enable quick retrieval of the required information. The library system should have the following features: 1. A book catalogue with search by name, author and category of the books. Note there may be more than one copy of each book, and a book may even be published by different publishers. 2. The ability to deactivate a patron's account if he/she does not return books after a specific period of time passes. 3. Records of books checked out as well as placed on hold (i.e. "reserved" by a patron to make sure the book is there when he/she gets to the library to check it out). 4. Notifications when the desired book becomes available and reminders that a book should be returned to the library. Both could be sent by email and/or when patron logs in to the LMS. 5. Provide analysis report to management to review the system. (Note: You may have your assumptions/suggestions to decide what kind of the analysis report to be generated. For example, to find out the peak hour(s) of the library so that management could arrange enough manpower; etc.) a. According to the description of the Library Management System, provide an ER diagram to define clearly for all necessary entities, for example, which entities are "weak" or "strong" as well as the relationships (especially the many-to-many relationship and the N-ary relationship) among the entities. (Note: You should have your assumptions to design your database application.) b. Based on the ER diagram, generate a relational schema for the Library Management System. c. A project plan or a project schedule should be prepared and submitted
