Welcome to the Library Management System built entirely using SQL!
This project is designed to manage everything you'd expect in a real-world library — books, customers, employees, branches, and even tracking issued and returned books.
🎓 Academic Project | 💾 SQL-Based | 📊 Relational Database | ✅ Submission-Ready
This SQL project demonstrates how a library system can be structured using a relational database model.
It includes:
- Cleanly structured schemas
- Well-thought-out sample data
- 12 practical SQL queries to retrieve meaningful information
- Screenshots to verify output and ensure correctness
- 📦 6 interrelated tables with foreign key relationships
- 📥 Sample data inserted for testing
- 🔍 Complex queries using
JOIN,GROUP BY,HAVING,WHERE, and subqueries - 📸 Screenshots of query outputs for academic evaluation
- 💡 Follows DBMS principles & good SQL practices
- SQL (MySQL syntax)
- Git & GitHub for version control
- Markdown for documentation
- Local RDBMS like MySQL / XAMPP / phpMyAdmin
- Branch – Info about library locations
- Employee – Staff working at each branch
- Books – List of books with availability and rental price
- Customer – Registered users of the library
- IssueStatus – Tracks which books were issued to which customer
- ReturnStatus – Records the return of issued books
- Available books (title, category, price)
- Employee salaries in descending order
- Books issued with customer names
- Book count per category
- Employees with salary > ₹50,000
- Customers registered before 2022 who haven’t issued books
- Employee count per branch
- Customers who issued books in June 2023
- Books with "history" in the title
- Branches with more than 5 employees
- Branch managers with addresses
- Customers who issued books costing more than ₹25
Each query result is captured and included inside the /screenshots folder to validate the SQL execution.
🔍 Example:
