<mxfile host="Electron" version="29.6.6" type="device">
  <diagram id="connect-the-records" name="Which keys bring descriptions into the order?">
    <mxGraphModel grid="1" gridSize="10" page="0" pageWidth="1160" pageHeight="1000" background="#FFFFFF">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <object id="title" label="Which keys bring descriptions into the order?">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=28;fontStyle=1;" vertex="1" parent="1">
            <mxGeometry x="25" y="15" width="1110" height="70" as="geometry" />
          </mxCell>
        </object>
        <object id="subtitle" label="Match stored foreign keys (FK) while keeping headers, lines, and master records at their own grains.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=18;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="87" width="1110" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="n0" label="Customer&#10;&#10;CustomerID (PK) 130&#10;Jones, Richardson and Beard">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="25" y="170" width="330" height="170" as="geometry" />
          </mxCell>
        </object>
        <object id="n1" label="SalesOrder header&#10;&#10;SalesOrderID (PK) 11&#10;CustomerID (FK) 130">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="410" y="170" width="330" height="170" as="geometry" />
          </mxCell>
        </object>
        <object id="n2" label="Item&#10;&#10;ItemID (PK) 222&#10;Brookside Dining Table&#10;SupplyMode Manufactured">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="795" y="445" width="330" height="190" as="geometry" />
          </mxCell>
        </object>
        <object id="line" label="SalesOrderLine example&#10;&#10;SalesOrderLineID (PK) 43&#10;SalesOrderID (FK) 11&#10;ItemID (FK) 222">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="410" y="445" width="330" height="190" as="geometry" />
          </mxCell>
        </object>
        <object id="e0" label="r1" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=0;exitY=0.5;entryX=1;entryY=0.5;" edge="1" parent="1" source="n1" target="n0">
            <mxGeometry relative="1" as="geometry" />
          </mxCell>
        </object>
        <object id="e1" label="r2" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=1;entryY=0.5;" edge="1" parent="1" source="line" target="n1">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="770" y="540" />
                <mxPoint x="770" y="255" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="e2" label="r3" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="line" target="n2">
            <mxGeometry relative="1" as="geometry" />
          </mxCell>
        </object>
        <object id="footer" label="r1 CustomerID; r2 SalesOrderID; r3 ItemID. The customer key belongs to the order header.&#10;Arrows point from a stored reference to its referenced record; they do not describe chronology.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=17;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="692" width="1110" height="60" as="geometry" />
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
