<mxfile host="app.diagrams.net" modified="2026-09-11T15:17:00.000Z" agent="workbuddy" version="24.7.17" type="device">
  <diagram id="er" name="图书管理系统E-R图">
    <mxGraphModel dx="1700" dy="1300" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1720" pageHeight="1000" math="0" shadow="0">
      <root>
        <mxCell id="0"/>
        <mxCell id="1" parent="0"/>
        <mxCell id="title" value="图书管理系统 · 概念数据模型（E-R 图 / Chen 表示法）&#10;贯穿案例：南宁数字科技学院图书馆信息化建设项目" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=18;fontStyle=1;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="430" y="20" width="640" height="56" as="geometry"/></mxCell>
        <mxCell id="category" value="类别 Category" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;align=center;verticalAlign=middle;fontSize=13;fontStyle=1;" vertex="1" parent="1"><mxGeometry x="100.0" y="172.0" width="160" height="56" as="geometry"/></mxCell>
        <mxCell id="category_a0" value="&lt;u&gt;类别号&lt;/u&gt;（PK）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="128.0" y="58.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="category_l0" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="category" target="category_a0"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="category_a1" value="类别名" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="212.89999999999998" y="93.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="category_l1" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="category" target="category_a1"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="category_a2" value="借阅上限" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="212.89999999999998" y="262.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="category_l2" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="category" target="category_a2"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="category_a3" value="借期天数" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="43.099999999999994" y="262.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="category_l3" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="category" target="category_a3"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="book" value="图书 Book" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;align=center;verticalAlign=middle;fontSize=13;fontStyle=1;" vertex="1" parent="1"><mxGeometry x="100.0" y="412.0" width="160" height="56" as="geometry"/></mxCell>
        <mxCell id="book_a0" value="&lt;u&gt;ISBN&lt;/u&gt;（PK）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="128.0" y="298.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="book_l0" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="book" target="book_a0"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="book_a1" value="书名" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="212.89999999999998" y="333.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="book_l1" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="book" target="book_a1"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="book_a2" value="作者" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="212.89999999999998" y="502.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="book_l2" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="book" target="book_a2"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="book_a3" value="出版社" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="43.099999999999994" y="502.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="book_l3" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="book" target="book_a3"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="book_a4" value="出版年" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="43.099999999999994" y="333.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="book_l4" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="book" target="book_a4"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="copy" value="复本 BookCopy（弱实体）" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#ffe6cc;strokeColor=#d79b00;strokeWidth=3;align=center;verticalAlign=middle;fontSize=13;fontStyle=1;" vertex="1" parent="1"><mxGeometry x="467.5" y="411.0" width="185" height="58" as="geometry"/></mxCell>
        <mxCell id="copy_a0" value="&lt;u&gt;复本号&lt;/u&gt;（部分码）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="508.0" y="298.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="copy_l0" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="copy" target="copy_a0"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="copy_a1" value="&lt;u&gt;ISBN&lt;/u&gt;（部分码）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="592.9" y="333.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="copy_l1" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="copy" target="copy_a1"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="copy_a2" value="馆藏位置" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="592.9" y="502.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="copy_l2" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="copy" target="copy_a2"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="copy_a3" value="状态" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="423.1" y="502.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="copy_l3" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="copy" target="copy_a3"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="copy_a4" value="入库日期" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="423.1" y="333.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="copy_l4" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="copy" target="copy_a4"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="librarian" value="管理员 Librarian" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;align=center;verticalAlign=middle;fontSize=13;fontStyle=1;" vertex="1" parent="1"><mxGeometry x="875.0" y="172.0" width="170" height="56" as="geometry"/></mxCell>
        <mxCell id="librarian_a0" value="&lt;u&gt;工号&lt;/u&gt;（PK）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="908.0" y="58.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="librarian_l0" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="librarian" target="librarian_a0"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="librarian_a1" value="姓名" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="992.9000000000001" y="93.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="librarian_l1" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="librarian" target="librarian_a1"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="librarian_a2" value="岗位" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="992.9000000000001" y="262.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="librarian_l2" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="librarian" target="librarian_a2"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="librarian_a3" value="权限等级" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="823.1" y="262.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="librarian_l3" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="librarian" target="librarian_a3"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="borrow" value="借阅记录 BorrowRecord" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#f8cecc;strokeColor=#b85450;align=center;verticalAlign=middle;fontSize=13;fontStyle=1;" vertex="1" parent="1"><mxGeometry x="860.0" y="531.0" width="200" height="58" as="geometry"/></mxCell>
        <mxCell id="borrow_a0" value="&lt;u&gt;借阅流水号&lt;/u&gt;（PK）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="908.0" y="418.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="borrow_l0" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="borrow" target="borrow_a0"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="borrow_a1" value="借出日" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="992.9000000000001" y="453.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="borrow_l1" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="borrow" target="borrow_a1"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="borrow_a2" value="应还日" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="992.9000000000001" y="622.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="borrow_l2" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="borrow" target="borrow_a2"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="borrow_a3" value="实还日" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="823.1" y="622.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="borrow_l3" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="borrow" target="borrow_a3"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="borrow_a4" value="罚金" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="823.1" y="453.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="borrow_l4" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="borrow" target="borrow_a4"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="reader" value="读者 Reader" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;align=center;verticalAlign=middle;fontSize=13;fontStyle=1;" vertex="1" parent="1"><mxGeometry x="475.0" y="752.0" width="170" height="56" as="geometry"/></mxCell>
        <mxCell id="reader_a0" value="&lt;u&gt;读者证号&lt;/u&gt;（PK）" style="ellipse;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="508.0" y="638.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="reader_l0" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="reader" target="reader_a0"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="reader_a1" value="姓名" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="592.9" y="673.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="reader_l1" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="reader" target="reader_a1"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="reader_a2" value="单位" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="592.9" y="842.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="reader_l2" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="reader" target="reader_a2"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="reader_a3" value="角色" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="423.1" y="842.9" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="reader_l3" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="reader" target="reader_a3"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="reader_a4" value="可借册数" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="423.1" y="673.1" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="reader_l4" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="reader" target="reader_a4"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="reader_a5" value="已借册数" style="ellipse;whiteSpace=wrap;html=1;fillColor=#ffffff;strokeColor=#82b366;fontSize=11;align=center;verticalAlign=middle;" vertex="1" parent="1"><mxGeometry x="628.0" y="758.0" width="104" height="44" as="geometry"/></mxCell>
        <mxCell id="reader_l5" style="edgeStyle=none;html=1;endArrow=none;endFill=0;strokeColor=#999999;" edge="1" parent="1" source="reader" target="reader_a5"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_cat_book" value="&lt;b&gt;归类&lt;/b&gt;" style="rhombus;whiteSpace=wrap;html=1;fillColor=#f5f5f5;strokeColor=#333333;align=center;verticalAlign=middle;fontSize=13;" vertex="1" parent="1"><mxGeometry x="125" y="286" width="110" height="68" as="geometry"/></mxCell>
        <mxCell id="r_cat_book_e1" value="1" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="category" target="r_cat_book"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_cat_book_e2" value="N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="r_cat_book" target="book"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_book_copy" value="&lt;b&gt;包含&lt;/b&gt;" style="rhombus;whiteSpace=wrap;html=1;fillColor=#f5f5f5;strokeColor=#333333;align=center;verticalAlign=middle;fontSize=13;" vertex="1" parent="1"><mxGeometry x="315" y="406" width="110" height="68" as="geometry"/></mxCell>
        <mxCell id="r_book_copy_e1" value="1" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="book" target="r_book_copy"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_book_copy_e2" value="N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="r_book_copy" target="copy"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_borrow" value="&lt;b&gt;借阅&lt;/b&gt;" style="rhombus;whiteSpace=wrap;html=1;fillColor=#f5f5f5;strokeColor=#333333;align=center;verticalAlign=middle;fontSize=13;" vertex="1" parent="1"><mxGeometry x="505" y="556" width="110" height="68" as="geometry"/></mxCell>
        <mxCell id="r_borrow_e1" value="M" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="copy" target="r_borrow"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_borrow_e2" value="N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="r_borrow" target="reader"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_borrow_e3" value="联系实体" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#b85450;dashed=1;fontSize=12;fontStyle=2;" edge="1" parent="1" source="r_borrow" target="borrow"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_process" value="&lt;b&gt;处理&lt;/b&gt;" style="rhombus;whiteSpace=wrap;html=1;fillColor=#f5f5f5;strokeColor=#333333;align=center;verticalAlign=middle;fontSize=13;" vertex="1" parent="1"><mxGeometry x="905" y="346" width="110" height="68" as="geometry"/></mxCell>
        <mxCell id="r_process_e1" value="1" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="librarian" target="r_process"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="r_process_e2" value="N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;html=1;endArrow=none;endFill=0;strokeColor=#333333;fontSize=13;fontStyle=1;" edge="1" parent="1" source="r_process" target="borrow"><mxGeometry relative="1" as="geometry"/></mxCell>
        <mxCell id="desc" value="实体与关系说明&#10;&#10;&lt;b&gt;【实体】&lt;/b&gt;&#10;• 类别 Category：图书分类（如计算机/文学），含借阅上限与借期天数。&#10;• 图书 Book（强实体）：同一 ISBN 的一种书，含书名/作者/出版社/出版年。&#10;• 复本 BookCopy（弱实体）：馆藏每一册实体，依赖 ISBN 标识；借还定位到“册”。&#10;• 读者 Reader：借书人，分学生/教师，设可借册数上限。&#10;• 管理员 Librarian：处理借还、编目、罚金的业务人员。&#10;• 借阅记录 BorrowRecord：读者—复本“借阅”联系提升的关系实体，记借还明细与罚金。&#10;&#10;&lt;b&gt;【关系（基数）】&lt;/b&gt;&#10;1. 类别 1 —— N 图书（归类）：一类含多本，一本只属一类。&#10;2. 图书 1 —— N 复本（包含）：一种书多册，一册只属一种书。&#10;3. 读者 M —— N 复本（借阅）：一人可借多册，一册先后被多人借；&#10;   提升为“借阅记录”实体，带借出日/应还日/罚金。&#10;4. 管理员 1 —— N 借阅记录（处理）：一个馆员处理多条借阅记录。" style="rounded=0;whiteSpace=wrap;html=1;fillColor=#f5f5f5;strokeColor=#666666;fontSize=13;align=left;verticalAlign=top;spacingLeft=10;spacingTop=8;" vertex="1" parent="1"><mxGeometry x="1180" y="180" width="500" height="640" as="geometry"/></mxCell>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
