Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Schema DDL Linking record types
U929-J-Z125-9-76 75
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
m:n relationship between two record types (many-to-many relationship)
An m:n relationship is a relationship in which a member record can be associated with more
than one owner record.
If m:n relationships are to be represented, they have to be broken down into two 1:n relation-
ships. To this purpose a new record type (auxiliary record type) has to be defined which acts
as member record type. After the relationship has been resolved, each member record has
an owner.
Example of an m:n relationship
An example of an m:n relationship is the relationship between orders and articles.
An order can refer to several articles, an article can be referred to in several orders.