当代数据库管理系统课程实验二
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 

195 lines
16 KiB

<mxfile host="65bd71144e">
<diagram id="7UV1QSxvfCCaCf5dNHmy" name="第 1 页">
<mxGraphModel dx="911" dy="428" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="0"/>
<mxCell id="1" parent="0"/>
<mxCell id="40" style="edgeStyle=none;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="3" target="23">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="41" style="edgeStyle=none;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="3" target="22">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="3" value="user" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="270" y="310" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="46" style="edgeStyle=none;html=1;exitX=1;exitY=0;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="4" target="32">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="47" style="edgeStyle=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="4">
<mxGeometry relative="1" as="geometry">
<mxPoint x="660" y="300" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="48" style="edgeStyle=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="4" target="34">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="49" style="edgeStyle=none;html=1;exitX=1;exitY=1;exitDx=0;exitDy=0;entryX=0;entryY=0;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="4" target="35">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="4" value="store" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="510" y="310" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="43" style="edgeStyle=none;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="5" target="37">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="44" style="edgeStyle=none;html=1;exitX=0.75;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="5" target="38">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="5" value="new_order" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="390" y="410" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="10" value="" style="endArrow=none;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="25" target="26">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="515" y="220" as="sourcePoint"/>
<mxPoint x="565" y="180" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="11" value="" style="endArrow=none;html=1;entryX=0;entryY=0.5;entryDx=0;entryDy=0;entryPerimeter=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="27" target="25">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="350" y="220" as="sourcePoint"/>
<mxPoint x="385" y="220" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="14" value="购买" style="rhombus;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="290" y="400" width="80" height="80" as="geometry"/>
</mxCell>
<mxCell id="15" value="出售" style="rhombus;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="530" y="400" width="80" height="80" as="geometry"/>
</mxCell>
<mxCell id="16" value="" style="endArrow=none;html=1;entryX=0.5;entryY=1;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" target="4">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="570" y="400" as="sourcePoint"/>
<mxPoint x="620" y="350" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="17" value="" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="5" target="15">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="580" y="380" as="sourcePoint"/>
<mxPoint x="630" y="330" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="18" value="" style="endArrow=none;html=1;exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="14" target="3">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="580" y="380" as="sourcePoint"/>
<mxPoint x="630" y="330" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="19" value="" style="endArrow=none;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="14" target="5">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="640" y="450" as="sourcePoint"/>
<mxPoint x="690" y="400" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="21" value="user_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="150" y="240" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="22" value="password" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="161" y="390" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="23" value="balance" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="111" y="310" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="50" style="edgeStyle=none;html=1;exitX=0.25;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="25" target="30">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="51" style="edgeStyle=none;html=1;exitX=0.75;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=13;" edge="1" parent="1" source="25" target="31">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="25" value="user_store" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="390" y="190" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="26" value="店主" style="rhombus;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="530" y="180" width="80" height="80" as="geometry"/>
</mxCell>
<mxCell id="27" value="开店" style="rhombus;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="290" y="180" width="80" height="80" as="geometry"/>
</mxCell>
<mxCell id="28" value="" style="endArrow=none;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="26" target="4">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="520" y="380" as="sourcePoint"/>
<mxPoint x="570" y="330" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="29" value="" style="endArrow=none;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="27" target="3">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="520" y="380" as="sourcePoint"/>
<mxPoint x="570" y="330" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="30" value="user_id" style="ellipse;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=12;" vertex="1" parent="1">
<mxGeometry x="370" y="90" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="31" value="&lt;font style=&quot;font-size: 13px&quot;&gt;store_id&lt;/font&gt;" style="ellipse;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="470" y="90" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="32" value="store_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="661" y="180" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="33" value="book_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="661" y="270" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="34" value="book_info" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="661" y="350" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="35" value="stock_level" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="661" y="440" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="36" value="order_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="270" y="500" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="37" value="user_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="340" y="510" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="38" value="store_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="414" y="510" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="39" value="" style="endArrow=classic;startArrow=classic;html=1;fontFamily=Helvetica;fontSize=13;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=1;entryDx=0;entryDy=0;" edge="1" parent="1" source="3" target="21">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="390" y="410" as="sourcePoint"/>
<mxPoint x="440" y="360" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="42" value="" style="endArrow=classic;startArrow=classic;html=1;fontFamily=Helvetica;fontSize=13;exitX=0.25;exitY=1;exitDx=0;exitDy=0;entryX=1;entryY=0;entryDx=0;entryDy=0;" edge="1" parent="1" source="5" target="36">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="280" y="350" as="sourcePoint"/>
<mxPoint x="211.21320343559637" y="301.21320343559637" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="62" style="edgeStyle=none;html=1;exitX=0.75;exitY=0;exitDx=0;exitDy=0;entryX=0.313;entryY=1.007;entryDx=0;entryDy=0;entryPerimeter=0;fontFamily=Helvetica;fontSize=18;" edge="1" parent="1" source="53" target="60">
<mxGeometry relative="1" as="geometry"/>
</mxCell>
<mxCell id="53" value="&lt;font style=&quot;font-size: 18px&quot;&gt;book&lt;/font&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=13;" vertex="1" parent="1">
<mxGeometry x="620" y="520" width="120" height="60" as="geometry"/>
</mxCell>
<mxCell id="54" value="关于" style="rhombus;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=18;" vertex="1" parent="1">
<mxGeometry x="510" y="490" width="80" height="80" as="geometry"/>
</mxCell>
<mxCell id="56" value="" style="endArrow=none;html=1;fontFamily=Helvetica;fontSize=18;exitX=1;exitY=1;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="5" target="54">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="400" y="540" as="sourcePoint"/>
<mxPoint x="450" y="490" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="58" value="" style="endArrow=none;html=1;fontFamily=Helvetica;fontSize=18;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="53" target="54">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="400" y="540" as="sourcePoint"/>
<mxPoint x="450" y="490" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="59" value="book_id" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="767" y="450" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="60" value="book_info" style="ellipse;whiteSpace=wrap;html=1;aspect=fixed;" vertex="1" parent="1">
<mxGeometry x="740" y="380" width="60" height="60" as="geometry"/>
</mxCell>
<mxCell id="63" value="" style="endArrow=classic;startArrow=classic;html=1;fontFamily=Helvetica;fontSize=18;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;" edge="1" parent="1" source="53" target="59">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="530" y="460" as="sourcePoint"/>
<mxPoint x="580" y="410" as="targetPoint"/>
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>