本设计由Delphi开发，SQL2000数据库，毕业论文2.7万字
【摘要】
企业车辆管理系统是典型的信息管理系统，其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。
因此要求结合企业车辆管理的要求，对MS SQL Server2000数据库管理系统、SQL语言原理、完成对企业车辆管理系统的需求分析、功能模块划分、数据库模式分析，并由此设计了数据库结构和应用程序。
第一章对数据库应用系统开发和企业车辆管理系统进行了简明的介绍，并分析了开发企业车辆管理系统所应进行的工作。第二章对数据库的设计和SQL语言的使用进行了系统分析，为深入理解数据库应用打下了基础。第三章学习了具体的开发工具Delphi 7.0，对其数据库组件，SQL语言在Delphi中的应用等数据库编程关键技术进行了系统的介绍。第四章分析了企业车辆管理信息系统的应用需求，按照数据库设计理论的要求给出了系统需求说明书、系统关系模式，子模式，利用MS SQL Server2000建立了数据库。第五章进行了具体的程序设计，具体划分了三大模块：系统管理模块、基本信息管理模块、车辆调度管理模块。实现了数据库表的浏览，记录的添加、删除和修改，报表的生成，实现了多数据库表的连接操作，实现了多条件查询和模糊查询，并灵活实现了对不可更新查询结果集的更新操作，实现了主从表操作，实现了密码维护功能，最后，系统还可以导入数据库以对任意同结构的数据库进行操作设计充分利用Delphi 7、MS SQL Server2000数据库。
【关键词】企业车辆管理系统 SQL Server数据库 Delphi开发语言 管理信息系统
【Abstract】：
The enterprise vehicle management system is the typical information management system, its development mainly includes the backstage database the establishment and the maintenance as well as front end the application procedure development two aspects. Establishes the data uniformity and the integrity regarding the former request is strong, data security good storehouse. But requests the application program function regarding the latter to be complete, easy to use and so on characteristics.
Therefore the request union enterprise vehicle management's request, to MS SQL the Server2000 database management system, the SQL language principle, completes to the enterprise vehicle management system's demand analysis, the functional module division, the database pattern analysis, and has designed the database structure and the application procedure from this. The first chapter has carried on the concise introduction to the database application system development and the enterprise vehicle management system, and has analyzed the work which the development enterprise vehicle management system should carry on. The second chapter has carried on the system analysis to the database design and the SQL language's use, has built the foundation for the thorough understanding database application. The third chapter has studied concrete development kit Delphi 7.0, to its database module, the SQL language in the Delphi database programming key technologies and so on application has carried on system's introduction. The fourth chapter has analyzed the enterprise vehicle management information system's application demand, has given the system requirements instruction booklet, the system relational scheme according to the database design theory's request, the subschema, has established the database using MS SQL Server2000. The fifth chapter has carried on the concrete programming, has divided three big modules specifically: System administration module, basic information management module, vehicles dispatch administration module. This has realized the database table browsing, the record increase, the deletion and the revision, the report form production, has realized the multi-database table tended operation, has realized the multi-condition inquiry and the fuzzy inquiry, and realized nimbly to has not been possible to renew the inquiry result collection the renewal operation, has realized main from the table operation, has realized the password maintenance function, finally, the system might also induct the database by to carry on the operation design to the random isostructuralism database to use Delphi 7, MS SQL Server2000 database.
【Keywords】：Enterprise vehicle management system ，SQL Server database
Delphi development language ，Management information system
目录
【摘要】 1
【ABSTRACT】： 2
前 言 4
1.1 数据库应用系统开发简介 4
1.2 企业车辆管理系统 5
1.3 系统所做工作 6
2 数据库理论基础 6
2.1 数据库系统设计及范式分析 7
2.2 SQL语言介绍 9
3 应用系统开发工具 11
3.1 DELPHI7.0 VCL组件的体系结构 11
3.2 数据库组件介绍 12
3.3 SQL语言在DELPHI中的应用 12
3.4 MS SQL SERVER简述 15
4 企业车辆管理系统设计分析 16
4.1 需求分析 16
4.2 系统体系结构设计 16
4.3 开发工具及技术 18
4.4 数据库结构设计 18
5 企业车辆管理系统应用程序设计 24
5.1 系统窗体模块组成 24
5.2 系统主界面和登录窗体设计 24
5.3驾驶员信息管理模块设计 28
5.4 车场信息管理模块设计 33
5.5 车辆信息管理模块设计 36
5.6 车辆预约管理模块设计 39
5.7 车辆派遣管理模块设计 42
5.8 系统管理模块设计 57
谢 辞 63
参考文献 64
