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 28 29 30 31 32 33 34 35 36 37 38 39 40
|
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
Etudiant (IdEtudiant,__Nom,_____ Prénom______Niveau)
_____________1_________Beegees____Bernard______1erAn
_____________2_________Martin______Louis________2emeAn
_____________...__________...________...__________4emeAn
Enseignant (IdEnseignant ,Nom,Prenom )
____________________1_______Louis____...
____________________2_______Paul_____...
____________________3_______Marck____...
____________________... ______......_____...
Filiere (IdFiliere, NomFiliere,IdEtuidant )
_____________1_______TSGI______.....
_____________2_______TSI_______.....
_____________...______....________....
Il existe que deux Filieres
Note (IdNote ,Notes,IdMatiere,IdEtudiant )
__________1_______?______...._________.....
__________2_______?______...._________.....
__________3_______?______...._________.....
__________... ______...______...._________..... |
Partager