<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://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/85827890/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/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://csdnimg.cn/release/download_crawler_static/85827890/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">数据库原理与应用</div><div class="t m0 x2 h4 y3 ff1 fs1 fc0 sc1 ls0 ws0">课程设计报告</div><div class="t m0 x3 h5 y4 ff2 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">选题名称 <span class="_ _0"></span><span class="sc0"> <span class="_ _0"></span> <span class="_ _1"></span> <span class="_ _2"> </span> 医院管理系统 <span class="_ _3"></span> <span class="_ _4"> </span> <span class="ff3 sc1"> <span class="_ _5"></span> <span class="_ _6"></span><span class="ff1 sc0"> <span class="_ _7"> </span> </span></span></span></span></div><div class="t m0 x4 h5 y5 ff4 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">专 业<span class="sc0"> <span class="_ _8"></span> <span class="_ _9"> </span> <span class="_ _8"></span> <span class="_ _9"> </span> <span class="_ _a"></span> <span class="_ _b"> </span> <span class="ff3 sc1"> <span class="_ _c"></span><span class="ff1 sc0"> <span class="_ _d"></span> </span></span></span></span></div><div class="t m0 x5 h5 y6 ff4 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">班 级<span class="sc0"> <span class="_ _e"></span> <span class="_ _f"> </span> <span class="_ _a"></span> <span class="_ _b"> </span> <span class="_ _8"></span> <span class="_ _9"> </span> <span class="ff3 sc1"> <span class="_ _c"></span><span class="ff1 sc0"> <span class="_ _10"></span> </span></span></span></span></div><div class="t m0 x4 h5 y7 ff4 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">学 号<span class="sc0"> <span class="_ _1"></span> <span class="_ _2"> </span> <span class="_ _a"></span> <span class="_ _b"> </span> <span class="_ _11"></span> <span class="_ _12"> </span> <span class="ff3 sc1"> <span class="_ _13"> </span> <span class="_ _14"></span><span class="ff1 sc0"> <span class="_ _15"> </span> </span></span></span></span></div><div class="t m0 x4 h5 y8 ff4 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">学生姓名<span class="sc0"> <span class="_ _8"></span> <span class="_ _9"> </span> <span class="_ _1"></span> <span class="_ _2"> </span> <span class="_ _16"></span> <span class="_ _17"> </span> </span></span></div><div class="t m0 x4 h5 y9 ff4 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">成 绩<span class="sc0"> <span class="_ _18"></span> <span class="_ _19"> </span> <span class="ff3 sc1"> <span class="_ _c"></span><span class="ff1 sc0"> <span class="_ _d"></span> </span></span></span></span></div><div class="t m0 x4 h5 ya ff4 fs2 fc0 sc1 ls0 ws0"> <span class="ff1">指导教师<span class="sc0"> <span class="_ _8"></span> <span class="_ _9"> </span> <span class="_ _e"></span> <span class="_ _f"> </span> <span class="_ _a"></span> <span class="_ _b"> </span> </span></span></div><div class="t m0 x6 h5 yb ff3 fs2 fc0 sc1 ls0 ws0">2022<span class="_ _1a"> </span><span class="ff1 sc0">年<span class="_ _1a"> </span></span>6<span class="_ _13"> </span><span class="ff1 sc0">月</span></div><div class="t m0 x7 h5 yc ff1 fs2 fc0 sc0 ls0 ws0">计算机学院</div><div class="t m0 x8 h6 yd ff2 fs3 fc0 sc1 ls0 ws0">1</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://csdnimg.cn/release/download_crawler_static/85827890/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x9 h5 ye ff1 fs2 fc0 sc0 ls0 ws0">医院管理系统</div><div class="t m0 xa h5 yf ff1 fs2 fc0 sc0 ls0 ws0">摘要</div><div class="t m0 xb h7 y10 ff4 fs4 fc0 sc1 ls0 ws0">SQL <span class="_ _5"></span>Server<span class="_ _13"> </span><span class="ff1">是<span class="_ _5"></span>由<span class="_ _13"> </span></span>Micr<span class="_ _d"></span>osof<span class="_ _d"></span>t<span class="_ _13"> </span><span class="ff1">开发<span class="_ _1b"></span>和<span class="_ _5"></span>推<span class="_ _5"></span>广<span class="_ _5"></span>的<span class="_ _1b"></span>关<span class="_ _5"></span>系<span class="_ _5"></span>数<span class="_ _5"></span>据<span class="_ _1b"></span>库<span class="_ _5"></span>管<span class="_ _1b"></span>理<span class="_ _5"></span>系<span class="_ _5"></span>统<span class="_ _5"></span>(<span class="_ _1c"></span></span>DBMS<span class="_ _5"></span><span class="ff1">)<span class="_ _5"></span>,</span></div><div class="t m0 x4 h7 y11 ff1 fs4 fc0 sc1 ls0 ws0">它<span class="_ _1d"></span>最<span class="_ _1d"></span>初<span class="_ _1d"></span>是<span class="_ _1d"></span>由<span class="_ _1e"> </span><span class="ff4">Micr<span class="_ _d"></span>osof<span class="_ _d"></span>t<span class="_ _1d"> </span><span class="ff1">、<span class="_ _1d"> </span></span>Sybase<span class="_"> </span><span class="ff1">和<span class="_ _1e"> </span></span>Ashton-<span class="_ _10"></span>T<span class="_ _1f"></span>ate<span class="_"> </span><span class="ff1">三<span class="_ _1d"> </span>家<span class="_ _1d"> </span>公<span class="_ _1d"></span>司<span class="_ _1d"></span>共<span class="_ _1d"></span>同<span class="_ _1d"></span>开<span class="_ _1d"></span>发<span class="_ _1d"></span>的<span class="_ _1c"></span>,<span class="_ _1d"> </span>并<span class="_ _1d"> </span>于</span></span></div><div class="t m0 x4 h7 y12 ff4 fs4 fc0 sc1 ls0 ws0">1988<span class="_ _13"> </span><span class="ff1">年<span class="_ _1b"></span>推<span class="_ _1b"></span>出<span class="_ _1b"></span>了<span class="_ _1b"></span>第<span class="_ _1b"></span>一<span class="_ _1b"></span>个<span class="_"> </span></span>OS/2<span class="_ _13"> </span><span class="ff1">版<span class="_ _5"></span>本<span class="_ _1c"></span>。<span class="_ _5"></span></span>Microsof<span class="_ _d"></span>t<span class="_ _5"></span> <span class="_ _5"></span>SQL<span class="_ _5"></span> <span class="_ _5"></span>Server<span class="_ _1a"> </span><span class="ff1">近<span class="_ _5"></span>年<span class="_ _1b"></span>来<span class="_ _1c"></span>不<span class="_ _5"></span>断<span class="_ _1b"></span>更<span class="_ _1b"></span>新<span class="_ _1b"></span>版<span class="_ _1b"></span>本<span class="_ _1c"></span>,</span></div><div class="t m0 x4 h7 y13 ff4 fs4 fc0 sc1 ls0 ws0">1996<span class="_ _13"> </span><span class="ff1">年<span class="_ _1b"></span>,<span class="_ _1c"></span></span>Micr<span class="_ _d"></span>osof<span class="_ _d"></span>t<span class="_ _1b"></span> <span class="_ _1b"></span><span class="ff1">推<span class="_ _1c"></span>出<span class="_ _5"></span>了<span class="_ _1a"> </span></span>SQL<span class="_ _5"></span> <span class="_ _5"></span>Server<span class="_ _5"></span> <span class="_ _5"></span>6.5<span class="_ _1a"> </span><span class="ff1">版<span class="_ _1b"></span>本<span class="_ _1b"></span>;<span class="_ _1c"></span></span>1998<span class="_ _13"> </span><span class="ff1">年<span class="_ _1b"></span>,<span class="_ _1b"></span></span>SQL<span class="_ _5"></span> <span class="_ _5"></span>Server7.0</div><div class="t m0 x4 h7 y14 ff1 fs4 fc0 sc1 ls0 ws0">版<span class="_ _5"></span>本<span class="_ _1b"></span>和<span class="_ _5"></span>用<span class="_ _5"></span>户<span class="_ _1b"></span>见<span class="_ _5"></span>面<span class="_ _1b"></span>;<span class="_ _1c"></span><span class="ff4">SQL <span class="_ _5"></span>Server <span class="_ _5"></span>2000<span class="_ _1a"> </span></span>是<span class="_ _20"> </span><span class="ff4">Micr<span class="_ _d"></span>osof<span class="_ _d"></span>t<span class="_ _13"> </span><span class="ff1">公<span class="_ _5"></span>司<span class="_ _1b"></span>于<span class="_ _13"> </span></span>2000<span class="_ _20"> </span><span class="ff1">年<span class="_ _5"></span>推<span class="_ _1b"></span>出<span class="_ _5"></span>,<span class="_ _1b"></span>目<span class="_ _5"></span>前<span class="_ _1b"></span>最</span></span></div><div class="t m0 x4 h7 y15 ff1 fs4 fc0 sc1 ls0 ws0">新版本是<span class="_ _21"> </span><span class="ff4">2017<span class="_ _21"> </span></span>年份推出的<span class="_ _21"> </span><span class="ff4">SQL Server 2017</span>。</div><div class="t m0 xb h7 y16 ff1 fs4 fc0 sc1 ls0 ws0">本次<span class="_ _5"></span>课<span class="_ _5"></span>程<span class="_ _5"></span>设计<span class="_ _5"></span>正<span class="_ _5"></span>是<span class="_ _5"></span>利用<span class="_ _13"> </span><span class="ff4">SQL<span class="_ _5"></span> Server <span class="_ _5"></span>2017<span class="_ _20"> </span></span>软<span class="_ _5"></span>件<span class="_ _5"></span>设计<span class="_ _5"></span>了<span class="_ _5"></span>医<span class="_ _5"></span>院管<span class="_ _5"></span>理<span class="_ _5"></span>系<span class="_ _5"></span>统的<span class="_ _5"></span>数<span class="_ _5"></span>据<span class="_ _5"></span>库<span class="_ _1c"></span>。</div><div class="t m0 x4 h7 y17 ff1 fs4 fc0 sc1 ls0 ws0">随着人<span class="_ _5"></span>们生活水<span class="_ _5"></span>平的不<span class="_ _5"></span>断提高<span class="_ _1c"></span><span class="ff4">,</span>人们<span class="_ _5"></span>更重视<span class="_ _5"></span>医疗设<span class="_ _5"></span>施<span class="_ _1b"></span><span class="ff4">,</span>医<span class="_ _5"></span>院的业<span class="_ _5"></span>务也不<span class="_ _5"></span>断增加<span class="_ _1b"></span><span class="ff4">,<span class="_ _5"></span></span>而对于</div><div class="t m0 x4 h7 y18 ff1 fs4 fc0 sc1 ls0 ws0">医院<span class="_ _5"></span>来<span class="_ _5"></span>讲<span class="_ _5"></span><span class="ff4">,<span class="_ _5"></span></span>信<span class="_ _5"></span>息<span class="_ _5"></span>管理<span class="_ _5"></span>系<span class="_ _5"></span>统<span class="_ _5"></span>属于<span class="_ _5"></span>其<span class="_ _5"></span>重<span class="_ _5"></span>要组<span class="_ _5"></span>成<span class="_ _5"></span>部<span class="_ _5"></span>分<span class="_ _1c"></span><span class="ff4">,</span>确<span class="_ _5"></span>保<span class="_ _5"></span>系<span class="_ _5"></span>统高<span class="_ _5"></span>效<span class="_ _5"></span>、<span class="_ _5"></span>稳定<span class="_ _5"></span>且<span class="_ _5"></span>安<span class="_ _5"></span>全的<span class="_ _5"></span>运<span class="_ _5"></span>行<span class="_ _5"></span>是</div><div class="t m0 x4 h7 y19 ff1 fs4 fc0 sc1 ls0 ws0">医院应<span class="_ _5"></span>关注和解<span class="_ _5"></span>决的问<span class="_ _5"></span>题<span class="_ _1b"></span><span class="ff4">,<span class="_ _5"></span></span>为使信<span class="_ _5"></span>息系统<span class="_ _5"></span>稳定、<span class="_ _5"></span>安全<span class="_ _1c"></span><span class="ff4">,</span>高可用<span class="_ _5"></span><span class="ff4">,</span>工作<span class="_ _5"></span>人员需<span class="_ _5"></span>管理好<span class="_ _5"></span>信息</div><div class="t m0 x4 h7 y1a ff1 fs4 fc0 sc1 ls0 ws0">系统<span class="_ _5"></span><span class="ff4">,<span class="_ _5"></span></span>重<span class="_ _5"></span>视<span class="_ _5"></span>数据<span class="_ _5"></span>库<span class="_ _5"></span>安<span class="_ _5"></span>全<span class="_ _1b"></span><span class="ff4">,<span class="_ _5"></span></span>进而<span class="_ _5"></span>使<span class="_ _5"></span>信<span class="_ _5"></span>息数<span class="_ _5"></span>据<span class="_ _5"></span>将<span class="_ _5"></span>自身<span class="_ _5"></span>作<span class="_ _5"></span>用<span class="_ _5"></span>与价<span class="_ _5"></span>值<span class="_ _5"></span>充<span class="_ _5"></span>分发<span class="_ _5"></span>挥<span class="_ _5"></span>出<span class="_ _5"></span>来。<span class="_ _5"></span>本<span class="_ _5"></span>设<span class="_ _5"></span>计中</div><div class="t m0 x4 h7 y1b ff1 fs4 fc0 sc1 ls0 ws0">主要进<span class="_ _5"></span>行了需求<span class="_ _5"></span>分析、<span class="_ _5"></span>概念结<span class="_ _5"></span>构设计<span class="_ _5"></span>、逻辑<span class="_ _5"></span>结构设<span class="_ _5"></span>计、数<span class="_ _5"></span>据物理<span class="_ _5"></span>设计与<span class="_ _5"></span>实施、<span class="_ _5"></span>数据</div><div class="t m0 x4 h7 y1c ff1 fs4 fc0 sc1 ls0 ws0">操作、数据库运行与维护等操作。</div><div class="t m0 x8 h6 yd ff2 fs3 fc0 sc1 ls0 ws0">2</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://csdnimg.cn/release/download_crawler_static/85827890/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x4 h5 y1d ff1 fs2 fc0 sc0 ls0 ws0">目录</div><div class="t m0 x4 h8 y1e ff1 fs5 fc0 sc1 ls0 ws0">摘要<span class="ff2">................<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _1c"></span>2</span></div><div class="t m0 x4 h8 y1f ff2 fs5 fc0 sc1 ls0 ws0">1. <span class="ff1">概述</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>........<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _1c"></span>5</div><div class="t m0 x4 h8 y20 ff2 fs5 fc0 sc1 ls0 ws0">2. <span class="ff1">课程设计任务的需求分析</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>5</div><div class="t m0 xc h8 y21 ff2 fs5 fc0 sc1 ls0 ws0">2.1 <span class="ff1">设计任务</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>5</div><div class="t m0 xc h8 y22 ff2 fs5 fc0 sc1 ls0 ws0">2.2<span class="_"> </span><span class="ff1">设计要求<span class="_ _d"></span><span class="ff2">............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>.........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>5</span></span></div><div class="t m0 xc h8 y23 ff2 fs5 fc0 sc1 ls0 ws0">2.3 <span class="ff1">需求描述的规范文档(数据字典、数据流图等)</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1b"></span>7</div><div class="t m0 xd h8 y24 ff2 fs5 fc0 sc1 ls0 ws0">2.3.1<span class="_"> </span><span class="ff1">数据流图(</span>DF<span class="_ _d"></span>D<span class="ff1">,</span>Data Flow Diagram<span class="ff1">)</span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>.<span class="_ _1b"></span>7</div><div class="t m0 xd h8 y25 ff2 fs5 fc0 sc1 ls0 ws0">2.3.2<span class="_"> </span><span class="ff1">数据字典(</span>DD<span class="ff1">,</span>Data <span class="_ _d"></span>Diconary<span class="ff1">)</span>.........<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>.......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1b"></span>7</div><div class="t m0 x4 h8 y26 ff2 fs5 fc0 sc1 ls0 ws0">3. <span class="ff1">概念结构设计</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>15</div><div class="t m0 xc h8 y27 ff2 fs5 fc0 sc1 ls0 ws0">3.1 <span class="ff1">概念结构设计工具(</span>E-R<span class="_ _21"> </span><span class="ff1">模型)简介<span class="_ _d"></span><span class="ff2">............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>........<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1b"></span>15</span></span></div><div class="t m0 xc h8 y28 ff2 fs5 fc0 sc1 ls0 ws0">3.2<span class="_"> </span><span class="ff1">实体子系统<span class="_ _d"></span><span class="ff2">............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>15</span></span></div><div class="t m0 xd h8 y29 ff2 fs5 fc0 sc1 ls0 ws0">3.2.1 <span class="ff1">子系统描述</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>.....<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>15</div><div class="t m0 xd h8 y2a ff2 fs5 fc0 sc1 ls0 ws0">3.2.2 <span class="ff1">分<span class="_ _21"> </span></span>E-R<span class="_ _22"> </span><span class="ff1">图</span>................<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>.......<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>15</div><div class="t m0 xd h8 y2b ff2 fs5 fc0 sc1 ls0 ws0">3.2.3 <span class="ff1">说明</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>17</div><div class="t m0 xc h8 y2c ff2 fs5 fc0 sc1 ls0 ws0">3.3 <span class="ff1">实体集联系子系统</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>.....<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>18</div><div class="t m0 xd h8 y2d ff2 fs5 fc0 sc1 ls0 ws0">3.3.1 <span class="ff1">子系统描述</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>.....<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>18</div><div class="t m0 xd h8 y2e ff2 fs5 fc0 sc1 ls0 ws0"> 3.3.2 <span class="ff1">分<span class="_ _22"> </span></span>E-R<span class="_"> </span><span class="ff1">图</span>....................<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>.<span class="_ _1c"></span>18</div><div class="t m0 xd h8 y2f ff2 fs5 fc0 sc1 ls0 ws0">3.3.3 <span class="ff1">说明</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>18</div><div class="t m0 xc h8 y30 ff2 fs5 fc0 sc1 ls0 ws0">3.4 <span class="ff1">总体<span class="_ _22"> </span></span>E-R<span class="_"> </span><span class="ff1">图</span>.......................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>....<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>18</div><div class="t m0 xd h8 y31 ff2 fs5 fc0 sc1 ls0 ws0">3.4.1 E-R<span class="_"> </span><span class="ff1">图集成<span class="_ _d"></span><span class="ff2">.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>18</span></span></div><div class="t m0 xd h8 y32 ff2 fs5 fc0 sc1 ls0 ws0">3.4.2 <span class="ff1">总体<span class="_ _22"> </span></span>E-R<span class="_"> </span><span class="ff1">图</span>....................<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>.........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>18</div><div class="t m0 x4 h8 y33 ff2 fs5 fc0 sc1 ls0 ws0">4. <span class="ff1">逻辑结构设计</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>19</div><div class="t m0 xc h8 y34 ff2 fs5 fc0 sc1 ls0 ws0">4.1 <span class="ff1">关系数据模式</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>19</div><div class="t m0 xc h8 y35 ff2 fs5 fc0 sc1 ls0 ws0">4.2 <span class="ff1">用户视图设计</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>20</div><div class="t m0 xc h8 y36 ff2 fs5 fc0 sc1 ls0 ws0">4.3 <span class="ff1">模式优化</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>21</div><div class="t m0 xd h8 y37 ff2 fs5 fc0 sc1 ls0 ws0">4.3.1 <span class="ff1">指出数据依赖</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>..........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>21</div><div class="t m0 xd h8 y38 ff2 fs5 fc0 sc1 ls0 ws0">4.3.2 <span class="ff1">对数据进行极小化处理,并指明范式级别</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1b"></span>22</div><div class="t m0 xd h8 y39 ff2 fs5 fc0 sc1 ls0 ws0">4.3.3 <span class="ff1">提高系统效率</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>..........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>22</div><div class="t m0 x4 h8 y3a ff2 fs5 fc0 sc1 ls0 ws0">5. <span class="ff1">数据库物理设计与实施</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>.....<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>23</div><div class="t m0 x8 h6 yd ff2 fs3 fc0 sc1 ls0 ws0">3</div></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/85827890/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 xc h8 y3b ff2 fs5 fc0 sc1 ls0 ws0">5.1 <span class="ff1">数据库应用的硬件、软件环境介绍</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>....<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1b"></span>23</div><div class="t m0 xd h8 y3c ff2 fs5 fc0 sc1 ls0 ws0">5.1.1 <span class="ff1">数据库应用的硬件介绍</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>.........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1b"></span>23</div><div class="t m0 xd h8 y3d ff2 fs5 fc0 sc1 ls0 ws0">5.1.2 <span class="ff1">软件环境介绍</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>..........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>23</div><div class="t m0 xc h8 y3e ff2 fs5 fc0 sc1 ls0 ws0">5.2 <span class="ff1">物理结构设计</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>23</div><div class="t m0 xc h8 y3f ff2 fs5 fc0 sc1 ls0 ws0">5.3 <span class="ff1">索引的设计</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>26</div><div class="t m0 xc h8 y40 ff2 fs5 fc0 sc1 ls0 ws0">5.4 <span class="ff1">建立数据库</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>26</div><div class="t m0 xd h8 y41 ff2 fs5 fc0 sc1 ls0 ws0">5.4.1<span class="_"> </span><span class="ff1">建立数据库<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>26</span></span></div><div class="t m0 xd h8 y42 ff2 fs5 fc0 sc1 ls0 ws0">5.4.2<span class="_"> </span><span class="ff1">建立基本表<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>26</span></span></div><div class="t m0 xd h8 y43 ff2 fs5 fc0 sc1 ls0 ws0">5.4.3<span class="_"> </span><span class="ff1">建立索引<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>.......<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>29</span></span></div><div class="t m0 xd h8 y44 ff2 fs5 fc0 sc1 ls0 ws0">5.4.4<span class="_"> </span><span class="ff1">建立视图<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>.......<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>31</span></span></div><div class="t m0 xd h8 y45 ff2 fs5 fc0 sc1 ls0 ws0">5.4.5<span class="_"> </span><span class="ff1">建立触发器<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>35</span></span></div><div class="t m0 xd h8 y46 ff2 fs5 fc0 sc1 ls0 ws0">5.4.6<span class="_"> </span><span class="ff1">建立存储过程<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>.......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>.<span class="_ _1c"></span>38</span></span></div><div class="t m0 xc h8 y47 ff2 fs5 fc0 sc1 ls0 ws0">5.5 <span class="ff1">加载测试数据</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>39</div><div class="t m0 xd h8 y48 ff2 fs5 fc0 sc1 ls0 ws0">5.5.1<span class="_"> </span><span class="ff1">向病人表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _1c"></span>39</span></span></div><div class="t m0 xd h8 y49 ff2 fs5 fc0 sc1 ls0 ws0">5.5.2<span class="_"> </span><span class="ff1">向医生表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _1c"></span>40</span></span></div><div class="t m0 xd h8 y4a ff2 fs5 fc0 sc1 ls0 ws0">5.5.3<span class="_"> </span><span class="ff1">向科室表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _1c"></span>41</span></span></div><div class="t m0 xd h8 y4b ff2 fs5 fc0 sc1 ls0 ws0">5.5.4<span class="_"> </span><span class="ff1">向病房表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _1c"></span>42</span></span></div><div class="t m0 xd h8 y4c ff2 fs5 fc0 sc1 ls0 ws0">5.5.5<span class="_"> </span><span class="ff1">向药品表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _1c"></span>43</span></span></div><div class="t m0 xd h8 y4d ff2 fs5 fc0 sc1 ls0 ws0">5.5.6<span class="_"> </span><span class="ff1">向药房表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _1c"></span>44</span></span></div><div class="t m0 xd h8 y4e ff2 fs5 fc0 sc1 ls0 ws0">5.5.7<span class="_"> </span><span class="ff1">向药房管理人表中加载测试数据<span class="_ _d"></span><span class="ff2">..............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>...........<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1b"></span>45</span></span></div><div class="t m0 x4 h8 y4f ff2 fs5 fc0 sc1 ls0 ws0">6. <span class="ff1">数据库运行与维护</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>47</div><div class="t m0 xc h8 y50 ff2 fs5 fc0 sc1 ls0 ws0">6.1 <span class="ff1">数据查询操作</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>47</div><div class="t m0 xc h8 y51 ff2 fs5 fc0 sc1 ls0 ws0">6.2 <span class="ff1">数据更新操作</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>...<span class="_ _5"></span>..<span class="_ _1c"></span>48</div><div class="t m0 xc h8 y52 ff2 fs5 fc0 sc1 ls0 ws0">6.3 <span class="ff1">数据维护</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>48</div><div class="t m0 xc h8 y53 ff2 fs5 fc0 sc1 ls0 ws0">6.4 <span class="ff1">其他</span>................<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>.<span class="_ _1c"></span>49</div><div class="t m0 x4 h8 y54 ff2 fs5 fc0 sc1 ls0 ws0">7. <span class="ff1">总结</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>.......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>52</div><div class="t m0 x4 h8 y55 ff2 fs5 fc0 sc1 ls0 ws0">8. <span class="ff1">主要参考文献</span>.............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>...........<span class="_ _5"></span>............<span class="_ _5"></span>......<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _5"></span>..<span class="_ _1c"></span>53</div><div class="t m0 x8 h6 yd ff2 fs3 fc0 sc1 ls0 ws0">4</div></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/85827890/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 xe h5 ye ff3 fs2 fc0 sc1 ls0 ws0">1. <span class="ff1 sc0">概述</span></div><div class="t m0 xf h9 y56 ff4 fs6 fc0 sc1 ls0 ws0">SQL <span class="_ _5"></span>Server<span class="_ _21"> </span><span class="ff1">是<span class="_ _5"></span>时<span class="_ _5"></span>下<span class="_ _5"></span>比较<span class="_ _1b"></span>流行<span class="_ _5"></span>的<span class="_ _5"></span>数<span class="_ _5"></span>据<span class="_ _5"></span>库<span class="_ _5"></span>,<span class="_ _5"></span>利<span class="_ _5"></span>用<span class="_"> </span></span>SQL Server<span class="_ _21"> </span><span class="ff1">可<span class="_ _1b"></span>以做<span class="_ _5"></span>很<span class="_ _5"></span>多<span class="_ _5"></span>管<span class="_ _5"></span>理<span class="_ _5"></span>系<span class="_ _5"></span>统<span class="_ _5"></span>,<span class="_ _5"></span>此<span class="_ _5"></span>次<span class="_ _5"></span>我</span></div><div class="t m0 x4 h9 y57 ff1 fs6 fc0 sc1 ls0 ws0">的选题为:医院管理系统。</div><div class="t m0 xf h9 y58 ff1 fs6 fc0 sc1 ls0 ws0">本次<span class="_ _5"></span>课程<span class="_ _5"></span>设计<span class="_ _5"></span>的<span class="_ _5"></span>项目<span class="_ _5"></span>背景<span class="_ _5"></span>为:<span class="_ _5"></span>医<span class="_ _5"></span>院管<span class="_ _5"></span>理<span class="_ _5"></span>工作<span class="_ _5"></span>质量<span class="_ _5"></span>的高<span class="_ _5"></span>低和<span class="_ _5"></span>医院<span class="_ _5"></span>的信<span class="_ _5"></span>息<span class="_ _5"></span>化管<span class="_ _5"></span>理水<span class="_ _5"></span>平<span class="_ _5"></span>在一<span class="_ _5"></span>定程</div><div class="t m0 x4 ha y59 ff1 fs6 fc0 sc1 ls0 ws0">度上<span class="_ _5"></span>是有<span class="_ _5"></span>紧密<span class="_ _5"></span>的<span class="_ _5"></span>联系<span class="_ _5"></span>的。<span class="_ _5"></span>医院<span class="_ _5"></span>管理<span class="_ _5"></span>工作<span class="_ _1b"></span><span class="ff5">能</span>不<span class="_ _5"></span><span class="ff5">能</span>实<span class="_ _5"></span><span class="ff5">现</span>信<span class="_ _5"></span>息管<span class="_ _5"></span>理<span class="_ _5"></span><span class="ff5">现代<span class="_ _5"></span></span>化<span class="_ _5"></span>,与<span class="_ _5"></span>医院<span class="_ _5"></span>是<span class="ff5">否<span class="_ _5"></span></span>建<span class="_ _5"></span>立并<span class="_ _5"></span><span class="ff5">完善<span class="_ _5"></span></span>了</div><div class="t m0 x4 ha y5a ff5 fs6 fc0 sc1 ls0 ws0">相<span class="ff1">关<span class="_ _5"></span>的规<span class="_ _5"></span>范<span class="_ _5"></span></span>制<span class="ff1">度<span class="_ _5"></span>是有<span class="_ _5"></span>重要<span class="_ _5"></span>联系<span class="_ _5"></span>的,<span class="_ _1b"></span></span>取<span class="ff1">决<span class="_ _5"></span>于计<span class="_ _5"></span>算机<span class="_ _5"></span></span>技术<span class="_ _5"></span><span class="ff1">在<span class="_ _5"></span>信息<span class="_ _5"></span>管理<span class="_ _5"></span>系统<span class="_ _5"></span>中<span class="_ _5"></span></span>能<span class="ff1">不<span class="_ _5"></span></span>能得<span class="_ _5"></span>到<span class="_ _5"></span><span class="ff1">广</span>泛<span class="_ _5"></span>地<span class="_ _5"></span><span class="ff1">应用</span></div><div class="t m0 x4 ha y5b ff1 fs6 fc0 sc1 ls0 ws0">与体<span class="_ _5"></span><span class="ff5">现</span>。<span class="_ _5"></span><span class="ff5">若<span class="_ _5"></span>能</span>很<span class="_ _5"></span>好<span class="ff5">地<span class="_ _5"></span></span>将计<span class="_ _5"></span>算机<span class="_ _5"></span><span class="ff5">网<span class="_ _5"></span>络技<span class="_ _5"></span>术<span class="_ _5"></span></span>应用<span class="_ _5"></span>在医<span class="_ _5"></span>院信<span class="_ _5"></span>息管<span class="_ _5"></span>理系<span class="_ _5"></span>统<span class="_ _5"></span>中,<span class="_ _5"></span><span class="ff5">就<span class="_ _5"></span>能显<span class="_ _5"></span></span>着提<span class="_ _5"></span><span class="ff5">升<span class="_ _5"></span></span>医院<span class="_ _5"></span>的管<span class="_ _5"></span>理</div><div class="t m0 x4 ha y5c ff1 fs6 fc0 sc1 ls0 ws0">水平<span class="_ _5"></span>,实<span class="_ _5"></span><span class="ff5">现<span class="_ _5"></span></span>医院<span class="_ _5"></span>全面<span class="_ _5"></span>管理<span class="_ _5"></span>工作<span class="_ _5"></span>的规<span class="_ _5"></span>范<span class="_ _5"></span>化和<span class="_ _5"></span>科学<span class="_ _5"></span>化<span class="_ _5"></span>,对<span class="_ _5"></span>于医<span class="_ _5"></span>院的<span class="_ _5"></span>发<span class="_ _5"></span><span class="ff5">展<span class="_ _5"></span>十</span>分<span class="_ _5"></span>有利<span class="_ _5"></span>,<span class="ff5">能<span class="_ _5"></span>够<span class="_ _5"></span></span>更好<span class="_ _5"></span>为广<span class="_ _5"></span><span class="ff5">大</span></div><div class="t m0 x4 ha y5d ff5 fs6 fc0 sc1 ls0 ws0">患者<span class="_ _5"></span>造福<span class="_ _5"></span><span class="ff1">。<span class="_ _5"></span>数据<span class="_ _5"></span>库的<span class="_ _5"></span>管理<span class="_ _5"></span>可以<span class="_ _5"></span>更加<span class="_ _5"></span>科<span class="_ _5"></span>学和<span class="_ _5"></span></span>方<span class="_ _5"></span>便地<span class="_ _5"></span><span class="ff1">管理<span class="_ _5"></span>医<span class="_ _5"></span>院</span>涉<span class="_ _5"></span>及地<span class="_ _5"></span>各<span class="_ _5"></span><span class="ff1">个人<span class="_ _5"></span>工不<span class="_ _5"></span></span>方便<span class="_ _5"></span>地<span class="_ _5"></span><span class="ff1">部分<span class="_ _5"></span>,比<span class="_ _5"></span></span>如</div><div class="t m0 x4 ha y5e ff1 fs6 fc0 sc1 ls0 ws0">对于<span class="_ _5"></span><span class="ff5">大</span>库<span class="_ _5"></span>存<span class="_ _5"></span>的药<span class="_ _5"></span>物管<span class="_ _5"></span>理,<span class="_ _5"></span>可以<span class="_ _5"></span><span class="ff5">快<span class="_ _5"></span>速<span class="_ _5"></span></span>了解<span class="_ _5"></span>库存<span class="_ _5"></span>,解<span class="_ _5"></span>决库<span class="_ _5"></span>存<span class="_ _5"></span><span class="ff5">积压<span class="_ _5"></span></span>和<span class="_ _5"></span><span class="ff5">宫</span>药<span class="_ _5"></span>不<span class="ff5">足<span class="_ _5"></span></span>的<span class="ff5">情<span class="_ _5"></span>况</span>,<span class="_ _5"></span>有<span class="_ _5"></span>着<span class="ff5">非<span class="_ _5"></span>常<span class="_ _5"></span></span>实用</div><div class="t m0 x4 ha y5f ff1 fs6 fc0 sc1 ls0 ws0">的价<span class="_ _5"></span>值。<span class="_ _5"></span>在病<span class="_ _5"></span><span class="ff5">历<span class="_ _5"></span></span>管理<span class="_ _5"></span>与统<span class="_ _5"></span>计管<span class="_ _5"></span>理<span class="_ _5"></span><span class="ff5">方<span class="_ _5"></span></span>面应<span class="_ _5"></span>用计<span class="_ _5"></span>算机<span class="_ _5"></span><span class="ff5">网络<span class="_ _5"></span>技<span class="_ _5"></span>术</span>主<span class="_ _5"></span>要是<span class="_ _5"></span>对<span class="_ _5"></span>医院<span class="_ _5"></span><span class="ff5">死亡<span class="_ _5"></span></span>率、<span class="_ _5"></span><span class="ff5">治<span class="_ _5"></span>愈</span>率<span class="_ _5"></span>、<span class="_ _5"></span><span class="ff5">剩余</span></div><div class="t m0 x4 ha y60 ff5 fs6 fc0 sc1 ls0 ws0">床位<span class="_ _5"></span><span class="ff1">等</span>情<span class="_ _5"></span>况<span class="_ _5"></span><span class="ff1">进行<span class="_ _5"></span>统计<span class="_ _5"></span>,</span>这<span class="_ _5"></span>样大<span class="_ _5"></span>大<span class="_ _5"></span><span class="ff1">提<span class="_ _5"></span></span>升<span class="ff1">了<span class="_ _5"></span>医院<span class="_ _5"></span>工作<span class="_ _5"></span>的效<span class="_ _5"></span>率,<span class="_ _5"></span>使<span class="_ _5"></span></span>资源<span class="_ _5"></span><span class="ff1">的<span class="_ _5"></span>利用<span class="_ _5"></span>率</span>大<span class="_ _5"></span>大<span class="ff1">提<span class="_ _5"></span></span>升<span class="_ _5"></span><span class="ff1">,</span>促<span class="_ _5"></span><span class="ff1">进<span class="_ _5"></span>医院</span></div><div class="t m0 x4 ha y61 ff5 fs6 fc0 sc1 ls0 ws0">各<span class="ff1">项工作实</span>现<span class="ff1">规范</span>性<span class="ff1">与科学</span>性<span class="ff1">。</span></div><div class="t m0 xf ha y62 ff1 fs6 fc0 sc1 ls0 ws0">本次<span class="_ _5"></span>课程<span class="_ _5"></span>设计<span class="_ _5"></span>的<span class="_ _5"></span><span class="ff5">编写<span class="_ _5"></span></span>目的<span class="_ _5"></span>在于<span class="_ _5"></span>:<span class="_ _5"></span>加<span class="_ _5"></span><span class="ff5">深</span>对<span class="_ _20"> </span><span class="ff4">SQL <span class="_ _5"></span>Server<span class="_ _21"> </span><span class="ff5">知识<span class="_ _5"></span></span></span>的应<span class="_ _5"></span>用<span class="ff5">能<span class="_ _5"></span>力<span class="_ _5"></span></span>,<span class="ff5">把<span class="_ _5"></span></span>课本<span class="_ _5"></span>信息<span class="_ _5"></span>用于<span class="_ _5"></span>实</div><div class="t m0 x4 ha y63 ff5 fs6 fc0 sc1 ls0 ws0">践<span class="ff1">。<span class="_ _5"></span></span>鉴<span class="_ _5"></span><span class="ff1">于<span class="_ _5"></span>此目<span class="_ _5"></span>的<span class="_ _5"></span>,<span class="_ _5"></span>我利<span class="_ _5"></span>用<span class="_ _20"> </span><span class="ff4">SQL <span class="_ _5"></span>Server <span class="_ _5"></span>2000<span class="_ _21"> </span></span></span>技<span class="_ _5"></span>术<span class="ff1">设<span class="_ _5"></span>计<span class="_ _5"></span>了<span class="_ _5"></span>此医<span class="_ _5"></span>院<span class="_ _5"></span>管<span class="_ _5"></span>理数<span class="_ _5"></span>据<span class="_ _5"></span>库系<span class="_ _5"></span>统<span class="_ _5"></span>,<span class="_ _5"></span>以利<span class="_ _5"></span>用<span class="_ _5"></span>计<span class="_ _5"></span>算</span></div><div class="t m0 x4 ha y64 ff1 fs6 fc0 sc1 ls0 ws0">机<span class="ff5">完<span class="_ _5"></span></span>成病<span class="_ _5"></span>人<span class="_ _5"></span><span class="ff5">入</span>院<span class="_ _5"></span><span class="ff5">后</span>,<span class="_ _5"></span>对其<span class="_ _5"></span>基本<span class="_ _5"></span>信<span class="_ _5"></span>息、<span class="_ _5"></span>主<span class="_ _5"></span><span class="ff5">治</span>医<span class="_ _5"></span>师以<span class="_ _5"></span><span class="ff5">及入<span class="_ _5"></span>住<span class="_ _5"></span></span>病房<span class="_ _5"></span>等信<span class="_ _5"></span>息<span class="_ _5"></span>进行<span class="_ _5"></span>数据<span class="_ _5"></span>库管<span class="_ _5"></span>理,<span class="_ _5"></span>有利<span class="_ _5"></span>于提</div><div class="t m0 x4 ha y65 ff1 fs6 fc0 sc1 ls0 ws0">高<span class="ff5">入<span class="_ _5"></span></span>院<span class="ff5">手<span class="_ _5"></span>续<span class="_ _5"></span></span>的<span class="ff5">办<span class="_ _5"></span></span>理<span class="ff5">速<span class="_ _5"></span></span>度以<span class="_ _5"></span><span class="ff5">及<span class="_ _5"></span></span>对医<span class="_ _5"></span>院<span class="_ _5"></span><span class="ff5">资源<span class="_ _5"></span></span>管理<span class="_ _5"></span>的效<span class="_ _5"></span>率。<span class="_ _5"></span>同时<span class="_ _5"></span>可以<span class="_ _1b"></span><span class="ff5">落</span>实<span class="_ _5"></span><span class="ff5">责</span>任<span class="_ _5"></span>,<span class="ff5">方<span class="_ _5"></span>便</span>信<span class="_ _5"></span>息<span class="_ _5"></span>的集<span class="_ _5"></span>中化<span class="_ _5"></span>管</div><div class="t m0 x4 ha y66 ff1 fs6 fc0 sc1 ls0 ws0">理<span class="ff5">及</span>应用。</div><div class="t m0 xf ha y67 ff1 fs6 fc0 sc1 ls0 ws0">本次<span class="_ _5"></span>课程<span class="_ _5"></span>设计<span class="_ _5"></span>报<span class="_ _5"></span>告的<span class="_ _5"></span>组<span class="ff5">织<span class="_ _5"></span></span>:<span class="_ _5"></span><span class="ff5">该</span>实<span class="_ _5"></span><span class="ff5">验<span class="_ _5"></span></span>报告<span class="_ _5"></span>主要<span class="_ _5"></span><span class="ff5">包括<span class="_ _5"></span></span>摘要<span class="_ _5"></span>、<span class="_ _5"></span>概述<span class="_ _5"></span>、需<span class="_ _5"></span>求分<span class="_ _5"></span>析<span class="_ _5"></span>、概<span class="_ _5"></span>念结<span class="_ _5"></span>构设<span class="_ _5"></span>计、</div><div class="t m0 x4 h9 y68 ff1 fs6 fc0 sc1 ls0 ws0">逻辑结构设计、数据库物理设计与实施、数据库运行与维护、总结、参考文献等部分组成</div><div class="t m0 x10 h5 y69 ff6 fs2 fc0 sc1 ls0 ws0">2. <span class="ff1 sc0">课程设计任务的需求分析</span></div><div class="t m0 xb h7 y6a ff3 fs4 fc0 sc1 ls0 ws0">2.1 <span class="ff1 sc0">设计任务</span></div><div class="t m0 xf ha y6b ff5 fs6 fc0 sc1 ls0 ws0">根<span class="ff1">据<span class="_ _5"></span>医院<span class="_ _5"></span>管<span class="_ _5"></span>理系<span class="_ _5"></span>统</span>能<span class="_ _5"></span>清楚<span class="_ _5"></span><span class="ff1">了<span class="_ _5"></span>解</span>各<span class="_ _5"></span>种<span class="_ _5"></span><span class="ff1">信息<span class="_ _5"></span>,为<span class="_ _5"></span>病人<span class="_ _5"></span></span>就<span class="ff1">医<span class="_ _5"></span>时<span class="_ _5"></span>提</span>供<span class="_ _5"></span>方便<span class="_ _5"></span><span class="ff1">,<span class="_ _5"></span>具体<span class="_ _5"></span>程</span>序<span class="_ _5"></span><span class="ff1">分为<span class="_ _5"></span>病<span class="_ _5"></span>人信<span class="_ _5"></span>息</span></div><div class="t m0 x4 ha y6c ff1 fs6 fc0 sc1 ls0 ws0">管理<span class="_ _5"></span><span class="ff5">界</span>面<span class="_ _5"></span>,<span class="_ _5"></span>医务<span class="_ _5"></span>人员<span class="_ _5"></span>管理<span class="_ _5"></span>系统<span class="_ _5"></span><span class="ff5">界<span class="_ _5"></span></span>面,<span class="_ _5"></span>科<span class="_ _5"></span>室病<span class="_ _5"></span>房信<span class="_ _5"></span>息管<span class="_ _5"></span>理<span class="_ _5"></span><span class="ff5">界</span>面<span class="_ _5"></span>,药<span class="_ _5"></span>品<span class="_ _5"></span>药房<span class="_ _5"></span>信息<span class="_ _5"></span>管理<span class="_ _5"></span><span class="ff5">界<span class="_ _5"></span></span>面<span class="ff5">这<span class="_ _5"></span>几<span class="_ _5"></span></span>个主</div><div class="t m0 x4 ha y6d ff1 fs6 fc0 sc1 ls0 ws0">体<span class="ff5">界</span>面,<span class="ff5">根</span>据<span class="ff5">所</span>学数据库<span class="ff5">知识</span>,实<span class="ff5">现</span>对它们进行<span class="ff5">添</span>加<span class="ff2">,</span>查询,<span class="ff5">删除</span>,<span class="ff5">修改</span>等<span class="ff5">功能</span>。</div><div class="t m0 xb h7 y6e ff3 fs4 fc0 sc1 ls0 ws0">2.2<span class="_ _21"> </span><span class="ff1 sc0">设计要求</span></div><div class="t m0 xf ha y6f ff4 fs6 fc0 sc1 ls0 ws0">1<span class="ff1">、设计<span class="ff5">内容</span></span></div><div class="t m0 xf ha y70 ff1 fs6 fc0 sc1 ls0 ws0">设计一个医院管理信息系统,<span class="ff5">该</span>系统的用户由一<span class="ff5">般</span>用户和管理员组成,<span class="ff5">然后</span>不同的用户<span class="ff5">拥</span></div><div class="t m0 x4 ha y71 ff1 fs6 fc0 sc1 ls0 ws0">有不同的<span class="ff5">权限</span>,<span class="ff5">各</span>自<span class="ff5">完</span>成<span class="ff5">各</span>自的管理<span class="ff5">功能</span>,<span class="ff5">首先</span>是<span class="ff5">欢迎界</span>面,<span class="ff5">然后</span>选<span class="ff5">择登</span>录,<span class="ff5">登</span>录的时<span class="ff5">候首先</span></div><div class="t m0 x4 ha y72 ff1 fs6 fc0 sc1 ls0 ws0">要<span class="ff5">判</span>断用户的身份,<span class="ff5">合法</span>的用户<span class="ff5">然后</span>进<span class="ff5">入到</span>系统主<span class="ff5">界</span>面中,不同的用户<span class="ff5">看到</span>不同的系统<span class="ff5">功能</span>。 </div><div class="t m0 x4 ha y73 ff1 fs6 fc0 sc1 ls0 ws0">用<span class="_ _22"> </span><span class="ff4">sql server2008<span class="_ _22"> </span></span>设计和<span class="ff5">创</span>建<span class="ff5">后台</span>数据库,<span class="ff5">然后</span>利用程<span class="ff5">序</span>设计<span class="ff5">语言<span class="_ _22"> </span><span class="ff4">c#</span>编写</span>程<span class="ff5">序</span>实<span class="ff5">现</span>对数据库</div><div class="t m0 x4 ha y74 ff1 fs6 fc0 sc1 ls0 ws0">的操作,<span class="ff5">按照</span>要求<span class="ff5">完</span>成<span class="ff5">所</span>有的<span class="ff5">功能</span>和模<span class="ff5">块</span>。</div><div class="t m0 xf ha y75 ff4 fs6 fc0 sc1 ls0 ws0">2<span class="ff1">、医院管理信息系统主要<span class="ff5">功能</span></span></div><div class="t m0 xf ha y76 ff1 fs6 fc0 sc1 ls0 ws0">(<span class="ff4">1</span>)医生管理:用户<span class="ff5">登</span>录<span class="ff5">界</span>面、病人<span class="ff5">资料登记界</span>面(<span class="ff5">添</span>加、<span class="ff5">修改</span>等)、病人<span class="ff5">资料</span>查询<span class="ff5">界</span></div><div class="t m0 x8 h6 yd ff2 fs3 fc0 sc1 ls0 ws0">5</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>