insert into classes values('00001', '3emeC', 3, 'College P. et M. Curie');
insert into classes values('00002', '4emeB', 4, 'College P. et M. Curie');

insert into eleves values (1, 'marley', 'nesta', '00001');
insert into eleves values (2, 'tosh', 'peter', '00001');
insert into eleves values (3, 'dupont', 'robert', '00001');
insert into eleves values (4, 'dupond', 'jean', '00001');
insert into eleves values (5, 'durand', 'paul', '00002');
insert into eleves values (6, 'boulanger', 'marie', '00002');
insert into eleves values (7, 'martin', 'julie', '00002');
insert into eleves values (8, 'foucher', 'pierre', '00002');

insert into sites values(1, 'Chateau des Ducs', '12-FEB-2008', '21-FEB-2008', 70, 5);
insert into sites values(2, 'Chez Sto', '4-MAR-2008', '5-MAR-2008', 5, 21); /* viole la contrainte coh_notes */
insert into sites values(3, 'Cathedrale', '12-FEB-2008', '21-MAR-2008', 135, 7);