Student Management

The Student Management feature allows administrators to enroll new students, track their information, and maintain relationships with their parents and assigned classes.

Overview

Student records form the core of the school management system. Each student is linked to a parent and assigned to a class, creating a comprehensive network of relationships within the school.

Key Features

Add new student enrollments with personal information
View all student records in a centralized table
Update student information including name and birthday
Delete student records when needed
Link students to their parents and classes

Student Information Fields

The system tracks the following information for each student:

Sid

number

required

Unique student identifier (auto-generated)

Sname

text

required

Student’s first name

Ssurname

text

required

Student’s last name

Sbirthday

date

required

Student’s date of birth (maximum date: 2023-04-06)

Parent_ID

text

required

Reference to the student’s parent record

Class_ID

text

required

Reference to the student’s assigned class

User Workflows

Add Student
View Students
Update Student
Delete Student

Adding a New Student

To enroll a new student in the system:

Navigate to the Add dropdown menu in the main navigation
Select Student from the dropdown
Fill in the student enrollment form with the following required fields:

<form method="post" action="AddStudent.php">
    <label for="Sname">Student Name:*</label>
    <input type="text" required name="Sname"><br /><br />
    
    <label for="Ssurname">Student Lastname:*</label>
    <input type="text" required name="Ssurname"><br /><br />
    
    <label for="Sbirthday">Student Birthday:*</label>
    <input type="date" required max="2023-04-06" name="Sbirthday" /><br /><br />
    
    <label for="Parent_ID">Parent ID:* </label>
    <input type="text" required name="Parent_ID"><br><br>
    
    <label for="Class_ID">Class ID:*</label>
    <input type="text" required name="Class_ID"><br>
    
    <input type="submit" name="submit">
</form>

Click the Submit button to create the student record

You must have a valid Parent ID and Class ID before adding a student. Create parent and class records first if they don’t exist.

Viewing All Students

To view the complete list of enrolled students:

Click the View dropdown in the navigation bar
Select Student to display the student table

The student table displays the following columns:

Column	Width	Description
Student ID	150px	Unique identifier
Student First Name	250px	First name
Student Last Name	250px	Last name
Student Birthday	120px	Date of birth
Student’s Parent ID	100px	Linked parent
Student’s Class ID	100px	Assigned class

SQL Query Used:

SELECT Sid, Sname, Ssurname, Sbirthday, Parent_ID, Class_ID 
FROM Student1

Updating Student Information

To modify an existing student’s information:

Go to the Uptade dropdown menu
Select Student
Enter the student details in the update form:

<form method="post" action="UptadeStudent.php">
    <label for="Sid">Student ID:</label>
    <input required type="text" name="Sid" /><br /><br />
    
    <label for="Sname">Student Name:</label>
    <input required type="text" name="Sname"><br /><br />
    
    <label for="Ssurname">Student Surname: </label>
    <input required type="text" name="Ssurname"><br><br>
    
    <label for="Sbirthday">Student's New Birthday</label>
    <input type="date" max="2023-04-06" name="Sbirthday" />
    
    <input type="submit" name="submit">
</form>

Click Submit to save the changes

You must provide the Student ID to identify which record to update.

Deleting a Student Record

To remove a student from the system:

Navigate to Delete > Student
Enter the Student ID in the deletion form:

<form method="post" action="DeleteStudent.php">
    <label>Type ID of student to be deleted.</label>
    <input type="text" name="Sid"><br><br>
    <input type="submit" name="submit" value="Delete.">
</form>

Click the Delete button to permanently remove the record

Deleting a student is permanent and cannot be undone. Ensure you have the correct Student ID before proceeding.

Relationships

Parent Relationship

Each student must be linked to a parent record via the Parent_ID field. This establishes the parent-child relationship in the system.

Students cannot be added without a valid Parent ID
Multiple students can share the same Parent ID (siblings)
Refer to the Parent Management documentation for creating parent records

Class Assignment

Students are assigned to classes through the Class_ID field, which determines their classroom placement and teacher.

Every student must be assigned to a class
The Class ID links to the Class table, which contains teacher assignments
See Class Management for more information

Database Structure

The student data is stored in the Student1 table with the following schema:

Table: Student1
Fields:
  - Sid (Primary Key, Auto-increment)
  - Sname (VARCHAR, Required)
  - Ssurname (VARCHAR, Required)
  - Sbirthday (DATE, Required)
  - Parent_ID (Foreign Key to Parent table)
  - Class_ID (Foreign Key to Class table)

Best Practices

Data Entry

Always verify parent and class records exist before adding students
Double-check birthdates for accuracy
Use consistent naming conventions

Record Management

Keep student records up to date
Remove graduated students or archive them
Maintain accurate parent linkages

Data Validation

Birthdate cannot be after April 6, 2023
All fields except the auto-generated ID are required
Parent and Class IDs must reference existing records

Security

Only authorized administrators should access student data
Protect sensitive student information
Follow data privacy regulations

Get Started

Core Features

User Guide

Overview

Key Features

Student Information Fields

User Workflows

Adding a New Student

Viewing All Students

Updating Student Information

Deleting a Student Record

Relationships

Database Structure

Best Practices

Data Entry

Record Management

Data Validation

Security

Build docs developers (and LLMs) love

Get Started

Core Features

User Guide

Documentation Index

​Overview

Key Features

​Student Information Fields

​User Workflows

​Adding a New Student

​Viewing All Students

​Updating Student Information

​Deleting a Student Record

​Relationships

​Database Structure

​Best Practices

Data Entry

Record Management

Data Validation

Security

Build docs developers (and LLMs) love

Overview

Student Information Fields

User Workflows

Adding a New Student

Viewing All Students

Updating Student Information

Deleting a Student Record

Relationships

Database Structure

Best Practices