<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta name="generator" content="pdf2htmlEX">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css">
<link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css">
<link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/626db0dc3c16ee627a5ce572/raw.css">
<script src="https://static.pudn.com/base/js/compatibility.min.js"></script>
<script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script>
<script>
try{
pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});
}catch(e){}
</script>
<title></title>
</head>
<body>
<div id="sidebar" style="display: none">
<div id="outline">
</div>
</div>
<div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626db0dc3c16ee627a5ce572/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">一、<span class="_ _0"> </span><span class="sc1">需求分析</span>：</div><div class="t m0 x1 h4 y3 ff2 fs1 fc0 sc0 ls0 ws0">1.1 <span class="ff1 sc1">图书管理系统的需求定义为：</span></div><div class="t m0 x2 h5 y4 ff3 fs2 fc0 sc0 ls0 ws0">1.1.1<span class="_ _1"> </span><span class="ff1">使用读者编号、读者姓名、图书编号和图书姓名实现图书借阅功能；</span></div><div class="t m0 x2 h5 y5 ff3 fs2 fc0 sc0 ls0 ws0">1.1.2<span class="_ _1"> </span><span class="ff1">使用读者类型和类型编号实体<span class="_ _2"></span>对教师、学生和其他三种身份进行不同</span></div><div class="t m0 x2 h5 y6 ff1 fs2 fc0 sc0 ls0 ws0">的借阅条件管理；</div><div class="t m0 x2 h5 y7 ff3 fs2 fc0 sc0 ls0 ws0">1.1.3<span class="_ _1"> </span><span class="ff1">使用限借数量、借阅日期和归还日期实现不同身份的借阅管理功能；</span></div><div class="t m0 x1 h3 y8 ff1 fs0 fc0 sc1 ls0 ws0">二、<span class="_ _0"> </span>概要设计：</div><div class="t m0 x1 h4 y9 ff2 fs1 fc0 sc0 ls0 ws0">2.1 <span class="ff1 sc1">图书馆管理系统数据表设计：</span></div><div class="t m0 x2 h5 ya ff3 fs2 fc0 sc0 ls0 ws0">2.1.1 R<span class="_ _3"></span>eaders<span class="_ _1"> </span><span class="ff1">表：读者信息表，存取读者信息；</span></div><div class="t m0 x2 h5 yb ff3 fs2 fc0 sc0 ls0 ws0">2.1.2 Books<span class="_ _1"> </span><span class="ff1">表：图书信息表，存取图书信息；</span></div><div class="t m0 x2 h5 yc ff3 fs2 fc0 sc0 ls0 ws0">2.1.3 Borr<span class="_ _3"></span>owinf<span class="_ _1"> </span><span class="ff1">表：借阅信息表，管理借阅情况；</span></div><div class="t m0 x2 h5 yd ff3 fs2 fc0 sc0 ls0 ws0">2.1.4 R<span class="_ _3"></span>eadtype<span class="_ _1"> </span><span class="ff1">表：读者类型表，管理读者类型；</span></div><div class="t m0 x2 h5 ye ff1 fs2 fc0 sc0 ls0 ws0">这<span class="_ _4"></span>些<span class="_ _4"></span>数<span class="_ _4"></span>据<span class="_ _4"></span>表<span class="_ _4"></span>结<span class="_ _4"></span>合<span class="_ _4"></span>图<span class="_ _4"></span>书<span class="_ _4"></span>馆<span class="_ _4"></span>数<span class="_ _4"></span>据<span class="_ _4"></span>库<span class="_ _4"></span>中<span class="_ _4"></span>的<span class="_ _4"></span>四<span class="_ _4"></span>个<span class="_ _4"></span>存<span class="_ _4"></span>储<span class="_ _4"></span>过<span class="_ _4"></span>程<span class="_ _4"></span>，<span class="_ _4"></span>即<span class="_ _4"></span>实<span class="_ _4"></span>现<span class="_ _4"></span>了<span class="_ _4"></span>普<span class="_ _4"></span>通<span class="_ _4"></span>图<span class="_ _4"></span>书<span class="_ _4"></span>馆<span class="_ _4"></span>的</div><div class="t m0 x2 h5 yf ff1 fs2 fc0 sc0 ls0 ws0">大<span class="_ _4"></span>部<span class="_ _4"></span>分<span class="_ _4"></span>功<span class="_ _4"></span>能<span class="_ _4"></span>。<span class="_ _4"></span>如<span class="_ _4"></span>读<span class="_ _4"></span>者<span class="_ _4"></span>借<span class="_ _4"></span>阅<span class="_ _4"></span>图<span class="_ _4"></span>书<span class="_ _4"></span>功<span class="_ _4"></span>能<span class="_ _4"></span>、<span class="_ _4"></span>读<span class="_ _4"></span>者<span class="_ _4"></span>归<span class="_ _4"></span>还<span class="_ _4"></span>图<span class="_ _4"></span>书<span class="_ _4"></span>功<span class="_ _4"></span>能<span class="_ _4"></span>、<span class="_ _4"></span>读<span class="_ _4"></span>者<span class="_ _4"></span>查<span class="_ _4"></span>询<span class="_ _4"></span>图<span class="_ _4"></span>书<span class="_ _4"></span>借</div><div class="t m0 x2 h5 y10 ff1 fs2 fc0 sc0 ls0 ws0">阅情况功能、读者检索的图书信息功能；</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
</body>
</html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626db0dc3c16ee627a5ce572/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x3 h5 y11 ff1 fs3 fc0 sc1 ls0 ws0">图<span class="_ _5"> </span><span class="ff2 sc0">2.1 </span><span class="fs2">数据<span class="_ _1"> </span></span><span class="ff2 sc0">E-R<span class="_ _5"> </span></span>图</div><div class="t m0 x1 h3 y12 ff1 fs0 fc0 sc1 ls0 ws0">三、<span class="_ _0"> </span>逻辑设计</div><div class="t m0 x1 h4 y13 ff2 fs1 fc0 sc0 ls0 ws0">3.1 <span class="ff1 sc1">图书馆管理系统触发器设计：</span></div><div class="t m0 x2 h5 y14 ff3 fs2 fc0 sc0 ls0 ws0">3.1.1 <span class="_ _4"></span>T<span class="_ _6"></span>ri_bowbook <span class="_ _2"></span><span class="ff1">功<span class="_ _4"></span>能表<span class="_ _4"></span>现<span class="_ _4"></span>：<span class="_ _4"></span>只<span class="_ _4"></span>有<span class="_ _4"></span>在图<span class="_ _4"></span>书<span class="_ _4"></span>馆<span class="_ _4"></span>内<span class="_ _4"></span>相<span class="_ _4"></span>关书<span class="_ _4"></span>籍<span class="_ _4"></span>尚<span class="_ _4"></span>有<span class="_ _4"></span>库<span class="_ _4"></span>存的<span class="_ _4"></span>情<span class="_ _4"></span>况</span></div><div class="t m0 x2 h5 y15 ff1 fs2 fc0 sc0 ls0 ws0">下，读者才可以进行借阅操作；</div><div class="t m0 x2 h5 y16 ff3 fs2 fc0 sc0 ls0 ws0">3.1.2 T<span class="_ _6"></span>ri_bowbook2<span class="_ _1"> </span><span class="ff1">功能表现：还书时将还书信息更新到各表中；</span></div><div class="t m0 x2 h5 y17 ff3 fs2 fc0 sc0 ls0 ws0">3.1.3 T<span class="_ _6"></span>ri_bowbook3<span class="_ _1"> </span><span class="ff1">功<span class="_ _4"></span>能表现：限制借书<span class="_ _4"></span>数目，其中教<span class="_ _4"></span>师不得借阅超过<span class="_ _7"> </span></span>3</div><div class="t m0 x2 h5 y18 ff1 fs2 fc0 sc0 ls0 ws0">本，学生不得借阅超过<span class="_ _1"> </span><span class="ff3">2<span class="_ _1"> </span></span>本，其他人不得借阅超过<span class="_ _5"> </span><span class="ff3">1<span class="_ _1"> </span></span>本 <span class="_ _1"> </span>；</div><div class="t m0 x1 h3 y19 ff1 fs0 fc0 sc1 ls0 ws0">四、<span class="_ _0"> </span>物理设计：</div><div class="t m0 x4 h6 y1a ff1 fs3 fc0 sc1 ls0 ws0">表<span class="_ _5"> </span><span class="ff2 sc0">4.1 Readers</span></div><div class="t m0 x5 h5 y1b ff1 fs2 fc0 sc0 ls0 ws0">列名<span class="_ _8"> </span>数据类型<span class="_ _9"> </span>允许空值<span class="_ _a"> </span>说明</div><div class="t m0 x6 h7 y1c ff3 fs2 fc0 sc0 ls0 ws0">R<span class="_ _3"></span>eaderID<span class="_ _b"> </span>char(10)</div><div class="t m0 x7 h5 y1d ff1 fs2 fc0 sc0 ls0 ws0">否<span class="_ _c"> </span>标明读者唯一</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626db0dc3c16ee627a5ce572/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x8 h5 y1e ff1 fs2 fc0 sc0 ls0 ws0">编号</div><div class="t m0 x9 h7 y1f ff3 fs2 fc0 sc0 ls0 ws0">Name<span class="_ _d"> </span>char(8)</div><div class="t m0 x7 h5 y20 ff1 fs2 fc0 sc0 ls0 ws0">是<span class="_ _e"> </span>读者姓名</div><div class="t m0 xa h7 y21 ff3 fs2 fc0 sc0 ls0 ws0">Bor<span class="_ _3"></span>rowedQuant</div><div class="t m0 xb h7 y22 ff3 fs2 fc0 sc0 ls0 ws0">ity</div><div class="t m0 xc h7 y21 ff3 fs2 fc0 sc0 ls0 ws0">int</div><div class="t m0 x7 h5 y23 ff1 fs2 fc0 sc0 ls0 ws0">是<span class="_ _e"> </span>已借数目</div><div class="t m0 xd h7 y24 ff3 fs2 fc0 sc0 ls0 ws0">T<span class="_ _6"></span>ypeID<span class="_ _f"> </span>int</div><div class="t m0 x7 h5 y25 ff1 fs2 fc0 sc0 ls0 ws0">是<span class="_ _e"> </span>读者类型</div><div class="t m0 xe h6 y26 ff1 fs3 fc0 sc1 ls0 ws0">表<span class="_ _5"> </span><span class="ff2 sc0">4.2 Books</span></div><div class="t m0 xf h6 y27 ff1 fs3 fc0 sc0 ls0 ws0">列名<span class="_ _10"> </span>数据类型<span class="_ _11"> </span>允许空值<span class="_ _12"> </span>说明</div><div class="t m0 xf h8 y28 ff3 fs3 fc0 sc0 ls0 ws0">BookID<span class="_ _13"> </span>char(15)</div><div class="t m0 x10 h6 y29 ff1 fs3 fc0 sc0 ls0 ws0">否<span class="_ _14"> </span>标明图书唯一编号</div><div class="t m0 xf h8 y2a ff3 fs3 fc0 sc0 ls0 ws0">Name<span class="_ _15"> </span>var<span class="_ _3"></span>char(50)</div><div class="t m0 x10 h6 y2b ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _14"> </span>图书名称</div><div class="t m0 xf h8 y2c ff3 fs3 fc0 sc0 ls0 ws0">Author<span class="_ _16"> </span>char(8)</div><div class="t m0 x10 h6 y2d ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _14"> </span>图书作者</div><div class="t m0 xf h8 y2e ff3 fs3 fc0 sc0 ls0 ws0">Publisher<span class="_ _17"> </span>var<span class="_ _3"></span>char(30)</div><div class="t m0 x10 h6 y2f ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _14"> </span>出版社</div><div class="t m0 xf h8 y30 ff3 fs3 fc0 sc0 ls0 ws0">Standing<span class="_ _18"> </span>int</div><div class="t m0 x10 h6 y31 ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _14"> </span>剩余数量</div><div class="t m0 x3 h6 y32 ff1 fs3 fc0 sc1 ls0 ws0">表<span class="_ _5"> </span><span class="ff2 sc0">4.3 Borrowinf</span></div><div class="t m0 xf h6 y33 ff1 fs3 fc0 sc0 ls0 ws0">列名<span class="_ _10"> </span>数据类型<span class="_ _19"> </span>允许空值<span class="_ _1a"> </span>说明</div><div class="t m0 xf h8 y34 ff3 fs3 fc0 sc0 ls0 ws0">R<span class="_ _3"></span>eaderID<span class="_ _17"> </span>char(10)</div><div class="t m0 x11 h6 y35 ff1 fs3 fc0 sc0 ls0 ws0">否<span class="_ _1b"> </span>标明读者唯一编号</div><div class="t m0 xf h8 y36 ff3 fs3 fc0 sc0 ls0 ws0">BookID<span class="_ _13"> </span>char(15)</div><div class="t m0 x11 h6 y37 ff1 fs3 fc0 sc0 ls0 ws0">否<span class="_ _1b"> </span>标明图书唯一编号</div><div class="t m0 xf h8 y38 ff3 fs3 fc0 sc0 ls0 ws0">Borr<span class="_ _3"></span>owedDate<span class="_ _1c"> </span>datetime</div><div class="t m0 x11 h6 y39 ff1 fs3 fc0 sc0 ls0 ws0">否<span class="_ _1b"> </span>借书日期</div><div class="t m0 xf h8 y3a ff3 fs3 fc0 sc0 ls0 ws0">R<span class="_ _3"></span>etur<span class="_ _3"></span>nDate<span class="_ _1d"> </span>datetime</div><div class="t m0 x11 h6 y3b ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _1b"> </span>还书日期</div><div class="t m0 x12 h6 y3c ff1 fs3 fc0 sc1 ls0 ws0">表<span class="_ _5"> </span><span class="ff2 sc0">4.4 Readtype</span></div><div class="t m0 xf h6 y3d ff1 fs3 fc0 sc0 ls0 ws0">列名<span class="_ _1e"> </span>数据类型<span class="_ _1f"> </span>允许空值<span class="_ _20"> </span>说明</div><div class="t m0 xf h8 y3e ff3 fs3 fc0 sc0 ls0 ws0">T<span class="_ _6"></span>ypeID<span class="_ _21"> </span>int</div><div class="t m0 x13 h6 y3f ff1 fs3 fc0 sc0 ls0 ws0">否<span class="_ _22"> </span>标<span class="_ _23"> </span>明<span class="_ _23"> </span>类<span class="_ _23"> </span>型<span class="_ _23"> </span>唯<span class="_ _23"> </span>一<span class="_ _23"> </span>编</div><div class="t m0 x14 h6 y40 ff1 fs3 fc0 sc0 ls0 ws0">号</div><div class="t m0 xf h8 y41 ff3 fs3 fc0 sc0 ls0 ws0">Name<span class="_ _24"> </span>var<span class="_ _3"></span>char(20)</div><div class="t m0 x13 h6 y42 ff1 fs3 fc0 sc0 ls0 ws0">否<span class="_ _22"> </span>类型名称</div><div class="t m0 xf h8 y43 ff3 fs3 fc0 sc0 ls0 ws0">LimitBor<span class="_ _3"></span>rowQuanti</div><div class="t m0 xf h8 y44 ff3 fs3 fc0 sc0 ls0 ws0">ty</div><div class="t m0 x15 h8 y43 ff3 fs3 fc0 sc0 ls0 ws0">int</div><div class="t m0 x13 h6 y45 ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _22"> </span>限借数量</div><div class="t m0 xf h8 y46 ff3 fs3 fc0 sc0 ls0 ws0">Borr<span class="_ _3"></span>owT<span class="_ _6"></span>erm<span class="_ _9"> </span>i<span class="_ _3"></span>nt</div><div class="t m0 x13 h6 y47 ff1 fs3 fc0 sc0 ls0 ws0">是<span class="_ _22"> </span>限借时间</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
