Supply-Chain-Management-CS3043

A Comprehensive Supply Chain Management Database

Introduction

The Supply Chain Management System is a comprehensive solution designed to optimize and manage the distribution of products via railway and truck transportation. It provides tools to efficiently handle orders, delivery schedules, and workforce assignments for a company that utilizes the railway system for product distribution.

Features

• Order Management: Allows customers to place orders.
• Railway System Integration: Manages the allocation of train capacity for product transportation.
• Truck Scheduling: Assigns drivers and driver assistants to delivery routes and ensures compliance with working hour constraints.
• Reporting and Analytics: Provides various reports for monitoring and analytics of the platform, including sales reports, item statistics, route details, and workforce hours.
• Database Management: Utilizes MySQL for database storage and incorporates procedures, functions, and triggers to maintain ACID properties.

Technologies Used

• Backend: Express.js
• Database: MySQL

Database Schema

ER Diagram is on the seperate PDF

Getting Started

To get started with the project, follow these steps:

1. Clone this repository.
2. Install the necessary dependencies by running npm install.
3. Set up the MySQL database and schema.
4. Configure the database connection in the project.
5. Run the server using npm start.