Schema DDL Linking record types
U929-J-Z125-9-76 77
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\ud s\Manuale\en\udsent_e\uds ent.k04
The m:n relationship between ORDERS and ARTICLE is resolved to form two 1:n relation-
ships by creating a new record type (auxiliary record typ e) ITEM which is a member of both
ORDERS and ARTICLE.
m:n relationship within one record type (parts list processing)
In this special case the m:n relationship is not between two rec ord types, but exists within
one record type.
This type of relationship is resolved by defining a new record type (au xiliary record type)
which acts as a member, and defining a new set.
Example of an m:n relationship within one record type
An (assembled) part is made up of several subparts: → pa rts list
A subpart is used in several (assembled) parts: → where-used list
A bicycle is made up of several parts. Parts used for the bicycle are again in other parts
of the bike.