1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
create database commerce;
use commerce;
----------
create table Client(NOC varchar(30),
Nom varchar(30),
Adresse varchar(30),
constraint Client_pk primary key(NOC));
------------
create table service(NOS varchar(30),
Intitule varchar(30),
Localisation varchar(30),
constraint Service_pk primary key(NOS));
--------
create table piece(NOP varchar(30),
Designation varchar(50),
Couleur varchar(30),
Poids float,
constraint Piece_pk primary key(NOP),
constraint Poids_OK Check(Poids>0));
------
create table ordre(NOP varchar(30),
NOS varchar(30),
NOC varchar(30),
Quantite integer,
Constraint Ordre_pk primary key(NOP,NOS,NOC),
Constraint Ordre_fk1 foreign key(NOP) references PIECE(NOP),
Constraint Ordre_fk2 foreign key(NOS) references SERVICE(NOS),
Constraint Ordre_fk3 foreign key(NOC) references Client(NOC),
constraint Quantite_OK Check(Quantite>0)); |
Partager