<mxfile host="app.diagrams.net">
  <diagram name="RGI Trucking ERD" id="RGI-Trucking-ERD">
    <mxGraphModel>
      <root>
        <mxCell id="0"/>
        <mxCell id="1" parent="0"/>

        <!-- Driver -->
        <mxCell id="Driver" value="Driver&#10;PK: Driver_ID&#10;Driver_Name&#10;Driver_Surname&#10;License_Type&#10;Driver_Desc" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="40" y="80" width="160" height="120" as="geometry"/>
        </mxCell>

        <!-- Truck -->
        <mxCell id="Truck" value="Truck&#10;PK: Truck_ID&#10;Truck_Desc" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="400" y="80" width="160" height="80" as="geometry"/>
        </mxCell>

        <!-- Assignment -->
        <mxCell id="Assignment" value="Assignment&#10;PK: Assignment_ID&#10;FK: Driver_ID&#10;FK: Truck_ID&#10;Routes" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="220" y="220" width="180" height="120" as="geometry"/>
        </mxCell>

        <!-- Employee -->
        <mxCell id="Employee" value="Employee&#10;PK: Employee_ID&#10;Employee_Name&#10;Employee_Surname&#10;Role" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="220" y="20" width="180" height="100" as="geometry"/>
        </mxCell>

        <!-- Specializations -->
        <mxCell id="Dispatcher" value="Dispatcher" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="40" y="360" width="120" height="60" as="geometry"/>
        </mxCell>
        <mxCell id="FirstResponder" value="First Responder" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="200" y="360" width="120" height="60" as="geometry"/>
        </mxCell>
        <mxCell id="Mechanic" value="Mechanic" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="360" y="360" width="120" height="60" as="geometry"/>
        </mxCell>
        <mxCell id="Clerk" value="Clerk" style="shape=rectangle;whiteSpace=wrap;rounded=0;" vertex="1" parent="1">
          <mxGeometry x="520" y="360" width="120" height="60" as="geometry"/>
        </mxCell>

        <!-- ISA Triangle -->
        <mxCell id="ISA" value="ISA" style="shape=triangle;whiteSpace=wrap;" vertex="1" parent="1">
          <mxGeometry x="260" y="140" width="60" height="40" as="geometry"/>
        </mxCell>

        <!-- Connections -->
        <mxCell id="Driver-Assignment" edge="1" parent="1" source="Driver" target="Assignment" style="endArrow=classic;startArrow=none;"/>
        <mxCell id="Truck-Assignment" edge="1" parent="1" source="Truck" target="Assignment" style="endArrow=classic;startArrow=none;"/>
        <mxCell id="Employee-ISA" edge="1" parent="1" source="Employee" target="ISA" style="endArrow=none;startArrow=none;"/>
        <mxCell id="ISA-Dispatcher" edge="1" parent="1" source="ISA" target="Dispatcher" style="endArrow=none;startArrow=none;"/>
        <mxCell id="ISA-FirstResponder" edge="1" parent="1" source="ISA" target="FirstResponder" style="endArrow=none;startArrow=none;"/>
        <mxCell id="ISA-Mechanic" edge="1" parent="1" source="ISA" target="Mechanic" style="endArrow=none;startArrow=none;"/>
        <mxCell id="ISA-Clerk" edge="1" parent="1" source="ISA" target="Clerk" style="endArrow=none;startArrow=none;"/>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>