Academic Course Planner

This project is a web-based application designed to help students plan their academic courses. It allows students to view course prerequisites, plan their semesters, and track their academic progress. The application also includes an admin panel for managing students, courses, and other resources.

Technologies Used

• Frontend: React, React Router, Reactflow
• Backend: Node.js, Express.js
• Database: MySQL
• Authentication: JSON Web Tokens (JWT)

Project Structure

The project is divided into two main parts:

• frontend: Contains the React application.
• backend: Contains the Node.js and Express.js server.

Getting Started

To get a local copy up and running, follow these simple steps.

Prerequisites

• Node.js and npm installed on your machine.
• MySQL installed on your machine.

Installation

1. Clone the repo

   git clone https://github.com/your-username/your-repository-name.git

2. Set up the database
   • Create a new MySQL database.
   • Import the academic_planner.sql file to set up the database schema.
   • Import the mock_data_dbms.sql file to populate the database with mock data.
3. Set up the backend
   • Navigate to the backend directory:

     cd backend

   • Install NPM packages:

     npm install

   • Create a .env file in the backend directory and add the following environment variables:

     DB_HOST=your-db-host
     DB_USER=your-db-user
     DB_PASSWORD=your-db-password
     DB_NAME=your-db-name
     JWT_SECRET=your-jwt-secret
     

4. Set up the frontend
   • Navigate to the frontend directory:

     cd ../frontend

   • Install NPM packages:

     npm install

Running the Application

1. Start the backend server
   • Navigate to the backend directory and run:

     npm start

2. Start the frontend development server
   • Navigate to the frontend directory and run:

     npm start

The application will be available at http://localhost:3000.