Libraria - Full-Stack Library Management System

A premium, feature-rich Library Management System built with the PERN-style stack (MySQL, Express, Vanilla JS). This project is designed to demonstrate advanced SQL concepts for academic projects.

🚀 Getting Started

1. Database Setup

1. Open your MySQL client (XAMPP/MySQL Workbench).
2. Run the code in database/schema.sql to create the database, tables, views, triggers, and procedures.
3. (Optional) Run database/seeds.sql to populate sample data.

2. Backend Setup

1. Navigate to the backend/ directory.
2. Install dependencies:

   npm install

3. Update .env with your MySQL credentials.
4. Start the server:

   npm start

3. Frontend Setup

1. Open frontend/index.html in your browser.
2. Ensure the backend server is running on http://localhost:5000.

🛠️ Features

• Modern UI: Glassmorphism design with responsive layouts.
• Dynamic Catalog: Fetch and filter books in real-time.
• Automated Inventory: SQL triggers handle book stock adjustments automatically.
• Safe Transactions: Book issuing is wrapped in SQL transactions for data integrity.
• Viva Documentation: Detailed SQL_CONCEPTS.md included.

📂 Project Structure

• backend/: Node.js + Express API server.
• frontend/: HTML, CSS, and Vanilla JS UI.
• database/: All SQL scripts and design files.
• SQL_CONCEPTS.md: Comprehensive explanation of SQL features used.

🎓 SQL Concepts Demonstrated

• DDL: CREATE, ALTER, DROP
• DML: INSERT, UPDATE, DELETE
• JOINs: INNER & LEFT JOINs
• Views: Virtual tables for active availability
• Triggers: Automation of stock count
• Cursors: Iterating through low-stock items
• Transactions: Ensuring ACID properties during book issuance
• Normalization: 3NF database design