【摘 要】隨著現(xiàn)代工業(yè)的發(fā)展，計(jì)算機(jī)信息管理系統(tǒng)越來(lái)越受到企業(yè)重視。本文主要分析了庫(kù)存管理系統(tǒng)的一些基本功能和組成情況，包括系統(tǒng)的需求分析、系統(tǒng)結(jié)構(gòu)，功能模塊劃分以及數(shù)據(jù)庫(kù)模式分析等，重點(diǎn)對(duì)應(yīng)用程序的實(shí)際開(kāi)發(fā)實(shí)現(xiàn)作了介紹。達(dá)到了數(shù)據(jù)的一致性和安全性，且應(yīng)用程序功能完備，符合了庫(kù)存管理系統(tǒng)作為典型的信息管理系統(tǒng)(MIS)的要求。同時(shí)簡(jiǎn)單介紹了Visual C++編程環(huán)境和SQL數(shù)據(jù)庫(kù)管理系統(tǒng)的功能特點(diǎn)，庫(kù)存管理系統(tǒng)是企業(yè)物流管理中不可或缺的一部分。使用計(jì)算機(jī)對(duì)產(chǎn)品倉(cāng)庫(kù)信息進(jìn)行管理，具有著人工管理無(wú)法比擬的優(yōu)點(diǎn)，它檢索迅速、查找方便、可靠性高、存儲(chǔ)量大、保密性好、壽命長(zhǎng)、成本低等，可減少更多的人力物力，這些都能夠極大地提高貨品庫(kù)存的管理效率，也是企業(yè)庫(kù)存管理科學(xué)化、正規(guī)化，與世界接軌的重要條件。因此，開(kāi)發(fā)一個(gè)倉(cāng)庫(kù)管理系統(tǒng)是很有必要的，具有其特有的技術(shù)意義和管理意義。
【關(guān)鍵詞】 倉(cāng)庫(kù)管理；信息管理；數(shù)據(jù)庫(kù)；VC++；產(chǎn)品管理












Storage Management System design and realization
【Abstract】With the development of modern industry, the information management system of the computer is paid more and more attention by enterprises. This article mainly analyzes some basic functions and constitution of the storage management system, including the systematic demand, structure, the function module division and the database mode analysis, etc. Especially introduces the actual development of the application program for emphasis. This system guaranteed the consistency and security of the data, and the application program functions are complete, and meeting the requirement of the storage management system as the request for the typical information management system (MIS).Meanwhile, it briefly introduced the function characteristics of Visual C++ programming environment and SQL database management system .Storage management system is an important part that should not be neglected in corporation management. Using a computer to control information of the warehouse which has advantages that artificial management that can’t catch up with. It is quickly inspectional, easy to search, the credibility is high, and deposit capacity is high, confidentiality good, Life span long, and the cost is low ECT, and can also reduce more manpower and material resource. All of these managements can infinitely raise the management efficiency of goods stock and also is a scientific and regular turn, and be in line with world of important condition of the storage management. Therefore, developing a storage management system is necessary. It has special technique and manages meaning.
【Keywords】Storage Management System；Information Management；Database；VC++； Production Management

目 錄
引 言 1
第一章 緒論 2
1.1管理信息系統(tǒng)的概述 2
1.2 倉(cāng)庫(kù)管理系統(tǒng) 2
第二章 數(shù)據(jù)庫(kù)理論基礎(chǔ)及應(yīng)用系統(tǒng)開(kāi)發(fā)工具 6
2.1 SQL語(yǔ)言介紹 6
2.2 應(yīng)用系統(tǒng)開(kāi)發(fā)工具 7
2.3 數(shù)據(jù)表的設(shè)計(jì) 9
第三章 倉(cāng)庫(kù)管理系統(tǒng)需求分析及總體設(shè)計(jì) 15
3.1系統(tǒng)需求分析 15
3.2系統(tǒng)功能描述 16
3.3系統(tǒng)功能模型 18
3.4 系統(tǒng)設(shè)計(jì)的E-R圖 18
3.5系統(tǒng)流程分析 20
3.6 系統(tǒng)用例圖 20
第四章 詳細(xì)設(shè)計(jì) 22
4.1 主界面設(shè)計(jì) 22
4.2 基本信息管理模塊 22
第五章 備份和還原數(shù)據(jù)庫(kù) 29
5.1 規(guī)劃數(shù)據(jù)庫(kù)的備份和還原 29
5.2 數(shù)據(jù)庫(kù)的備份 29
5.3 還原數(shù)據(jù)庫(kù) 31
結(jié) 論 33
致 謝 34
參考文獻(xiàn) 35
附錄Ⅰ數(shù)據(jù)庫(kù)建表語(yǔ)句 36
附錄Ⅱ倉(cāng)庫(kù)管理系統(tǒng)部分程序代碼 41