CREATE TABLE CLIENT
(
NoClient	INTEGER, 
NomClient VARCHAR(20) CONSTRAINT NN_NomPers NOT NULL, 
PrenomClient VARCHAR(20) CONSTRAINT NN_PrenomPers NOT NULL
)


CREATE TABLE OUVRAGE
(
RefOuvrage VARCHAR(5),
TitreOuvrage VARCHAR(30),
CodeISBN CHAR(10) CONSTRAINT NN_ISBN NOT NULL,
PrixVente NUMERIC
)


CREATE TABLE EMPRUNT
(NoClient INTEGER, 
RefOuvrage VARCHAR(5),
DateEmprunt DATE CONSTRAINT NN_DateEmrunt NOT NULL
)

ALTER TABLE CLIENT
ADD CONSTRAINT PK_CLIENT PRIMARY KEY (NoClient)

ALTER TABLE OUVRAGE
ADD CONSTRAINT PK_OUVRAGE PRIMARY KEY (RefOuvrage)

ALTER TABLE EMPRUNT
ADD CONSTRAINT PK_EMPRUNT PRIMARY KEY (NoClient, RefOuvrage)


ALTER TABLE OUVRAGE
ADD CONSTRAINT U_CodeISBN UNIQUE(CodeISBN)


ALTER TABLE EMPRUNT
ADD CONSTRAINT FK_EMPRUNT_CLIENT FOREIGN KEY(NoClient) REFERENCES CLIENT(NoClient)