Database for school
Amorim Figueiredo da Costa Caculo
Published
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.)
| Table | Description |
|---|---|
students | Stores personal and academic details of each student |
teachers | Holds information about teaching staff |
classes | Represents school classes or groups (e.g., 10th A) |
subjects | Subjects taught in the institution (e.g., Maths, English) |
enrolments | Connects students to classes and subjects |
grades | Records marks/grades assigned to students |
guardians | Data about the legal guardians or parents of each student |
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