PHP - Student grade record (CRUD + Login)

Problem Statement

El centro escolar “profe Lennin”, requiere un sistema de control de notas que le permita llevar de una forma ordenada las calificaciones de sus alumnos, los requisitos fundamentales son los siguientes:

• Student registration must be by class and by grade.
• The system must have at least one section at the time of delivery.
• The system must be Scalable in a simple way, in degrees and sections.
• The system must have fields for a single subject at the time of delivery.
• The system must be Scalable to be able to add more subjects per grade.

Data Base (MySQL)

Diagram

Forms

Form to add a new student
The first PHP form to be delivered must allow the user to enroll students, with notes by default with value "0" in the database.

Form to Edit
The second form in PHP to be delivered must allow the user to modify the fields of the enrolled students, create fields, records of new notes and delete fields.

Data query

This Form allows the user to view the marks of an entire section in a complete way, and also calculate the average of marks, the average per student and the average of the class mark.

Login

The system has a session and cookies system that allows you to distinguish between students, teachers and administrator.