1. Table Client : sans contrainte

	create table Client (
		codeclt number, 
		nomclt varchar2(20),
		ville varchar2(20),dd
		caclt number(8,3)
	)

2)Table article + clé Primaire

create table Article(
	codeart number constraint pk_Article primary key,
	nomArt varchar2(),
	couleur varchar2(20),
	qtestck number,
	prixunit number,
)

3. Table commande avec une seule contrainte de table

create table commande(
	numcde number,
	datecde date,
	mntcde number(8.3),
	codeclt number,
	constraint pk_commande primary key (numcde)
)
	

4. ajout d’une clé primaire

	Alter table client add constraint pk_client primary key( codeclt);

Create table LigneCde (
	codeart number constraint c1 references Article (codeart),
	numcde number constraint c2 references commande(numcde),
	qtecdee number,
	constraint pk_Lignecde primary key (codeart,numcde));

7)ALter table LigneCde
add constraint Qtcdee_positive check (qtecdee>0);
	

*)

Create table LigneCde (
	codeart number,
	numcde number ,
	qtecdee number ,
	constraint pk	 primary key (codeart,numcde) ,
	constraint fk1 foreign key (codeart) references Article(codeart),
	constraint fk2 foreign key (numcde) references Commande(numcde),
	 check (qtecdee>0);
	}
)