--q1.1.1
INSERT INTO PRODUIT
VALUES (20,'CAHIER','BLANC',100);

--q1.1.2
INSERT INTO produit
VALUES (21,'GOMME',NULL,500);

--q1.1.3
INSERT INTO PRODUIT
VALUES (NULL,'TROMBONE','GRIS',1000);

--Résultat :
	VALUES (NULL,'TROMBONE','GRIS',1000)
			*
	ERROR at line 2:
	ORA-01400: cannot insert NULL into ("JOVANIT"."PRODUIT"."NP")

--q1.1.4
--Résultat :
	INSERT INTO PRODUIT
	*
	ERROR at line 1:
	ORA-00001: unique constraint (JOVANIT.PK_PRODUIT) violated

--q1.1.5
INSERT INTO ACHAT
VALUES (101,20,12);

--q1.2.1
DELETE FROM PRODUIT
WHERE (np=21);

--q1.2.2
DELETE FROM PRODUIT
WHERE (np=20);

--Résultat :
	DELETE FROM PRODUIT
	*
	ERROR at line 1:
	ORA-02292: integrity constraint (JOVANIT.FK_ACHAT_NP) violated - child record found

--q1.2.3
DELETE FROM ACHAT
WHERE (QA<5);

--q1.2.4
DELETE FROM ACHAT
WHERE ncli IN (SELECT ncli FROM CLIENT
			WHERE (nom='RIFFLET')
			);


--q1.3.1
UPDATE ACHAT
SET qa = qa+10
WHERE (NP=(SELECT NP FROM PRODUIT WHERE LIB='AGRAFEUSE') AND NCLI=(SELECT NCLI FROM CLIENT WHERE NOM='DEFRERE'));

--q1.3.2
UPDATE produit
SET qs = qs + 100, coul = 'ROUGE FLUO'
WHERE (lib='CRAYON LUXE') AND (coul = 'ROUGE');

--q1.3.3
UPDATE ACHAT
SET qa = qa + 2
WHERE ncli = (SELECT NCLI FROM CLIENT WHERE NOM='DEFRERE');

--q1.3.4
UPDATE PRODUIT
SET np = 30
WHERE np = 20;

--Résultat :
UPDATE PRODUIT
*
ERROR at line 1:
 ORA-02292: integrity constraint (JOVANIT.FK_ACHAT_NP) violated - child record found

--q1.3.5
UPDATE ACHAT
SET np = (SELECT NP FROM PRODUIT WHERE LIB='CRAYON LUXE' AND COUL='BLEU')
WHERE  np = (SELECT NP FROM PRODUIT WHERE LIB='CRAYON LUXE' AND COUL='ROUGE FLUO') AND ncli = 101;

--Résultat
UPDATE ACHAT
*
ERROR at line 1:
 ORA-00001: unique constraint (JOVANIT.PK_ACHAT) violated

--q2.1.1
ALTER TABLE client
ADD adr VARCHAR(10);

--q2.1.2
ALTER TABLE client
MODIFY adr VARCHAR(20);

--q2.2.1
CREATE TABLE FOURNISSEUR (
nf INTEGER,
NOM VARCHAR (20),
ADR VARCHAR (20),
CONSTRAINT pk_fournisseur PRIMARY KEY (nf));

--q2.2.2
CREATE TABLE REAP (
nf INTEGER,
np INTEGER,
date_reap DATE DEFAULT current_date,
qr INTEGER,
CONSTRAINT pk_reap PRIMARY KEY (nf,np,date_reap));


INSERT INTO FOURNISSEUR
VALUES (1,'Gérard','Rue Coluche');

INSERT INTO REAP
VALUES (1,12,2257-08-11,4);