Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Schema DDL Linking record types
U929-J-Z125-9-76 73
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k04
A record type can be part of several sets. This makes the set the basic unit in network-like
data structures.
Figure 14: Network-like data structure
Relationships between record types
There are three possible types of relationships between record types that are to be linked:
1:n relationship between two record types
m:n relationship between two record types
m:n relationship within one record type
1:n relationship
If relationships between records are to be represented in a set, the following rule must be
observed:
A record may be a member of no more than one set occurrence in any set in which it is a
member record, i.e. within a set, a member record is assigned to no more than one owner
record.
An owner record may, however, have more than one member record associated with it.
Thus a 1:n relationship must exist between owner record type and member record type.