Database Program Translation - Information Systems Reengineering, Integration and Normalization - page 195

SYSTEM

set

set

SUPPLIER
(owner record)

PART
(owner record)

SUPPLIED_ID NAME ADDRESS

PART_ID ART_NAME

supply Supplied_by

set set

ITEM
(member record)

UNIT_PRICE

Fig. 5.8 Network schema

SYSTEM

set

set

SUPPLIER_ID NAME ADDRESS

PART _ID PART _NAME

Aix-item

Aix-su pplied-i d Aix-part-i d

set set

ITEM
(m ember record)

SUPPLIER_ID PART _ID UNIT_PRICE

Note: so rt-key = su pplied_id, part_id

Fig. 5.9 Network schema with secondary indices as “open” schema

After schema transformation, the modified network schema acting as an “open”
internal schema is as shown in Fig. 5.9 .
The data of the converted database are: