Fujitsu UDS/SQL V2.5 Network Router User Manual


 
General information CODASYL model
U929-J-Z125-9-76 29
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
18. Oktober 2007 Stand 11:29.48 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k02
The set between the SUPPLIER and ARTICLE record types has the name SUPPLIES. In
the SUPPLIES set, SUPPLIER is the owner record type, and ARTICLE the member record
type. As a rule, two or more records of the member record type are assigned to a given
record of the owner record type. In this example, the supplier Schmidt supplies the articles
gingerbread cookies and marzipan.
Figure 2: Network-like structure of data
In a network structure, a record type may be a member in two or more different set relation-
ships and thus may also have more than one owner. A record can have only one owner per
set relationship.
PURCHASE
CONTAINED-IN
ORDERED-IN
CONTAINS
SUBSET
PURCH-ORDER
NAME CITY
Mueller
Schmidt
Munich
Nuremberg
DESIGNATION PRICE
Milk
Yoghurt
Curd cheese
Gingerbread
Marzipan
1,49
0,99
1,29
4,39
2,99
SUPPLIER ARTICLESUPPLIES
Record element
Record elem.
name
Record
SUPPLIES
ARTICLE
RECEIVES
SUPPLIER
ORDER
ITEM