【正文】 店 預(yù) 定 銷 售 庫查 看 出 版 社 圖 書 目 錄 管 理 查 詢 庫 存 圖 32 書店的流程 發(fā) 出 訂 單B. 然后在根據(jù)出版社發(fā)回的圖書信息（比如說某一種書是否脫銷了，還可不可能再版發(fā)行）整理訂書單，再進(jìn)書。現(xiàn)在的書店大部分都是分片管理，某一樓層按書的不同種類交由不同得人員進(jìn)行管理。買書時大部分時間都浪費在查書上。因此所謂的規(guī)范化實質(zhì)上是概念的單一化.關(guān)系模式的規(guī)范化過程是通過對關(guān)系模式的分解來實現(xiàn)的。一個編號只決定一本書，因而當(dāng)編號確定后，書名和作者的值也就唯一的確定了。. ： 用戶自定義的完整性反映某一具體應(yīng)用所涉及的數(shù)據(jù)必須滿足語義要求。 進(jìn)貨管理模塊分為：進(jìn)貨信息的錄入子系統(tǒng) 、進(jìn)貨信息的刪除子系統(tǒng)。維護(hù)管理模塊分為：退書子系統(tǒng),副本更新子系統(tǒng)、口令維護(hù)子系統(tǒng)、特價書管理子系統(tǒng)、幫助子系統(tǒng)。 讀者預(yù)訂子模塊：輸入讀者要訂購的圖書信息，存到讀書預(yù)定庫中打印出來。 ：完成對書信息的查詢，又分為按其條件查詢。 打印付款憑證子模塊：根據(jù)銷售庫中的信息打印出讀者所購書的冊數(shù)、總計、交款額、找零和購書時間，同時更新統(tǒng)計庫。例如，選擇01/01/99至02/01/99和種類中的大中專教材，就可以得到99年1月份書店銷售大中專教材的情況。 口令維護(hù)：對軟件登錄密碼進(jìn)行維護(hù)。4．2．2 系統(tǒng)數(shù)據(jù)庫設(shè)計利用用戶的需求分拆進(jìn)行了數(shù)據(jù)的分析，并形成了具體的數(shù)據(jù)流圖和數(shù)據(jù)字典。包括向用戶及時準(zhǔn)確的提供所需要信息，支持用戶所有需要處理的數(shù)據(jù)進(jìn)行處理，并且使其具有易于維護(hù)，便于理解和運行效率高的特點.數(shù)據(jù)庫設(shè)計的質(zhì)量直接影響到系統(tǒng)開發(fā)的速度，應(yīng)用效果和生命力。（2）易于更動，當(dāng)現(xiàn)實世界改變時易于修改和擴(kuò)充。邏輯結(jié)構(gòu)設(shè)計的任務(wù)就是把概念模型轉(zhuǎn)換為與DBMS所支持的數(shù)據(jù)模型柏樹禽的過程。這里的主要因素是：在即時間，存儲空間利用率和維護(hù)代價，設(shè)計時要對這些因素進(jìn)行權(quán)衡，如引入某些冗余數(shù)據(jù)則可能減少物理工人次數(shù)提高檢索效率。該模塊目的是將圖書的進(jìn)書信息錄入到書庫中，該模塊完成的功能如流程圖45所示。故無需運行，直接在瀏覽器上顯示。l Private sub waitdata()：此過程根據(jù)傳送給bbs的值來顯示不同的信息，用于提示用戶系統(tǒng)的狀態(tài)。Private Sub 查詢_Click()：執(zhí)行時，通過隱藏表單form8將用戶所選擇的條件傳到查詢庫中存在接收這些參數(shù)的語句，然后根據(jù)這些參數(shù)執(zhí)行SQL語句進(jìn)行對庫的查詢，如果存在滿足條件的記錄，則把結(jié)果顯示在讀者界面上；不存在滿足條件的記錄時，返回“無滿足條件記錄存在”字樣。該模塊是通過統(tǒng)計表格對各種數(shù)據(jù)進(jìn)行了統(tǒng)計顯示，目的是通過表格形式展示各種匯總值。 x=CInt((n*10000)/tt)/100 if x1 and x0 then aStr=0amp。對于潤年的計算： if y mod 4=0 and y mod 4000 then days=29 else days=28 end if因為輸入的日期僅為年和月，用來表明是起始月的一號到終止月的最后一天，所以要依靠此程序計算出終止月的最后一天是幾號。4．5．2　流程圖l 銷售統(tǒng)計子模塊：圖47。那么，軟件測試有哪些方法，本系統(tǒng)又采用了哪中測試方法呢？一般來說，有兩種軟件測試方法：1. 黑盒法 黑盒法： 著眼于程序的外部特性，而不考慮程序的內(nèi)部邏輯構(gòu)造。l 組裝測試 在所有的模塊都通過了單元測試后，各個模塊工作都很正常。無論從查閱資料、確定方向、編程到系統(tǒng)調(diào)試都學(xué)習(xí)了許多課堂上學(xué)不到的知識，增強了我的實踐動手能力，受益非淺。***教授嚴(yán)謹(jǐn)?shù)闹螌W(xué)態(tài)度和淵博的知識，嚴(yán)以律己、寬以待人的崇高品質(zhì)，身先士卒的表帥行為，勤奮刻苦的鉆研精神，以及對學(xué)生的諄諄教誨都將使學(xué)生終生難忘，是學(xué)生的楷模。 在此向各位評閱論文的老師表示最誠摯的謝意！ 參　考　文　獻(xiàn)1 劉仲等，《計算機應(yīng)用研究》，電子工業(yè)出版社；；7880；2 王元媛、靳藩，《計算機應(yīng)用》，電子工業(yè)出版社；；2629；3 宛福成等主編， 《書店自動化系統(tǒng)設(shè)計》，書目文獻(xiàn)出版社；1999 .5；25454 張海藩，《軟件工程導(dǎo)論》， 清華大學(xué)出版社；；；5 薩師煊 王珊，《數(shù)據(jù)庫系統(tǒng)概論》，高等教育出版社；1985.；36486 張會昌、劉林林、閆靈均，“商業(yè)自動化系統(tǒng)的設(shè)計與實現(xiàn)”，《微機處理》，：3034；7 聶洪山，“用ASP與ADO查詢數(shù)據(jù)庫”，《計算機世界報》； ：2325。 John Croweroft,《The world wide web》,UCL Press,1995附錄A　文獻(xiàn)翻譯A1　Sybase Product Complianceto Year 2000 Industry StandardsThis document constitutes Year 2000 Readiness DisclosuresThe following is a brief description of the Millennium Bug, the posite industry standard, and the position of Sybase products against that standard.Many organizations have attempted to define what it means to be Year 2000 Compliant, or in the general case, Century Compliant. They then ask their vendors to verify that they are indeed Compliant, to ensure their new application investments will be implemented using databases, middleware and tools that do not suffer from the Millennium Bug. This white paper briefly discusses the nature of the problem, general pliance definitions, and how pliance issues are addressed by Sybase products. Year 2000 Problems There are a variety of systemic problems that may be encountered by applications because of how dates are treated in the application software. Common problems include: A. Using specific date field values for carrying other information than date. For example, some applications may use the values of 00 in the 2digit year field or 9999 in month/day/year fields to indicate an unknown or unresolved date. Without explicit century information these flags cannot be distinguished from the legitimate dates of 9/9/99 and any century. B. Failing to recognize that the year 2000 is divisible by 400 and thus is a leap year with a February 29, while neither 1900 nor 2100 contains a February 29. C. Incorrect answers to mon logical and arithmetic operations using dates, for example 00 99 returning false but 2000 1999 returning true. Similarly, 2000 1998 should yield 2 rather than 00 98 = 98. D. Inputting 2digit year values through interactive transactions or through data transfer from an outside source results in a hard coded century value, almost always 19. Thus entering 00 where the year 2000 is intended would result in a stored value of 1900. The call for standards from customers is to ensure that the foundation software they use for their applications, the operating systems, databases, middleware and tools products, all avoid these errors so properly written applications will not fail because of a failure in their foundations. 2. Standards for the Year 2000 There is no general software standard for the year 2000. As a result, many panies are generating an individual set of criteria and asking if Sybase, Inc. products are pliant to their unique standard. The most plete summary of Year 2000 criteria we seen is the Millennium 2000 Program Document PA96014 Revised 19960619 from GTE Government Systems Corporation. Because of the redundancy of this method, we have taken a number of these definitions, including the British Standards Institute DISC PD20001, and bined their points into the summary shown below: To be Century Compliant the following four criteria summarize the issues raised in one way or another by all customers: A. General Integrity: No value for the current date will interrupt normal operation: the system returns the correct date accurate to century in response to a request for current date, and the software is unaffected by any value returned. B. Date Integrity: Correct results are returned in the operation of all legal arithmetic, logical and calendar operations of dates that span century marks within the range of the software. C. Explicit Century: The software internal date storage format explicitly includes the century and reporting formats allow date representation in the full century format D. Implicit Century: On encountering data that does not include the century either from transaction input o