CREATE TABLE pieces(
  NOP INTEGER ,
  Des VARCHAR (50),
  couleur VARCHAR(50) check(couleur in("rouge","vert","bleu","jaune")),
  poids FLOAT,
  PRIMARY KEY(NOP)
);
CREATE TABLE service(
    NOS INTEGER(50),
    Intitle VARCHAR (50),
    localisation VARCHAR(50),
      PRIMARY KEY(NOS)

);
CREATE TABLE Ordre(
    NOP INTEGER,
    NOS INTEGER,
    QUANTITE INTEGER,
    PRIMARY KEY(NOP,NOS),
    FOREIGN KEY (NOP) REFERENCES pieces,
    FOREIGN KEY (NOS) REFERENCES service

    
);
    CREATE TABLE nome(
    NOPA INTEGER,
    NOPC INTEGER,
    QUANTITE INTEGER,
    PRIMARY KEY(NOPA,NOPC),
    FOREIGN KEY (NOPA) REFERENCES pieces(NOP),
    FOREIGN KEY (NOPC) REFERENCES service(NOS)

    );
INSERT INTO pieces VALUES (1, 'Vis', 'rouge', 0.5);
INSERT INTO pieces VALUES (5, 'Ecrou', 'bleu', 0.3);
INSERT INTO service VALUES (2, 'Montage', 'Tunis');
INSERT INTO service VALUES (7, 'Assemblage', 'Sfax');
INSERT INTO Ordre VALUES (1, 2, 100);
INSERT INTO nome VALUES (5, 7, 49);
SELECT * from pieces;
SELECT * from service;
SELECT * from Ordre;
SELECT * from nome;