Re: [SQL] General ISA and Foreign Key

2001-05-09 Thread BOUCHPAN-LERUST-JUERY Lionel
I thank you very much for your help. Regards, Lionel ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing lis

Re: [SQL] General ISA and Foreign Key

2001-05-07 Thread Oliver Elphick
BOUCHPAN-LERUST-JUERY Lionel wrote: >In SQL I have the following tables > >CREATE TABLE film( >VisaExploitation INTEGER NOT NULL, >DureeTournage INTEGER NOT NULL, >Titre VARCHAR( 50 ), > >PRIMARY KEY ( VisaExploitation ) ); >CREATE TABLE filmHistorique( >NbCostume INTEGER >)

[SQL] General ISA and Foreign Key

2001-05-07 Thread BOUCHPAN-LERUST-JUERY Lionel
I have a problem concerning an University assignment in SQL. I am running PostgreSQL. Below part of the E/R diagram in ASCII art. ( #VisaExploitation ) | //\\ | | // \\ | | | 1|