Skip to content

Latest commit

 

History

History
117 lines (83 loc) · 4.32 KB

README.md

File metadata and controls

117 lines (83 loc) · 4.32 KB
Raw

Career Management System Database and Frontend

This project is designed to support a Career Management System (CMS), combining a MySQL database and a React frontend. The system analyzes students' skills, projects, academic performance, and other factors to generate tailored reports, scoring these against the requirements of a given company.

Project Structure

Backend

The database schema consists of the following tables:

Table Name Description
academic_performance Records detailed academic performance metrics for each student.
additional_info Stores additional information about students or jobs, such as preferences or extra requirements.
companies Maintains a list of companies participating in the career system.
job_listings Stores details about job openings posted by companies.
job_summary its a view which summarizes the status and statistics for jobs listed in the system.
match_history Tracks the history of job applications and matching between students and jobs.
projects Captures information about projects completed by students.
skills Defines the skills that students can list or jobs can require.
student_academic_summary A view which aggregates academic achievements for each student.
student_skill_summary A view which summarizes the skillsets for each student.
students Core table holding primary details about students registered in the system.

Functions

  • CalculateAcademicScore
  • CalculateProjectScore
  • CalculateSkillScore.re

Procedures

  • CalculateCareerScore
    Calculates using the above functions and returns the suitability score for a student against a specific job.

Frontend

The React frontend provides an intuitive interface for interacting with the CMS. Key features include:

  • Dynamic Data Rendering: Displays students, job listings, and reports in an interactive UI.
  • Form Management: Allows users to input data such as student details, job postings, and academic records.
  • Tailored Reports: Compares student profiles with company requirements and provides a match score.
  • Responsive Design: Ensures compatibility across devices for a seamless user experience.

Key Functionalities

  1. Student Data Management

    • Tracks detailed student information, academic performance, skills, and projects.
    • Supports a comprehensive summary of academic and skill metrics.

  2. Job Matching and Tracking

    • Enables matching students with job listings based on skills and academic profiles.
    • Records the history of job applications and outcomes.

  3. Company Engagement

    • Maintains company profiles and their associated job postings.

  4. Comprehensive Reporting

    • Aggregates data into summaries, aiding decision-making for students and recruiters.

Getting Started

Installation

  1. Clone the Repository
    Clone the project repository from GitHub: 
    git clone 'https://github.com/Roshr2211/Career-Management-System.git'
cd Career-Management-System
  2. Database Setup

Ensure MySQL is installed on your system. Import the database schema:

mysql -u your_username -p career_manage < database/schema.sql
  1. Backend Setup Navigate to the backend directory and install dependencies: 
    npm install
npm install express mysql cors multer
    To start. [Run the frontend simultaneously] 
    npm start
    OR install nodemon 
    npm install nodemon
nodemon server.js
  2. Frontend Setup Open another terminal and navigate to the career directory and install dependencies: 
    npm install
npm install recharts axios
npm run dev

Future Enhancements

AI Integration: Advanced recommendations for students and recruiters.