Re: D2K, optional foreign key on intersection tables?

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1997/10/10
Message-ID: <01bcd52e$250dbb00$f57293cf_at_default>#1/1

Andy,

I would make a sequence your primary key on the intersection table. You will not be able to enforce uniqueness if the second_key is null. I've worked quite a bit with the Database Design Wizard and you should be able to get the required output if you have drawn your entities correctly.

Phil Cook
Certified Oracle DBA Received on Fri Oct 10 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Tim Hall: "Re: D2K, optional foreign key on intersection tables?"
Previous message: sbhandar_at_csc.com: "Populating Combo box dynamically"
In reply to: Andy Hardy: "D2K, optional foreign key on intersection tables?"
Next in thread: Tim Hall: "Re: D2K, optional foreign key on intersection tables?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message