<mxfile host="app.diagrams.net" modified="2026-10-13T21:50:00.000Z" agent="Antigravity" version="21.0.0" type="device">
  <diagram id="modelagem-biblioteca" name="DER - Biblioteca Escolar">
    <mxGraphModel dx="1200" dy="800" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1169" pageHeight="827" math="0" shadow="0">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />

        <!-- Entidade ALUNO -->
        <mxCell id="ent_aluno" value="ALUNO" style="rounded=0;whiteSpace=wrap;html=1;fontStyle=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=14;" vertex="1" parent="1">
          <mxGeometry x="80" y="240" width="140" height="60" as="geometry" />
        </mxCell>

        <!-- Atributos ALUNO -->
        <mxCell id="att_aluno_pk" value="matricula (PK)" style="ellipse;whiteSpace=wrap;html=1;fontStyle=4;fillColor=#fff2cc;strokeColor=#d6b656;" vertex="1" parent="1">
          <mxGeometry x="60" y="140" width="100" height="40" as="geometry" />
        </mxCell>
        <mxCell id="edge_att_aluno_pk" edge="1" parent="1" source="ent_aluno" target="att_aluno_pk">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <mxCell id="att_aluno_nome" value="nome" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#666666;" vertex="1" parent="1">
          <mxGeometry x="170" y="140" width="90" height="40" as="geometry" />
        </mxCell>
        <mxCell id="edge_att_aluno_nome" edge="1" parent="1" source="ent_aluno" target="att_aluno_nome">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Relacionamento REALIZA -->
        <mxCell id="rel_realiza" value="realiza" style="rhombus;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;fontStyle=1;" vertex="1" parent="1">
          <mxGeometry x="320" y="235" width="110" height="70" as="geometry" />
        </mxCell>

        <!-- Conexão ALUNO - REALIZA (1, N) -->
        <mxCell id="edge_aluno_realiza" value="(1, N)" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;strokeWidth=2;" edge="1" parent="1" source="ent_aluno" target="rel_realiza">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Entidade EMPRESTIMO -->
        <mxCell id="ent_emprestimo" value="EMPRESTIMO" style="rounded=0;whiteSpace=wrap;html=1;fontStyle=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=14;" vertex="1" parent="1">
          <mxGeometry x="520" y="240" width="140" height="60" as="geometry" />
        </mxCell>

        <!-- Conexão REALIZA - EMPRESTIMO (1, 1) -->
        <mxCell id="edge_realiza_emprestimo" value="(1, 1)" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;strokeWidth=2;" edge="1" parent="1" source="rel_realiza" target="ent_emprestimo">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Atributos EMPRESTIMO -->
        <mxCell id="att_emp_pk" value="id_emprestimo (PK)" style="ellipse;whiteSpace=wrap;html=1;fontStyle=4;fillColor=#fff2cc;strokeColor=#d6b656;" vertex="1" parent="1">
          <mxGeometry x="460" y="140" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="edge_att_emp_pk" edge="1" parent="1" source="ent_emprestimo" target="att_emp_pk">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <mxCell id="att_emp_data" value="data_retirada" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#666666;" vertex="1" parent="1">
          <mxGeometry x="600" y="140" width="100" height="40" as="geometry" />
        </mxCell>
        <mxCell id="edge_att_emp_data" edge="1" parent="1" source="ent_emprestimo" target="att_emp_data">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Relacionamento CONTEM -->
        <mxCell id="rel_contem" value="contém" style="rhombus;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;fontStyle=1;" vertex="1" parent="1">
          <mxGeometry x="750" y="235" width="110" height="70" as="geometry" />
        </mxCell>

        <mxCell id="edge_emp_contem" value="(1, N)" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;strokeWidth=2;" edge="1" parent="1" source="ent_emprestimo" target="rel_contem">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Entidade LIVRO -->
        <mxCell id="ent_livro" value="LIVRO" style="rounded=0;whiteSpace=wrap;html=1;fontStyle=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=14;" vertex="1" parent="1">
          <mxGeometry x="950" y="240" width="140" height="60" as="geometry" />
        </mxCell>

        <mxCell id="edge_contem_livro" value="(1, N)" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;strokeWidth=2;" edge="1" parent="1" source="rel_contem" target="ent_livro">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Atributos LIVRO -->
        <mxCell id="att_livro_pk" value="isbn (PK)" style="ellipse;whiteSpace=wrap;html=1;fontStyle=4;fillColor=#fff2cc;strokeColor=#d6b656;" vertex="1" parent="1">
          <mxGeometry x="920" y="140" width="90" height="40" as="geometry" />
        </mxCell>
        <mxCell id="edge_att_livro_pk" edge="1" parent="1" source="ent_livro" target="att_livro_pk">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <mxCell id="att_livro_tit" value="titulo" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#666666;" vertex="1" parent="1">
          <mxGeometry x="1030" y="140" width="90" height="40" as="geometry" />
        </mxCell>
        <mxCell id="edge_att_livro_tit" edge="1" parent="1" source="ent_livro" target="att_livro_tit">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <!-- Entidade CATEGORIA -->
        <mxCell id="ent_categoria" value="CATEGORIA" style="rounded=0;whiteSpace=wrap;html=1;fontStyle=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=14;" vertex="1" parent="1">
          <mxGeometry x="950" y="440" width="140" height="60" as="geometry" />
        </mxCell>

        <!-- Relacionamento CLASSIFICA -->
        <mxCell id="rel_classifica" value="classifica" style="rhombus;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;fontStyle=1;" vertex="1" parent="1">
          <mxGeometry x="965" y="340" width="110" height="60" as="geometry" />
        </mxCell>

        <mxCell id="edge_livro_classifica" value="(1, 1)" style="endArrow=none;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;strokeWidth=2;" edge="1" parent="1" source="ent_livro" target="rel_classifica">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

        <mxCell id="edge_classifica_cat" value="(0, N)" style="endArrow=none;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;strokeWidth=2;" edge="1" parent="1" source="rel_classifica" target="ent_categoria">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>

      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
