Vanilla MySQL doesn't support any sort of referential integrity. You can use "InnoDB" tables (here) that add that functionality. If you're in a shared hosting ...

This project delivers an enterprise-grade academic management platform for higher education institutions, enabling comprehensive lifecycle management of students, courses, and enrollment operations ...