Linking record types Schema DDL
76 U929-J-Z125-9-76
Figure 16: m:n relationship between ORDERS and ARTICLE
ORDERS
ITEM
ARTICLE
ORDER 1 ORDER 2 ORDER 3 ORDER 4
ORDER-
QTY: 100
ORDER-
QTY: 2
ORDER-
QTY: 5
130
1
1
5
10
ARTICLE-NAME:
RADIO
ARTICLE-NAME:
LAMP
ARTICLE-NAME:
CLOCK
ARTICLE-NAME:
KETTLE
ORDER: 3
CUST.: ERIC
KETTLE
RADIO
30
1
ORDER: 2
CUST.: ERIC
LAMP
CLOCK
RADIO
1
5
ORDER: 1
CUST.: ADAM
RADIO
LAMP
2
30
1
ARTICLE-ITEMORDER-ITEM
ORDER-
QTY: 30
ORDER: 4
CUST.: ERIC
CLOCK
LAMP
KETTLE
100
5
10