🎓 Student Placement & Internship Tracker

A full-stack MERN application for managing student placements, internships, skills, and recruitment data with role-based dashboards for students and faculty.

🌐 Live Demo

Frontend: https://mongodb-r8l3.vercel.app/
Backend API: https://mongodb-ihbj.onrender.com

✨ Features

Student Portal

• 🔐 Secure registration and JWT-based authentication
• 📊 Personal dashboard with analytics
• 💼 Manage skills, certifications, and experience
• 📅 Track interview schedules and outcomes
• 🎯 Apply for internships and placements
• 📈 View placement statistics

Faculty Dashboard

• 👥 View all registered students
• 📋 Manage recruiters and job postings
• 📊 Real-time placement analytics
• 🔍 Track student progress
• 📝 Query management system
• 📈 Generate reports

Admin Features

• 🏢 Recruiter management (add, edit, delete)
• 📅 Interview scheduling
• 💼 Placement record management
• 🎓 Internship opportunity posting
• 📊 Comprehensive analytics

🛠️ Tech Stack

Frontend

• React.js - UI library
• React Router - Client-side routing
• Axios - HTTP requests
• CSS3 - Styling with glassmorphism effects

Backend

• Node.js - Runtime environment
• Express.js - Web framework
• MongoDB - NoSQL database
• Mongoose - ODM for MongoDB
• JWT - Authentication
• bcrypt.js - Password hashing

Deployment

• Frontend: Vercel
• Backend: Render
• Database: MongoDB Atlas

📂 Project Structure

placement-tracker/ ├── Backend/ │ ├── controllers/ # Business logic │ │ ├── authController.js │ │ ├── studentController.js │ │ ├── facultyController.js │ │ ├── skillController.js │ │ ├── interviewController.js │ │ ├── placementController.js │ │ ├── internshipController.js │ │ └── recruiterController.js │ ├── models/ # Database schemas │ │ ├── User.js │ │ ├── Student.js │ │ ├── Faculty.js │ │ ├── Skill.js │ │ ├── Interview.js │ │ ├── Placement.js │ │ ├── Internship.js │ │ └── Recruiter.js │ ├── routes/ # API endpoints │ ├── middleware/ # Auth & validation │ ├── config/ # Configuration │ └── server.js # Entry point │ ├── Frontend/ │ ├── public/ │ ├── src/ │ │ ├── components/ # React components │ │ ├── pages/ # Page components │ │ ├── services/ # API service layer │ │ └── App.js │ └── package.json │ └── README.md

🚀 Getting Started

Prerequisites

• Node.js (v18.x or higher)
• MongoDB Atlas account
• npm or yarn

Installation

1. Clone the repository git clone https://github.com/Divya07-22/mongodb.git cd mongodb

2. Backend Setup cd Backend npm install

Create .env file echo "MONGODB_URI=your_mongodb_connection_string" > .env echo "JWT_SECRET=your_jwt_secret_key" >> .env echo "PORT=5000" >> .env

Start backend server npm start

3. Frontend Setup cd Frontend npm install

Start frontend development server npm start

The application will be running at:

• Frontend: http://localhost:3000
• Backend: http://localhost:5000

📡 API Endpoints

Authentication

• POST /api/auth/register - Register new user
• POST /api/auth/login - User login

Students

• GET /api/students - Get all students
• GET /api/students/:id - Get student by ID
• PUT /api/students/:id - Update student
• DELETE /api/students/:id - Delete student

Skills

• POST /api/skills - Add skill
• GET /api/skills/student/:usn - Get student skills
• DELETE /api/skills/:id - Delete skill

Placements

• POST /api/placements - Add placement
• GET /api/placements - Get all placements
• GET /api/placements/student/:usn - Get student placements

Interviews

• POST /api/interviews - Schedule interview
• GET /api/interviews/student/:usn - Get student interviews
• PUT /api/interviews/:id - Update interview status

Internships

• POST /api/internships - Add internship
• GET /api/internships - Get all internships
• GET /api/internships/student/:usn - Get student internships

🔐 Environment Variables

Backend (.env)

MONGODB_URI=mongodb+srv://username:password@cluster.mongodb.net/placementTracker JWT_SECRET=your_secret_key_here PORT=5000

Frontend (.env)

REACT_APP_API_URL=https://mongodb-ihbj.onrender.com/api

🎨 Key Features Demonstrated

Authentication & Authorization

• JWT-based secure authentication
• Role-based access control (Student/Faculty)
• Password hashing with bcrypt
• Protected routes

Database Design

• Normalized MongoDB schemas
• Referential integrity with student USN
• Efficient data relationships
• Indexed queries for performance

Frontend Architecture

• Component-based React design
• Centralized API service layer
• LocalStorage for session management
• Responsive UI with glassmorphism

Deployment

• Continuous deployment from GitHub
• Environment variable management
• Production-ready build optimization
• CORS configuration

📊 Database Schema

User

• email, password (hashed), role (student/faculty)

Student

• studentname, usn (unique), email, phone, department, year
• Links to Skills, Interviews, Placements, Internships

Skill

• student (USN), skillName, proficiency, yearsOfExperience

Interview

• student (USN), company, position, date, status

Placement

• student (USN), company, position, package, offerDate

Internship

• student (USN), company, position, duration, startDate

🤝 Contributing

1. Fork the repository
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

📝 License

This project is open source and available under the MIT License.

👨‍💻 Author

Divya V

• GitHub: @Divya07-22
• Project Link: https://github.com/Divya07-22/mongodb

🙏 Acknowledgments

• Built with MERN stack
• Deployed on Vercel & Render
• Database hosted on MongoDB Atlas

---

⭐ Star this repository if you find it helpful!

Live Demo: https://mongodb-r8l3.vercel.app/