This project is a relational database designed to support the efficient management of academic, administrative, and personal data within a school. It includes structured tables to represent key entities such as students, teachers, classes, subjects, grades, and guardians, enabling streamlined access to information and minimising redundancy.
Objectives:
Store and manage personal data of students, teachers, and staff
Track class enrolments and subject allocations
Record student performance and attendance
Ensure data integrity and consistency through relational links
Allow integration with external tools (e.g., web apps, reports, etc.)
Relationships:
Each student is linked to a class
Each teacher can teach multiple subjects
A subject can be taught in multiple classes
Enrolments track which students are taking which subjects
Grades are linked to enrolments
Technologies Used:
MySQL/MariaDB via phpMyAdmin (XAMPP)
ER Modelling for relationship visualisation
Structured Query Language (SQL) for data manipulation…This project is a relational database designed to support the efficient management of academic, administrative, and personal data within a school. It includes structured tables to represent key entities such as students, teachers, classes, subjects, grades, and guardians, enabling streamlined access to information and minimising redundancy.
Objectives:
Store and manage personal data of students, teachers, and staff
Track class enrolments and subject allocations
Record student performance and attendance
Ensure data integrity and consistency through relational links
Allow integration with external tools (e.g., web apps, reports, etc.)
Relationships:
Each student is linked to a class
Each teacher can teach multiple subjects
A subject can be taught in multiple classes
Enrolments track which students are taking which subjects
Grades are linked to enrolments
Technologies Used:
MySQL/MariaDB via phpMyAdmin (XAMPP)
ER Modelling for relationship visualisation
Structured Query Language (SQL) for data manipulationWW…