📄 图书管理系统数据库设计说明书.htm
字号:
style="mso-bookmark: _Toc521466027"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 22pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">外部设计</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466027"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 22pt"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><A name=_Toc521466028><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><FONT
face="Times New Roman">2.1</FONT></SPAN></B></A><SPAN
style="mso-bookmark: _Toc521466028"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">标识符和状态</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466028"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><o:p></o:p></SPAN></B></P>
<P
style="TEXT-JUSTIFY: inter-ideograph; MARGIN-LEFT: 18pt; TEXT-INDENT: -18pt; TEXT-ALIGN: justify; tab-stops: list 18.0pt; mso-list: l2 level1 lfo2"><A
name=_Toc521466029><SPAN lang=EN-US
style="FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-bidi-font-family: 宋体"><SPAN
style="mso-list: Ignore">1．<SPAN
style="FONT: 7pt 'Times New Roman'"> </SPAN></SPAN></SPAN><SPAN
style="FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt">在采购验收后，进入编目时，要人工粘贴索书号和新书的条码。<SPAN
lang=EN-US><o:p></o:p></SPAN></SPAN></A></P>
<P
style="TEXT-JUSTIFY: inter-ideograph; MARGIN-LEFT: 18pt; TEXT-INDENT: -18pt; TEXT-ALIGN: justify; tab-stops: list 18.0pt; mso-list: l2 level1 lfo2"><SPAN
style="mso-bookmark: _Toc521466029"><SPAN lang=EN-US
style="mso-bidi-font-family: 宋体"><SPAN style="mso-list: Ignore"><FONT
size=3>2．</FONT></SPAN></SPAN><SPAN
style="FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt">在图书上架仍保持手工摆放。</SPAN></SPAN></P>
<P
style="TEXT-JUSTIFY: inter-ideograph; MARGIN-LEFT: 18pt; TEXT-INDENT: -18pt; TEXT-ALIGN: justify; tab-stops: list 18.0pt; mso-list: l2 level1 lfo2"><SPAN
style="mso-bookmark: _Toc521466029"><SPAN lang=EN-US
style="mso-bidi-font-family: 宋体"><SPAN style="mso-list: Ignore"><FONT
size=3>3．</FONT></SPAN></SPAN><SPAN
style="FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt">系统目前只考虑到做编目、借书、还书、续借、图书证办理及六张报表的统计</SPAN></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="mso-bookmark: _Toc521466029"><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><FONT
face="Times New Roman">2.2</FONT></SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466029"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">使用它的程序</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466029"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><A
name=_Toc521466030><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">本系统主要利用</SPAN><SPAN
lang=EN-US><FONT face="Times New Roman">Visual
basic</FONT></SPAN></A><SPAN style="mso-bookmark: _Toc521466030"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">作前端的应用开发工具</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466030"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">，利用</SPAN><SPAN
lang=EN-US><FONT face="Times New Roman">Access</FONT></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466030"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">作为</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466030"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">后台的数据库，利用</SPAN><SPAN
lang=EN-US><FONT
face="Times New Roman">WINDOWS98/2000</FONT></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466030"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">作为系统平台</SPAN></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="mso-bookmark: _Toc521466030"><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><FONT
face="Times New Roman">2.3</FONT></SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466030"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">约定</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466030"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 10.5pt; LINE-HEIGHT: 150%; mso-char-indent-count: 1.0"><A
name=_Toc521466031><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">图书管理系统需要满足来自三方面的需求，这三个方面分别是图书借阅者、图书馆工作人员和图书馆管理人员。图书借阅者的需求是查询图书馆所存的图书、个人借阅情况及个人信息的修改；图书馆工作人员对图书借阅者的借阅及还书要求进行操作，同时形成借书或还书报表给借阅者查看确认；图书馆管理人员的功能最为复杂，包括对工作人员、图书借阅者、图书进行管理和维护，及系统状态的查看、维护并生成催还图书报表。</SPAN></A></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（一）</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">管理系统具有多个管理员，管理员可以使用不同的用户名和密码进入管理系统，并可以修改自己的密码；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（二）</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">进入系统后可以重新登录该系统，可以退出系统，断开连接等；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（三）在系统中可以对数据库进行简单的操作；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（四）</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">可以进行借书、还书及查询相应的信息等功能；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（五）</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">本系统可以给会员一个标识自己的</SPAN><SPAN
lang=EN-US><FONT face="Times New Roman">…….</FONT></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">例如会员卡，便于管理。还应可以对会员卡进行编辑、打印等操作；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（六）</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">最基本的功能还应具有可以编辑图书，录入、删除图书资料，录入、删除会员资料；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21.75pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（七）做个借期超过要求罚款的功能，不同类的书罚款各不相同；</SPAN><SPAN
lang=EN-US><BR><FONT face="Times New Roman"><SPAN
style="mso-spacerun: yes"> </SPAN><SPAN
style="mso-spacerun: yes"> </SPAN></FONT></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（八）报表打印：所有图书、借出图书、库存图书、所有读者；</SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18.9pt; LINE-HEIGHT: 150%; mso-char-indent-count: 1.8"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（九）图书管理系统软件还必须具有导入</SPAN><SPAN
lang=EN-US><FONT face="Times New Roman">,</FONT></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">导出数据库功能。方便即时更新和修改；</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466031"><SPAN lang=EN-US
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%; FONT-FAMILY: Arial"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18.9pt; LINE-HEIGHT: 150%; mso-char-indent-count: 1.8"><SPAN
style="mso-bookmark: _Toc521466031"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">（十）软件系统安全上要有一定的保障；</SPAN></SPAN></P><SPAN
style="mso-bookmark: _Toc521466031"></SPAN>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><A name=_Toc521466032><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><FONT
face="Times New Roman">2.4</FONT></SPAN></B></A><SPAN
style="mso-bookmark: _Toc521466032"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">支持软件</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466032"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd"><A
name=_Toc521466033><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">操作系统</SPAN><FONT
face="Times New Roman"> </FONT></A><SPAN
style="mso-bookmark: _Toc521466033"><B><SPAN lang=EN-US
style="FONT-FAMILY: 黑体; mso-fareast-font-family: 宋体">Windows 98
/Windows2000/Windows NT4.0</SPAN></B></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd"><SPAN
style="mso-bookmark: _Toc521466033"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">数据库系统</SPAN><FONT
face="Times New Roman"> </FONT></SPAN><SPAN
style="mso-bookmark: _Toc521466033"><B><SPAN lang=EN-US
style="FONT-FAMILY: 黑体; mso-fareast-font-family: 宋体">SQL SERVER
2000</SPAN></B></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd"><SPAN
style="mso-bookmark: _Toc521466033"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">开发工具</SPAN></SPAN><SPAN
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -