Notice that the relationship between STUDENT and the intersection record and that between CLASS and the intersection record both are 1:N. Thus, we have created a simple network that can now be repre-sented with the linked-list or index techniques shown earlier. A file of this occurrence using the linked-list technique is shown in Figure H-31.
Summary of Relationship Representations
Figure H-32 summarizes the representations of record relationships. Trees can be represented using se-quential lists (although we did not discuss this approach), linked lists, or indexes. Sequential lists are not used in DBMS products. A simple network can be decomposed into trees and then represented or it can be represented directly using either linked lists or indexes. Finally, a complex network can be decom-posed into a tree or a simple network (using intersection records) or it can be represented directly using indexes.