刀具管理系统中的数据库技术

摘要

为使刀具管理更加标准化、规范化和系统化,提高实际生产过程中刀具的管理效率,以SQLServer2000作为后台数据库,应用VC++6.0软件开发了用于刀具管理的数据库管理系统.分析了系统的物理结构和功能模型,给出了系统的信息流程图.介绍了数据库的概念结构设计、安全性设计和完整性设计,给出了创建后台数据库和建立数据库表的过程,并结合程序介绍了数据库在管理系统各个模块中的应用.%In order to make tool management more standardized, formal and systematic, improve the efficiency of tool management in the actual production processing, the tool management system is developed. VC++6.0 is used for system design language, and SQL Server2000 is used for the background database. The physical structure and function models are analyzed, and the information flow of the system is given. Meanwhile, the conceptual structure design, security design and integrality design of database are introduced, and the process of founding background database and establishing database table is given. According to the program, the application of database in the modules of the system is introduced.