This semester, we modernized our department website’s educational section by migrating from procedural PHP to Laravel framework. The transition was motivated by the need for improved maintainability, security and scalability. The implementation follows the Model-View-Controller (MVC) architectural pattern, enabling efficient data management, real-time synchronization with institutional databases, and enhanced user interaction. Key outcomes include the successful deployment of CRUD (Create, Read, Update, Delete) operations, automated data exports, and a structured approach for future integrations. This study highlights the benefits of modern PHP frameworks in academic environments and outlines planned enhancements for further optimization.

Figure 1: MVC architecture.

Relations between courses and teachers

The system implements structured relationships where each course is assigned one guarantor from the teachers table who maintains oversight responsibility. Multiple teachers can be assigned to deliver individual courses, with actual teaching assignments being managed through a forthcoming timetable module. The system provides comprehensive CRUD operations featuring intuitive forms for creating and updating teacher records. Users can access searchable, paginated listings with sortable columns for viewing data. For deletion, the platform employs soft-deletion via an is_active flag to maintain data integrity. Robust export capabilities allow one-click generation of reports in Excel, CSV and PDF formats. These export functions effectively support administrative reporting and data analysis requirements while ensuring data consistency.

Figure 2: Relational database design highlighting key connections. 

Future development

The next phase will integrate the timetable with the faculty’s scheduling system (e-rozvrh), featuring week-selection options and change request notifications. We will improve the survey system by restricting submissions to active teaching weeks and ensuring proper teacher attribution. The platform will connect to Oracle to automate teaching reports and track graduate career outcomes. Additional statistics and export options will be added. Finally, we plan to develop an API for seamless data exchange with other university systems, enabling efficient timetable management and future integrations. Each upgrade will maintain the system’s reliability while expanding its functionality.

Categories: Projects