exercice 1

CREATE TABLE client(
    numclient INT CONSTRAINT pk_numclient PRIMARY KEY ,
    nomclient VARCHAR(50) CONSTRAINT ob_nomclient NOT NULL,
    tel VARCHAR(50) CONSTRAINT un_tel UNIQUE,
    sociale VARCHAR(50),
    chiffreaffaire REAL CONSTRAINT sup_ca CHECK(chiffreaffaire >150000)
);

 DROP TABLE client;


CREATE TABLE client(
    numclient INT,
    nomclient VARCHAR(50) CONSTRAINT ob_nomclient NOT NULL ,
    tel VARCHAR(50) ,
    sociale VARCHAR(50),
    chiffreaffaire REAL ,
    CONSTRAINT pk_numclient PRIMARY KEY (numclient),

    CONSTRAINT un_tel UNIQUE (tel),
    CONSTRAINT sup_ca CHECK(chiffreaffaire >150000)

);


CREATE TABLE client3 (
    numclient INT CONSTRAINT pk_numclient PRIMARY KEY ,
    nomclient VARCHAR(50) CONSTRAINT ob_nomclient NOT NULL ,
    tel VARCHAR(50) ,
    sociale VARCHAR(50),
    chiffreaffaire REAL ,
);
ALTER TABLE client3 ADD CONSTRAINT un_tel UNIQUE (tel),
    CONSTRAINT sup_ca CHECK(chiffreaffaire >150000);

DROP TABLE client3;