How to design a one to one relationship in CASE*Dictionary?
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 SwitzerlandReceived on Tue Jun 30 1992 - 08:31:24 CEST