📚 Smart Library Management System

The Smart Library Management System is a web-based application developed to manage basic library operations in a simple, efficient, and digital manner.
The system allows administrators to manage library book records while enabling students to check book availability through a clean and user-friendly interface.

This project is developed as an academic mini-project with real-world deployment.

---

🌐 Live Project

🚀 Project URL:
https://namma-library.netlify.app/

The application is hosted on Netlify and is accessible on desktop and mobile devices.

---

✨ Features

👩‍🎓 Student Module (Public Access)

• View available library books
• Check book status (Available / Issued)
• Search books using Book ID
• No login required

👑 Admin Module

• Secure admin login system
• Admin-only access to manage book data

---

🛠️ Technologies Used

Frontend

• HTML5
• CSS3
• JavaScript

Backend & Database

• Supabase
  • PostgreSQL Database
  • REST APIs
  • Real-time data synchronization

Deployment

• Netlify – Frontend Hosting
• Supabase Cloud – Backend & Database Hosting

---

🗂️ Database Structure

Students Table

• usn (Primary Key)
• student_name

Books Table

• book_id (Primary Key)
• book_name
• author
• status

---

🔐 Security

• Supabase Row Level Security (RLS) enabled
• Public users: Read-only access
• Admin users: Full CRUD access

---

🚀 Project Highlights

• Fully dynamic web application
• Real-time database updates
• Clean and responsive UI
• Cloud-hosted backend

---

📌 Future Enhancements

• Student login system
• Book issue and return tracking
• Fine management
• Report generation

---

👨‍💻 Developed By

Department of Computer Science & Engineering
The National Institute of Engineering, Mysuru

---

📄 License

This project is developed for educational purposes.