Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Buveur (
- numBuveur NUMBER(3),
- nom VARCHAR2(20) NOT NULL,
- prenom VARCHAR2(20),
- ville VARCHAR2(20),
- CONSTRAINT cleBuveur PRIMARY KEY (numBuveur));
- create table viticulteur (
- NumViti NUMBER(3),
- nom VARCHAR2(20) NOT NULL,
- prenom VARCHAR2(20),
- ville varchar2(20),
- Constraint cleViti PRIMARY KEY (NumViti);
- create table vin (
- numVin NUMBER(3),
- cru Varchar2(20),
- Millesime Number(4),
- region Varchar2(10),
- numViti number(3),
- Constraint cleVin PRIMARY KEY (numVin),
- constraint cirViti FOREIGN KEY (numViti) REFERENCES Viticulteur);
- create table commande(
- numCommande NUMBER(4),
- numBuveur number(3),
- numVin number(3),
- dateCommande Date,
- Quantite Number (4) NOT NULL,
- Constraint cleCom PRIMARY KEY (numCommande),
- constraint cirBuveur FOREIGN KEY (numBuveur) REFERENCES buveur,
- constraint cirVin FOREIGN KEY (numVin) REFERENCES vin);
- create table livraison (
- numCommande NUMBER(4),
- dateLiv Date,
- quantiteLiv NUMBER(3),
- Constraint cleLivraison PRIMARY KEY (numCommande, dateLiv),
- constraint cirCom FOREIGN KEY (numCommande) REFERENCES Commande,
- constraint verifQuant CHECK (quantiteLiv>0));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement