question 3
set schema 'slam1'; CREATE TABLE "donnateur" ( "num" serial NOT NULL, "nom" varchar(20) NOT NULL, "type" char(1) NOT NULL, "ville" varchar(20) NOT NULL, "cumul" DECIMAL(6) NOT NULL, CONSTRAINT "donnateur_pk" PRIMARY KEY ("num") ) WITH ( OIDS=FALSE );
CREATE TABLE "don" ( "date" DATE NOT NULL, CONSTRAINT "don_pk" PRIMARY KEY ("date") ) WITH ( OIDS=FALSE );
CREATE TABLE "montant" ( "montant" DECIMAL(4) NOT NULL, "num_donnateur" serial NOT NULL, "don_date" date NOT NULL, CONSTRAINT "montant_pk" PRIMARY KEY ("num_donnateur","don_date") ) WITH ( OIDS=FALSE );
ALTER TABLE "montant" ADD CONSTRAINT "montant_fk0" FOREIGN KEY ("num_donnateur") REFERENCES "donnateur"("num"); ALTER TABLE "montant" ADD CONSTRAINT "montant_fk1" FOREIGN KEY ("don_date") REFERENCES "don"("date");