This project is a Library Management System that allows for efficient management of a library's operations. It provides functionalities to track books, customers, employees, book issuance, and returns. The system, done using SQL, maintains a comprehensive database of books, their availability status, rental cost, and other relevant details. It also enables effective management of customers and employees associated with the library.
Create a new database named "Library" to store the information.
Book Management: Add, update, and remove books from the library's collection. Track book details such as title, category, rental price, availability status, author, and publisher.
Customer Management: Maintain a record of library customers, including their names, addresses, registration dates, and issuance history.
Employee Management: Manage library staff, including employee names, positions, salaries, and branch assignments.
Book Issuance and Returns: Track the issuance and return of books by customers. Monitor the status of issued books and ensure timely returns.
Branch Management: Maintain information about library branches, including branch numbers, manager assignments, addresses, and contact details.
The project includes various SQL queries and data analysis tasks to extract valuable insights from the library's data. Some of the key queries implemented include: