?? 圖書管理系統數據庫設計說明書.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 + -