create table fabricant(
	numf	number(15),
	nomf	varchar2(15),
	adrf	varchar2(50),
	telf	number(15),
constraint fab_pk primary key (numf));

create table produit(
	nump	number(15),
	nomp	varchar2(15),
constraint prod_pk primary key (nump));

create table article(
	numserie	number(15),
	nump		number(15),
	numf		number(15),
	qte		number(20),
	prixfab		number(15),
	prixvente	number(15),
	check(prixvente <= 1.5 * prixfab),
constraint article_pk primary key (numserie),
constraint art_prod_fk	foreign key (nump) references produit (nump),
constraint art_fab_fk	foreign key (numf) references fabricant (numf));

create table client(
	numc	number(15),
	nomc	varchar2(15),
	adrc	varchar2(30),
	telc	number(15),
constraint client_pk primary key (numc));

create table commande(
	numcde	number(15),
	numc	number(15),
	datecde	date,
constraint cde_pk primary key (numcde),
constraint cde_client_fk foreign key (numc) references client (numc));

create table lignecde(
	numcde		number(15),
	numserie	number(15),
	qte		number(15),
constraint lcde_pk primary key (numcde,numserie));