How to design a one to one relationship in CASE*Dictionary?

From: Markus Sonderegger <sondereg_at_forty2.physik.unizh.ch>
Date: 30 Jun 92 06:31:24 GMT
Message-ID: <2272_at_forty2.physik.unizh.ch>


My question:
How can i tell CASE*Dictionary that the inheritance of a key for a one to one relationship between two entities A and B goes only in one direction AND NOT also in the opposite direction? If the relationship is a many to one then the inheritance works perfectly!

What i did:
In the Entity/Attribute Definition Screen i entered two entities, lets call them A and B. Entity A has an attribute ID which is the Unique Identifier (UID) of this entity. Entity B has no attributes. In the Relationship Definition Screen i entered a one to one optional to mandatory relation between A and B.
Each A may be for one and only one B Each B must be shown on one and only one A

In the Unique Identifier Definition Screen i defined as UID for the entity B the relationship "shown on" to Entity A.

During the Design Phase i first create the tables AS and BS with the Fastpath Table Mapping Utility and afterwards the columns of AS and BS with the Default Database Design Utility.

What i get is

Table/Column



AS
- A_ID Primary key
  • A_A_ID ???????

BS
- B_A_ID Primary key, foreignk key inherited from Table A

and what i would like to have is the above without the A_A_ID column

Of course i could now manually change the design. But if ORACLE gives me an automated tool, i would also like to use it. Any comments are appreciated.
If i get answers i'll summarize to comp.databases.oracle Thanks for your attention

-- 
Markus Sonderegger                      sondereg_at_physik.unizh.ch
Swiss Federal Institute for 
Forest, Snow and Landscape Research     Tel.: +41-1-7392-497
Switzerland
Received on Tue Jun 30 1992 - 08:31:24 CEST

Original text of this message