Supplementary Materials
The supplementary materials provide additional technical details supporting the development and implementation of the Near-Real-Time Class Scheduling System (NRTCSS). These materials include the scheduling validation algorithm, database schema, and system design artifacts to enhance reproducibility and technical clarity.
Supplementary Material 1: ValidateSchedule Algorithm
Provide the detailed pseudocode used for real-time conflict detection in scheduling. This includes validation checks for instructor, room, and section conflicts based on time and day overlap.
Algorithm: ValidateSchedule
Input: New schedule entry (section, instructor, room, day, time)
Output: Conflict status
1. For each existing schedule in the database:
2. If (same day AND overlapping time) then:
3. Check if section is the same → conflict
4. Check if instructor is the same → conflict
5. Check if room is the same → conflict
6. If any conflict detected:
7. Return "Conflict Found"
8. Else:
9. Save schedule entry
10. Return "No Conflict"
Supplementary Material 2: Database Schema and Data Dictionary
This section contains the complete structure of the database, including all tables, attributes, data types, and relationships used in the system.
Figure: databasebuild_1777944411.png
Supplementary Material 3: Entity-Relationship Diagram (ERD)
A high-resolution ERD illustrating the relationships among core entities such as accounts, departments, faculties, schedules, sections, and rooms.
Figure: erd2_1777943254.png
System Interfaces
This section presents key user interface components of the Near-Real-Time Class Scheduling System (NRTCSS), highlighting its functionality and usability.
Figure S1. Login Interface
Displays the user authentication module with role-based access control.
Figure: nrtcsslogindi_1777951212.png
Figure S2. Schedule Plotting Interface
Shows the main scheduling interface where users assign instructors, rooms, and time slots.
Figure: nrtcsscreatene_1777951364.png
Figure S3. Conflict Detection Alert
Illustrates the system’s near-real-time validation mechanism, highlighting detected conflicts during schedule entry.
Figure: nrtcssconflict_1777951425.jpg
Figure S4. Report Generation Interface
Presents generated schedules categorized by instructor, section, and room utilization.
Figure: nrtcsexportsc_1777951477.png
