Design and Implementation of Online Management System for Students' Fourth Class Credits

. Since the concept of the Fourth Class (Comprehensive quality ability teaching) has been presented, the results of the Fourth Class have been enormous. How to manage information informatization is an urgent problem to be solved. This paper uses the mature management system technology to informatize the Fourth Class management.


Introduction
The Fourth Class (Comprehensive quality ability teaching) of students is a new concept based on the first (Classroom teaching), second (Laboratory teaching) and third (practical teaching) class of students. The Fourth Class of students aims to help students build strong practical ability and increase the conversion rate of knowledge to the results. The Fourth Class of students has the same status as class teaching, and its credits will affect the graduation of students. The Fourth Class encourages students to take an active part in activities and hone themselves. Correspondingly, the record of student participation in the activity and the status of credits are important materials for studying and guiding students in the Fourth Class. However, traditional management methods have numerous problems, such as the lack of student activity records, the confusion of credits, the loss and damage of paper materials, and the opacity of credit information. Therefore, informational means is needed in order to manage the Fourth Class of students. This paper uses the Apache + PHP + MySQL [1] and MVC architecture [2] to develop the Fourth Class management system for students, and realizes the transformation from traditional manual management to informationization.
2 Analysis and design of online management system for students' Fourth Class credits

System requirements analysis
The Fourth Class aims to use the extracurricular activities that students love to develop students' professional strengths, develop students' communication expression, organization and coordination, leadership and team spirit, and cultivate students' concern for the country, caring for the society, caring for the people's social responsibility and loving labor. The Fourth Class is divided into three compulsory subjects and nine elective subjects. The Fourth Class encourages students to actively participate in the acquisition of credits through the establishment of activities, competitions, social projects, entrepreneurial projects, art projects, research projects and other practical content.
With the increase in the number of participants in The Fourth Class, the need for student participation analysis, and the management needs of student credits, traditional manual management has revealed major drawbacks. Traditional manual management has the following disadvantages compared to online management systems: The student's historical participation activities are unknown.
(2) The degree of information transparency is too low (3) Information sharing between departments is too poor (4) Historical data is difficult to sort out and analyze (5) Paper documents are difficult to save, easy to lose (6) Manual finishing time and labor, easy to make mistakes (7) Students are difficult to feedback errors in management Based on the above drawbacks, the Fourth Class management work needs to utilize existing computer resources, utilize the convenience of the network, and develop an online management system based on the existing mature technology [3] to simplify work, improve efficiency, and form a complete and powerful Management system.

System goal
This system is designed for students' Fourth Class credit management. The main objectives are: (1) Strong management ability for credit certification documents (2) History tracking ability of students participating in activities (3) Management ability of student credits (4) Processing of student feedback information (5) Ability to manage student information· (6) Ability to manage student activities (7) Ability to organize student's historical information (8) Different users have different permissions due to the confidentiality of data (9) The system is stable, safe and reliable

System function structure
According to the system analysis, the system adopts the MVC architecture, and the student application, administrator application, and super administrator application is established on this architecture.

Database
On the selection database, the combination of PHP and MySQL is a more common combination [4] in the industry. PHP and MySQL have a tacit understanding and are easy to use. More importantly, MySQL is recognized as an open source database with security, ease of use, efficiency and low cost. The database used in this system is MySQL. In order to have higher compatibility with the system, PDO is used to connect to the database.

Database concept design
According to the above requirements analysis and system analysis, the E-R diagram of the entity relationship of the student's Fourth Class online management system is planned out.

Database physical structure design
According to the above database concept design, we created the fourManagementSystem in the database system, which contains 10 data tables, as shown in the figure： To simplify the description, only the main data tables are explained.
The Activity Table contains the activity name, activity number, activity credits, credit type, activity attribution organization, maximum number of activities, activity start time, activity end time, activity registration start time, activity registration end time, activity content, and activity registration number. The activity number is the primary key. Its structure is as follows: Figure 10. Activity Table   The Administrator Table includes the administrator name, administrator number, administrator password, department, mobile phone number, and responsible year level, where the administrator number is the primary key. Its structure is as follows: Figure 11. Administrator Table   The Credits Table includes the student number, the number of credits, the type of credit, the number of the person in charge of the activity, the number of the activity, the number of the certification document, and the type of activity. Its structure is as follows:  Table   The student Information Table includes the student's name, student ID number, student password, academic department, student major, mobile phone number, administrator number, student class, and student grade, among which the student number is the primary key. Its structure is as follows: The Fourth Class Credit Online Management System uses the MVC architecture and builds applications on this architecture.
The system architecture is as follows: (1) Routing base class: The user request is processed and sent to the controller of the corresponding application.
(2) Model layer base class, view layer base class and controller base class: Their processing of data, operation of the database and view rendering of the result are inherited and extended by each application, and the corresponding functions are added.
(3) Database base class, query base class: The database base class is responsible for accessing the database using different database accounts according to the permissions of the application. The database query base class encapsulates commonly used SQL statements into member functions of the class.
(4) File base class: The file is operated according to the user's permission.
(5) Log base class: Generate corresponding log information when an event occurs.
(7) Analytical base class: Statistical analysis of student historical information, providing a download interface for raw data.
(8) System startup class: After the web server receives the request. It automatically loads the corresponding application and base class.
The system running process is as follows: User makes a request The verification base class checks if the user request is legal and secure.
The system startup base class starts the system, loads each base class, and loads the system configuration file.
The router base class decomposes user requests, separating applications, operations, and data The router base class determines if the application exists.

Application implementation
Due to the large amount of project code, it cannot be fully displayed. This article uses only the simpler super administrator application as an example to demonstrate how to implement the specific application of the system. The super administrator application is a system application for management of Administrator. After the user logs in to the system through the super administrator account, the existing administrator can be managed or a new administrator can be added. Application view layer uses Google's Material Design Lite framework to list only the necessary code for ease of description.