CREATE TABLE TD (
	noTD smallint, 
	codeUE varchar(10),
	niveau varchar(10), 
	salle varchar(10), 
	jour varchar(8),  
	heure varchar(5), 
	noEns smallint, 
	PRIMARY KEY ( NoTD, codeUE),  
	UNIQUE ( salle, jour, heure ), 	  
	UNIQUE ( noEns, jour, heure )) ; 

CREATE TABLE  INSCRIPTION (  
	noEtud smallint, 
 	noTD smallint, 
 	codeUE varchar(10),
	PRIMARY KEY (NoEtud, codeUE)) ;


