Project Title: Automated University Time Table Management System

Technologies Used:

• Node.js
• Express.js
• MySQL

Project Description:

Implemented a comprehensive timetable management system for the CSE department, utilizing Node.js, Express.js, and MySQL. The system allows efficient administration of faculty, courses, classrooms, and periods, ensuring dynamic adaptability to departmental needs.

Key Features:

1. Admin Dashboard
• Displayed department statistics, including the number of lecturers, subjects, rooms, and periods.
2. Admin Panel
• Faculty Management:
• Add, delete, and edit faculty information, including faculty ID and name.
• Course Management:
• Add, delete, and edit subject information, including subject ID and title.
• Classroom Management:
• Add, delete, and edit room information, including room ID, department name, and capacity.
• Period List Management:
• Add, delete, and edit period information, including period ID, start time, and end time.
• Assignment Management:
• Add, delete faculty assignments, specifying faculty name, subject title, room ID, and period ID.
3. Timetable Generation
• Implemented an intelligent algorithm for conflict-free timetable generation.
• Enabled the generation of timetables based on specified criteria, such as room ID.
4. User-Friendly Interface
• Designed an interactive admin panel for easy input and retrieval of timetable information.

Installation

1. Install NodeJS (https://nodejs.org/en/)
2. Go to the project folder directory then open the terminal.
3. Type "npm install" in your terminal to install the npm dependencies and libraries.
4. Type "nodemon app.js" to run the project
5. Finally, type "localhost:3000" in your browser

Note: Running MySQL and Apache using XAMPP

Before running the project, make sure you have XAMPP installed for managing MySQL and Apache.

1. Open the XAMPP Control Panel.
2. Start the Apache and MySQL modules.
3. Ensure that MySQL is running, as the project relies on it for database operations.
4. You can now proceed with running the Node.js application using the steps mentioned above.

Screenshots

Admin Login

Dashboard

Faculty Management

Generated Timetable for Room 3CSEB