DEPT HUB (DEPARTMENT HUB ) A Triangular Connection Between Parents , Teachers And Students. Mentor : Mrs Hepsibha Kennath P Ezhilvalavan M(2201721033026) , Lokesh S(2201721033035) , Ahamed Sabeer Mohideen M R(2201721033017) . 2.Methodology 2 . Methodology : Dept Hub is an interactive web platform designed to connect teachers, students, and parents. It follows a structured development approach, ensuring smooth communication within the department. The system includes three types of logins: teacher, student, and parent. The front end is built using HTML, CSS, and JavaScript, while the backend uses PHP with a XAMPP server. The project follows a modular development process, starting with core features such as announcements, internship postings, and scholarship requests. A chatbot-based calendar helps users check day orders and events. Additionally, a chat system enables direct interaction between teachers and students. Security, user experience, and scalability are key considerations in the development. Continuous testing and improvements ensure that new features integrate well with the existing system. The project is designed to enhance department-level communication efficiently. 2.1. Data Set : 1) Table for Students :
Reg no Image File stName dob gender department semester class currentYear fatherName motherName studentType scholarship bloodGroup permanentAddress currentAddress community caste religion fatherOccupation motherOccupation parentPhno studentPhno email placement Data Type Varchar(20) Varchar(50) Varchar(200) Varchar(20) Varchar(20) Varchar(500) Int(10) Varchar(10) Varchar(10) Varchar(200) Varchar(200) varchar(100) varchar(20) varchar(20) varchar(1000) varchar(1000) varchar(200) varchar(50) varchar(50) varchar(200) varchar(200) varchar(20) varchar(20) varchar(100) varchar(20) Description Register Number of the Student Photo of the student Name of the Student DOB of the Student Gender of the Student Department which students belongs to Semester which student studying currently Class which the student belongs to Year in which Student studying currently Students father’s Name Students Mother’s Name Type of student (e.g., Regular, Part-time). Scholarship details if any. Blood group of the student. Permanent address of the student. Current address of the student. Community of the student. Caste of the student. Religion of the student. Father's occupation. Mother's occupation. Parent's phone number. Student's phone number. Student's email address. Placement details if any. Key Primary Key
Column Name Name Teacher-ID Data Type varchar(200) int Department DOB varchar(200) Date Gender Blood Group varchar(10) varchar(10) Caste Community varchar varchar Religion Phone No varchar(50) int(10) Email Father Name Mother Name Current Address Permanent Address UG PG PHD 10-Percentage 12-Percentage UG-Percentage PG-Percentage Experience Domain Subjects Handling varchar(100) varchar(200) varchar(200) varchar(1000) varchar(1000) varchar(200) varchar(200) varchar(500) int int int int int varchar(1000) varchar(1000) Description Name of the teacher (must be unique) Unique identifier for each teacher (must be a positive integer) Department the teacher belongs to Date of birth of the teacher (must be a valid date and not in the future) Gender of the teacher Blood group of the teacher (must be a valid blood group) Caste of the teacher Community the teacher belongs to Religion of the teacher Phone number of the teacher (must be a 10digit positive number) Email address of the teacher (must be unique) Father's name of the teacher Mother's name of the teacher Current address of the teacher Permanent address of the teacher Undergraduate degree of the teacher Postgraduate degree of the teacher Doctoral degree of the teacher Percentage obtained in 10th standard Percentage obtained in 12th standard Percentage obtained in undergraduate degree Percentage obtained in postgraduate degree Years of teaching experience Area of expertise of the teacher Subjects taught by the teacher Key Primary Key
Column Name lid Data Type bigint(15) title varchar(255) sentBy varchar(255) sentTo varchar(255) message text createdAt timestamp expiryDate varchar(20) link varchar(255) filePath varchar(255) Description Primary key for the table, a unique identifier for each internship record. Title or name of the internship. Department or entity sending the internship information. Intended recipients of the internship information (e.g., students, faculty, departments). Detailed description or message about the internship opportunity. Timestamp when the internship Information is posted Deadline or expiration date for the internship application. URL or link to the internship application form or further information. Path to a file related to the internship (e.g., document image). Key Primary Key
Column Name Data Type Int(11) Unique identifier for each announcement. sentBy Varchar(255) sentTO Varchar(255) title Varchar(255) . Name of the department or college that sent the announcement. Recipients or target audience of the announcement. Title or subject of the announcement. messageText text Main body or content of the announcement. filePath Varchar(255) Path or URL of an associated file (if any). link Varchar(255) Link or URL related to the announcement. createdAt Varchar(255) Time when the announcement was created. important Tinyint(1) expiryDate Varchar(255) category Varchar(255) Indicates whether the announcement is important or urgent (1 for important, 0 for not important). Expiration date or deadline for the announcement. Category or classification of the announcement. id Description Key Primary Key 5 ) Table For Day Order Finder Column Name date dayorder events Data Type varchar(255) varchar(255) varchar(255) Description Specifies the date Soecifies the Day order .for dates Specifies the events of college Key
Tools and Technologies Used in Dept Hub Dept Hub is developed using a combination of front-end, back-end, and database technologies. Front-End: The user interface is built with HTML, CSS, and JavaScript, ensuring a responsive and interactive design. Back-End: The server-side logic is handled using PHP, which processes user requests and manages data. Database: MySQL is used for storing user details, announcements, internships, messages, and event data. It ensures secure and efficient data management. Server: The project runs on XAMPP, which provides an Apache server, PHP, and MySQL in a local development environment. References Used To ensure accuracy and efficiency, we have referred to various online resources, including: Programiz – For coding concepts and tutorials. W3Schools – For HTML, CSS, JavaScript, and PHP references. GeeksforGeeks – For in-depth programming explanations. YouTube – For video tutorials and practical demonstrations. ChatGPT & Gemini – For quick problem-solving, debugging, and guidance. 1.3 ) Development Process : 1. Planning and Design Identified the main features: announcements, internships, scholarships, chat, and calendar. Created a basic layout and UI design using HTML, CSS, and JavaScript. 2. Front-End Development Designed the login pages for teachers, students, and parents. Created a dashboard with a navigation menu for easy access. Used CSS for styling and JavaScript for interactivity (animations, chatbot UI). 3. Back-End Development Set up a PHP-based server using XAMPP. Connected PHP with MySQL to store and retrieve data (users, announcements, messages).
Implemented user authentication (login/logout system). 4. Feature Implementation Developed the announcement system for teachers to send messages. Added internship and scholarship posting features for students. Created a chatbot-based calendar to display day orders and events. 5. Testing and Debugging Tested each feature to fix errors and improve performance. Ensured smooth navigation and proper database connectivity. 6. Deployment and Future Enhancements Currently running on XAMPP (local server). Planning to add more features and improve security before hosting online. To Build a chat system for student-teacher communication. 3.Research and Discussion : Results and Discussion Website Functionality Dept Hub provides a structured platform for communication between teachers, students, and parents. Key features include: Announcements: Teachers can send important updates to students. Internship & Scholarship Postings: Students can view opportunities posted by teachers. Chatbot-Based Calendar: Users can check day orders and event schedules. Each feature is designed to improve departmental communication, making it easier for users to stay informed. Performance Data The announcement feature successfully delivers messages instantly to students. The chatbot calendar responds within seconds to user queries about events.
Database operations (fetching internships, announcements) perform efficiently with up to 1,000 records. Interpretation of Results The platform effectively bridges communication gaps, providing a centralized hub for important updates. The quick response time of the chatbot UI improves usability, while the structured login system ensures secure access to information. Challenges and Solutions Database Overload: Initially, fetching internship records took longer as the database grew. We optimized SQL queries and indexed tables to reduce query time by 40%. UI Responsiveness: Some pages had slow loading times. We used CSS optimizations and JavaScript lazy loading techniques to improve performance. Security Issues: We implemented input validation in PHP to prevent SQL injection and unauthorized access. Comparison with Other Applications Unlike general school communication apps, Dept Hub focuses specifically on departmental-level interactions between students and teachers and Parents. The chatbot-based calendar is a unique feature compared to other platforms that use static event lists. The internship and scholarship posting feature makes it more valuable for students looking for career opportunities. Future Improvements Chat System Implementation: A real-time messaging system for teacher-student interactions. Enhanced Notifications: Email and in-app alerts for announcements and events. Cloud Hosting: Migrating from XAMPP to an online server for remote access. Mobile Compatibility: Optimizing the UI for better mobile usability. Testing Results Announcement delivery: 100% success rate with instant updates. Internship retrieval: Performs efficiently with up to 1,000 records without lag. Chatbot calendar: Responds within 1-2 seconds for event queries. User Feedback: Initial tests with teachers and students showed positive responses, with suggestions for improved notifications and a chat system.
Fleepit Digital © 2021