🎓 ScholarKit

ScholarKit is a full-stack, multi-vendor e-commerce platform engineered specifically to streamline the procurement of school uniforms and educational essentials. It bridges the gap between authorized uniform vendors and parents, providing a centralized and secure shopping experience.

Built with a focus on data integrity, scalability, and performance, ScholarKit demonstrates advanced Relational Database Management System (DBMS) concepts. The backend handles complex transaction processing and business logic natively in SQL, while the frontend delivers a sleek, modern, and highly responsive user interface built with React 19 and Tailwind CSS.

• Advanced Database Design: 3NF Normalization, Vertical Partitioning, and materializing complex product feeds using Views and Subqueries.
• Transaction Management: ACID-compliant operations utilizing MySQL Stored Procedures with automatic ROLLBACK handling for atomic checkout flows.
• Full-Stack Architecture: RESTful API design with Node.js/Express and a scalable React frontend managed by the Context API.
• Secure Authentication & Authorization: JWT-based stateless authentication paired with secure password hashing (bcryptjs) for separate Parent and Vendor roles.
• Cloud Infrastructure & Integrations: Direct integration with Cloudinary for scalable image hosting and Razorpay for secure payment processing.

• Multi-Vendor Ecosystem: Dedicated seller dashboards empower authorized uniform vendors to manage their inventory, media galleries, and sales analytics. Simultaneously, parents enjoy a unified storefront to purchase required apparel and gear.
• Automated Inventory & Price Auditing: Database-level Triggers (BEFORE UPDATE, AFTER UPDATE) automatically log price changes and generate low-inventory alerts without relying on application-layer logic.
• Complex Analytics via SQL: Utilizing Common Table Expressions (CTEs) and Window Functions (ROW_NUMBER()) to dynamically compute leaderboards, such as the top-selling products per school.
• Secure Media Management: Cloudinary integration ensures vendor product images are compressed, optimized, and securely served across the platform.

• Core: React 19, Vite
• Routing & State: React Router v7, React Context API
• Styling: Tailwind CSS 3.4, Framer Motion
• Icons & Network: Lucide React, Axios

• Server Environment: Node.js, Express.js
• Database Engine: MySQL 8.0+
• Authentication: JSON Web Tokens (JWT), bcryptjs
• Services: Cloudinary SDK (Media), Razorpay SDK (Payments)

ScholarKit relies on the DBMS engine not just for storage, but for complex business logic, ensuring absolute consistency at the data level:

The frontend is built for performance and maintainability, employing a clean structure:

• src/pages/: Top-level views (e.g., AdminDashboard.jsx, SellerDashboard.jsx, Home.jsx) that manage data fetching.
• src/components/: Reusable, consistent UI components (buttons, modals, product cards) adhering to DRY principles.
• src/context/: Global state management (Context API) for auth, cart, and preferences without prop-drilling.
• src/utils/: Helper functions, formatters, and API client wrappers.

A RESTful API built with Express, providing secure endpoints to interact with the database, process payments, and manage media.

Follow these instructions to get the ScholarKit application running on your local machine.

Ensure you have the following installed:

• MySQL 8.0+
• Node.js (v16 or higher)
• Cloudinary Account (for image hosting)
• Razorpay Account (for payments)

From the project root, execute the SQL and seed scripts to initialize the database:

# Wipe existing demo database (if any)
mysql -u root -p < scripts/demo_wipe.sql

# Preload the schema, baseline views, triggers, and functions
mysql -u root -p < scripts/demo_preload.sql

# Apply the v2 Migration (Discounts, Recommendations, Procedures)
mysql -u root -p < scripts/migration_v2.sql

# Seed the database with sample data (users, sellers, products)
node scripts/demo_seed.js

Navigate to the backend directory, install dependencies, and setup your .env:

cd backend
npm install

Create a .env file in the backend directory:

PORT=5000
DB_HOST=localhost
DB_USER=your_mysql_username
DB_PASSWORD=your_mysql_password
DB_NAME=scholarkit
JWT_SECRET=your_jwt_secret

# Cloudinary Config
CLOUDINARY_CLOUD_NAME=your_cloud_name
CLOUDINARY_API_KEY=your_api_key
CLOUDINARY_API_SECRET=your_api_secret

# Razorpay Config
RAZORPAY_KEY_ID=your_key_id
RAZORPAY_KEY_SECRET=your_key_secret

Start the backend server:

npm start
# or use nodemon for development:
# npx nodemon server.js

Open a new terminal, navigate to the frontend directory, install dependencies, and start the development server:

cd frontend
npm install
npm run dev

Contributions, issues, and feature requests are welcome!

This project is licensed under the ISC License.

• React & React Router
• Tailwind CSS
• MySQL 8.0 Reference Manual
• Lucide React Icons
• Cloudinary API Documentation
• Razorpay Developer Docs