create table dep(
code_dep number primary key,
nom_dep varchar2(20));

create table etudiant(
cne number primary key,
nom varchar2(20),
prenom varchar2(20),
date_naiss date,
code_dep number references dep(code_dep));

create table matiere(
code_mat number primary key,
libelle varchar2(20),
coeiff number);

create table resultat(
code_mat number references matiere(code_mat),
cne number references etudiant(cne),
date_res date,
note number,
constraint pk_res primary key (code_mat,cne, date_res));

insert into dep values(1,'math');
insert into dep values(2,'physique');
insert into dep values(3,'info');

insert into matiere values(1,'algebre',2);
insert into matiere values(2,'BD',4);
insert into matiere values(3,'Reseaux',3);

insert into etudiant values(362017,'Yazidi','yassine',to_date('20/11/2000','dd/mm/yyyy'),1);
insert into etudiant values(362698,'Bouzidi','amine',to_date('15/12/1999','dd/mm/yyyy'),1);
insert into etudiant values(36586,'Salhi','brahim',to_date('04/08/1999','dd/mm/yyyy'),2);
insert into etudiant values(23689,'Zahi','Amal',to_date('10/10/1999','dd/mm/yyyy'),3);
insert into etudiant values(36254,'Jasmi','Sara',to_date('15/09/1999','dd/mm/yyyy'),3);
insert into etudiant values(25643,'Salmi','Mehdi',to_date('15/12/2000','dd/mm/yyyy'),3);