alter table matiere add constraint fk_matiere_enseignant foreign key matiere(id_enseignant) references enseignant(id_enseignant) on delete cascade;
alter table inscription add constraint fk_inscription_etudiant foreign key inscription(id_etudiant) references etudiant(id_etudiant) on delete cascade;
alter table note add constraint fk_note_etudiant foreign key note(id_etudiant) references etudiant(id_etudiant);
alter table note add constraint fk_note_matiere foreign key note(id_matiere) references matiere(id_matiere);
 
 

YWx0ZXIgdGFibGUgbWF0aWVyZSBhZGQgY29uc3RyYWludCBma19tYXRpZXJlX2Vuc2VpZ25hbnQgZm9yZWlnbiBrZXkgbWF0aWVyZShpZF9lbnNlaWduYW50KSByZWZlcmVuY2VzIGVuc2VpZ25hbnQoaWRfZW5zZWlnbmFudCkgb24gZGVsZXRlIGNhc2NhZGU7CmFsdGVyIHRhYmxlIGluc2NyaXB0aW9uIGFkZCBjb25zdHJhaW50IGZrX2luc2NyaXB0aW9uX2V0dWRpYW50IGZvcmVpZ24ga2V5IGluc2NyaXB0aW9uKGlkX2V0dWRpYW50KSByZWZlcmVuY2VzIGV0dWRpYW50KGlkX2V0dWRpYW50KSBvbiBkZWxldGUgY2FzY2FkZTsKYWx0ZXIgdGFibGUgbm90ZSBhZGQgY29uc3RyYWludCBma19ub3RlX2V0dWRpYW50IGZvcmVpZ24ga2V5IG5vdGUoaWRfZXR1ZGlhbnQpIHJlZmVyZW5jZXMgZXR1ZGlhbnQoaWRfZXR1ZGlhbnQpOwphbHRlciB0YWJsZSBub3RlIGFkZCBjb25zdHJhaW50IGZrX25vdGVfbWF0aWVyZSBmb3JlaWduIGtleSBub3RlKGlkX21hdGllcmUpIHJlZmVyZW5jZXMgbWF0aWVyZShpZF9tYXRpZXJlKTsKCg==