1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| Module([IdModule,NomModule)
______________1_______Formation
______________2_______Math
_____________... ______...
Matiere(IdMatiere,IdModule,Matiere_Nom,Coefficient)
___________1________2________Mat-x_______3
___________2________2________Mat-y_______4
___________3________2________Mat-z_______3
___________4________2________Mat-u_______3
___________...________...________..._________...
___________5________1________Frnacais_____4
___________6________1________Englais______3
___________7________1_______Espagnole_____3
etc..............
Etudiant(IdEtudiant,__Nom,___ Prénom______Niveau)
________1_________Beegees____Bernard______1erAn
________2_________Martin______Louis________2emeAn
________...__________...________...__________4emeAn
etc..........
Note(IdNote_____idMatiere_____idetudiant_____Notes )
______1___________1____________1__________12
______2___________1____________2__________10
______3___________1____________3__________12
______? ___________?_____________?__________?
etc......... |
Partager