University Library Management System - Data Science

This assignment outlines the requirements for a Library Management System, detailing functionalities for library staff, users, and administrators. Library staff must be able to manage book loans, returns, and reservations, as well as manage user accounts and fines. Library users can search for books, view their loan history, and reserve books. The system must also handle different types of users, such as students and academic staff, with different borrowing limits. The assignment covers the creation of an Entity-Relationship Diagram to capture the key entities and relationships in the system. The system must also track book availability, including the number of copies in stock, and manage reservations and notifications. This assignment requires a comprehensive understanding of database design and data management principles.