Help with a foreign key

[Quoted] Can you help me with a script please?

These is the script:
clear screen
--Supprimer toutes les tables existantes
drop table auteur cascade constraints;
drop table editeur cascade constraints;
drop table client cascade constraints;
drop table livre cascade constraints;
drop table commande cascade constraints;

--Supprimer toutes les séquences existantes
drop sequence auteur_seq;
drop sequence editeur_seq;
drop sequence client_seq;
drop sequence livre_seq;

--Création de la table auteur

create table auteur( numaut number(4) constraint pk_auteur_numaut primary key,

                     nomaut varchar2(30) not null,
                     preaut varchar2(30) not null
                    );

--Création de la table editeur

create table editeur( numedi number(4) constraint pk_editeur_numedi primary key,

[Quoted]                       nomedi varchar2(30) not null,
                      adredi varchar2(60) not null
                     );

--Création de la table client

create table client( numcli number(4) constraint pk_client_numcli primary key,

                     nomcli varchar2(30) not null,
                     precli varchar2(30) not null
                    );

--Création de la table livre

create table livre( numliv number(6),

                    titliv varchar2(60) not null,
                    numaut number(4) constraint fk_livre_numaut references
auteur(numaut),
                    numedi number(4) constraint fk_livre_numedi references
editeur(numedi),
                    datedi date not null,
      constraint pk_livre_cles primary key(numliv,numaut,numedi)
                   );

--Création de la table commande

create table commande( numcom number(4),

                       numliv number(6) constraint fk_livre_numliv
references livre(numliv),
[Quoted]                        numcli number(4) constraint fk_client_numcli
references client(numcli),
                       qtecom number(2) not null,
                       constraint pk_commande_cles primary
key(numcom,numliv,numcli)
                      );

The conditions are:

1-    One commande(order) has one or more livre(book)
2-    one commande(order) has onely one client
3-    one livre(book) has only one auteur(author)
4-    one livre (book) has only one editeur(editor)

Thank Received on Wed Nov 15 2000 - 04:26:39 CET