机动车租赁管理系统
（
摘 要
近年来，计算机技术日趋成熟，数据库技术不断发展，管理信息系统的应用已延伸到社会的各个领域。结合管理信息系统的开发方法及步骤，以此为理论基础，开发出一个小型的信息管理系统——机动车租赁管理系统。
机动车租赁管理是汽车租赁公司开展日常运营活动的必须的环节。传统的手工管理方式不但浪费人力、时间，而且管理复杂，易出差错。基于计算机技术的完备的机动车租赁管理系统把一些繁琐的数据计算、信息处理化为简单的指令操作。完全实现数据信息的电算化管理，彻底把人从手工管理中解放出来。经过艰苦的努力,终于实现了预期的设计目标,开发出这套具有一定实用价值的机动车租赁管理系统,使用这套系统有利于提高汽车租赁公司的劳动生产率，节约生产成本，增加经济效益。
本文主要介绍了该系统生成的背景及Visual Basic 6.0和Access的一般原理。阐述了整个机动车租赁管理系统的结构及工作原理；分析了系统实现中的特殊性、难点和重点；设计实现了系统用户管理、基本信息管理、业务管理、会员管理等程序模块；分析并解决了现实中的若干技术问题。
【关键词】数据库，Visual Basic6.0，机动车租赁管理
the Automobile Lend-lease Management System
dongfa hong
(School of mathematics,physics and information,Zhejiang Ocean University 316004)
Abstract
In recent years, the computer technique has become more and more ripe; the database technique develops constantly and the application of the information management system has stretched into every field of our society. Combining the methods and steps of the information management system and basing on the theory of it, I developed a small information management system--the automobile lend-lease management system.
The management of automobile lending and leasing is a necessary part of the company''s daily operation. Traditional way is a waste of human resources and time, and it is complicated and often runs with mistakes. Based on the computer technique, the perfect automobile lend-lease management turns those complicated data calculation and information processing into simple instructions.
It realized the electronic management of data information completely. It liberates people from the human management entirely. After hard work, I finally realized my design as expected, and developed this practical and valuable automobile lend-lease management system. Using it will raise the working rate, reduce the cost and raise the economic benefit of the company.
This paper mainly introduces the develop background of the system and the basic theory of Visual Basic 6.0 and Access Visual. It tells the structure of the automobile lend-lease management system and its working theory; it analyzes the specialty, difficulty and important things in system realization. The design realizes the management of the system users, the basic information, the business, and the members'' management.
【Keywords】Database,Visual Basic6.0,The automobile lend-lease management
目录
摘 要 I
Abstract II
1 绪论 1
1．1 课题研究背景及意义 1
1．2 课题实现的基本功能 1
1．2．1数据库管理系统简介 2
1．2．2 SQL语言简介 2
1．2．3 Access2003简介 3
1．2．4 Visual Basic 6.0 简介 3
2 系统的需求分析与可行性研究 5
2．1 业务流程分析 5
2．2 功能分析 5
2．3 数据结构分析 5
3 系统总体设计 7
3．1 系统功能分析 7
3．1．1 系统功能模块设计 7
3．1．2 系统功能模块图 7
3．2 数据库设计 8
3．2．1 数据字典 8
3．2．2 数据库中表的设计 9
4 系统详细设计与实现 13
4．1 登录模块设计 13
4．2 主界面设计 13
4．3 基本信息管理菜单设计 15
4．3．1 销售商信息窗体设计 15
4．3．2 保险公司信息窗体设计 16
4．3．3 车辆信息窗体设计 17
4．4 客户会员管理菜单实现 18
4．4．1 客户信息窗体实现 18
4．4．2 会员信息窗体实现 19
4．4．3 会员类型定义窗体实现 20
4．5 日常业务管理菜单实现 20
4．5．1 汽车租赁窗体实现 20
4．5．2 汽车归还窗体实现 22
4．6 用户信息窗体实现 24
5 系统测试 26
5．1 软件测试的目的及测试方案 26
5．1．1 软件测试的目的 26
5．1．2 软件测试的方案 26
5．2 软件测试过程 27
总结 29
参考文献 30
1 绪论
1．1 课题研究背景及意义
现代科学的发展，使计算机进入了几乎一切领域。从科学研究到工农业生产，从企业生产管理到家庭生活，各行各业都广泛地使用着计算机。当今社会的数据信息管理离不开计算机技术的支持。如何实现对数据信息快捷、有效、实用的管理，是软件开发业追求的目标。
今天，随着社会生产的发展，人民生活水平的提高，机动车租赁已成为一个极具市场潜力的行业，面对飞速发展的租赁市场，传统的人工租赁管理方式在进行繁多的业务信息处理时显得极不适应，因此，人们对于运用计算机来辅助协调和管理租赁工作的需求正在逐步提高。
随着社会物质条件的改善，生产生活节奏的加快，人们越来越意识到时间的重要性，在工作中，生活中越来越注重如何节省时间，提高效率。因为工作和生活的缘故，在必要的时候向汽车出租公司提出租赁车辆的服务要求，已成为大众广为认可和接受的行为和选择。在这种社会需求的强力带动下，机动车租赁市场出现了前所未有的一片繁荣景象。各个汽车租赁公司门庭若市，业务激增。然而在繁忙的景象背后，却也暴露出机动车租赁公司在处理业务信息时以人工方式为主所带来的诸如：效率低下，管理混乱，失误增多等诸多弊端。在实践中，汽车租赁行业的业主们逐渐意识到在租赁行业中借助计算机引入信息管理的重要性，并开始不断提高自身的素质和高科技在工作中的投入，以改善信息的管理，提高服务效率。
机动车租赁管理就是对车辆信息和客户信息的管理，主要包括车辆的出租状态、车辆的基本信息、车辆的投保情况、车辆的出厂情况、客户信息的管理等。由于这些过程间的关系复杂，有一对一的关系，一对多的关系，也有多对多的关系，所有这些工作使机动车管理工作变得量大而又复杂，以前包括现在还有很多租赁公司采用人工管理，直接导致了错误的产生，服务质量的低下。机动车租赁管理系统的开发使得这一状况得到了根本的改善。这套管理系统包括涵盖了车辆租赁业务的各个方面。使得机动车租赁服务可以快速、规范地完成，节省了人力物力，提高了服务质量和经济效益。
1．2 课题实现的基本功能
机动车租赁管理系统针对的是机动车租赁公司在向客户提供出租车辆服务过程中面对的各种问题，对其业务信息进行自动化、信息化处理，使车辆租赁管理变得规范、快捷、高效。
基于各方面的研究，同时针对机动车租赁公司的实际情况，查阅并应用数据库、管理信息系统、软件工程的一些基本原理和理论思想，以具有强大的应用程序开发功能和数据库开发功能的Visual Basic6.0为开发工具，设计开发了这套机动车租赁管理系统。在Windows环境下，此系统具有比较友好的界面和基本完善的功能，使用轻松方便，易于维护，适应性强。
本系统包括客户信息管理、车辆信息管理、汽车租赁归还管理、会员类型管理、会员信息管理、保险公司管理、汽车销售商管理等。具有添加、修改、删除、查询等功能，通过这些管理模块，可以使汽车租赁服务更加清晰，更加便捷，提高了服务质量，减少了操作人员的工作量。
为规范操作流程，降低劳动强度使租赁业务走向标准化和科学化， 设计开发了这套管理系统，它的使用将有利于提高租赁公司的劳动生产率，节约生产成本，增加经济效益，希望它能为业内人员的工作提供一定的帮助。
1．2．1数据库管理系统简介
数据库是数据管理的最新技术，是计算机科学的重要分支。数据库是指长期储存在计算机内的、有组织的、可共享的数据集合。数据库中的数据按一定的数据模型组织、描述和储存，具有较小的冗余度、较高的数据独立性和易扩展性，并可为各种用户共享。数据库管理系统是位于用户与操作系统之间的一层数据管理软件。主要有数据定义功能、数据操纵功能、数据库的运行管理和数据库的建立和维护功能。它是数据库系统的一个重要组成部分。十余年来，数据库管理系统已从专用的应用程序包发展成为通用的系统软件。由于数据库具有数据结构化、最低冗余度、较高的程序与数据独立性、易于扩充、易于编制应用程序等优点，较大的信息系统都是建立在数据库设计之上的。因此，不仅大型计算机及中小型计算机，甚至微型机都配有数据库管理系统。目前，对数据库各种模型的研究以及理论上的探讨都还在蓬勃开展，其应用也从一般管理扩大到计算机辅助设计、人工智能以及科技计算等领域。
今天，信息资源已成为各个部门的重要财富和资源。建立一个满足各级部门信息处理要求的行之有效的信息系统也成为一个企业或组织生存和发展的重要条件。因此，作为信息系统核心和基础的数据库技术得到越来越广泛的应用，从小型单项事务处理系统到大型信息系统，从联机事务处理到联机分析处理，从一般企业管理到计算机辅助设计与制造（CAD/CAM）、计算机集成制造系统（CIMS）、办公信息系统（OIS）、地理信息系统（GIS）等，越来越多新的应用领域采用数据库存储和处理他们的信息资源。对于一个国家来说，数据库的建设规模、数据库信息量的大小和使用频度已成为衡量这个国家信息化程度的重要标志。
1．2．2 SQL语言简介
SQL（Structured Query Language）语言是1974年由Boyce和Chamberlin提出的。1975年-1979年IBM公司San Jose Research Laboratory研制了著名的关系数据库管理系统原形System R并实现了这种语言。由于它功能丰富，语言简捷倍受用户及计算机工业界欢迎，被众多计算机公司和软件公司所采用。经各公司的不断修改、扩充和完善，SQL语言最终发展成为关系数据库的标准语言。
1986年10月美国国家标准局（American National Standard Institute，简称ANSI）的数据库委员会X3H2批准了SQL作为关系数据库语言的美国标准。同年公布了SQL标准文本（简称SQL-86）。1987年国际标准化组织（International Organization for Standardization，简称ISO）也通过了这一标准。此后，ANSI不断修改和完善SQL标准，并于1989年公布了SQL-89标准，1992年又公布了SQL-92标准。
自SQL成为国际标准语言以后，各个数据库厂家纷纷推出各自的SQL软件或与SQL的接口软件。这就使大多数数据库均用SQL作为共同的数据存取语言和标准接口，使不同数据库系统之间的互操作有了共同的基础。这个意义十分重大。因此，有人把确立SQL为关系数据库语言标准及其后的发展称为是一场革命。SQL成为国际标准，对数据库以外的领域也产生了很大影响，有不少软件产品将SQL语言的数据查询功能与图形功能、软件工程工具、软件开发工具、人工智能程序结合起来。
SQL是一种介于关系代数与关系演算之间的结构化查询语言，其功能并不仅仅是查询。SQL是一个通用的、功能极强的关系数据库语言。SQL语言集数据查询、数据操纵、数据定义和数据控制功能于一体，主要特点包括：综合统一、高度非过程化、面向集合的操作方式、以同一种语法结构提供两种使用方式、语言简捷，易学易用。SQL已成为数据库领域中一个主流语言。
1．2．3 Access2003简介
Macrosoft 公司出品的关联式资料库套装软体。它提供视觉化的设计介面，不必撰写程式，即可快速，简单地开发出美观实用的资料库管理系统。
Access的结构:资料(data)→栏位(field)→记录(record)→档案(file)→资料库(data base)；资料(data)→资料项(item)→资料录(record)→资料表(table)→资料库(data base)
Access2003有以下组成：
资料表：为access储存资料的地方，亦为资料的根本来源，一个资料库至少要存在一个资料表。
查询：可依使用者需求，以一些限制条件（筛选,过滤…）来选取资料表中。
表单：建立一个让使用者输入，查询，修改资料的操作画面。
报表：将资料库里的资料运用报表做成有利用价值的画面资料。
资料页：为access2003的新增物件，资料发布至网路的媒介。此物件完成建立后，将会在资料库档案外，再产生一个HTML档。
巨集：建立简单的资料操作指令与将一连串的执行动作自动化。应用于一些重复性高的动作或者用于使用者自订工作环境上。
模组：开发应用系统的工具。是让使用者能更随心所欲的去控制系统。
3 系统总体设计
3．1 系统功能分析
3．1．1 系统功能模块设计
其主要完成的功能如下：
1、类型信息: 包括汽车类型的添加、修改、删除；汽车保险类型的添加、修改、删除。具体信息包括分类名称、具体描述；
2、销售商信息: 包括销售商信息的添加、修改、删除、查询、查看销售汽车。具体信息包括销售商的公司名称、联系地址、联系电话、传真、邮政编码、电子邮箱、联系人、备注；
3、保险公司信息: 包括保险公司信息的添加、修改、删除、查询、查看保险汽车。具体信息包括保险公司的公司名称、联系地址、联系电话、传真、邮政编码、电子邮箱、联系人、备注；
4、车辆信息: 包括车辆信息的查找、修改、添加、删除。具体信息包括车辆的（1）基本信息，有车牌号码、车辆类型、车辆名称、车辆颜色、发动机号、车架编号、燃油编号、购买日期、销售商、状态，（2）保险信息，有保险公司、保单号、开始日期、结束日期、保险种类，（3）租赁价格信息，有押金、日租金、周末租金、周租金、月租金、日限公里数、超时费用、超公里费用、车辆描述；
5、客户信息: 包括客户信息的查找、修改、添加、删除、加入会员。具体信息包括（1）基本信息，有客户编号、姓名、性别、年龄、身份证号、电话、工作单位、地址、邮编、EMAIL，（2）驾驶证信息，有驾驶证号、驾照类型、驾龄、发证日期、失效日期，（3）抵押担保信息，有抵押证件、担保人、担保人身份证、担保人单位；
6、会员信息: 包括会员信息的查找、修改、注销。具体信息包括（1）基本信息，有客户编号、姓名、性别、年龄、身份证号、电话、工作单位、地址、邮编、EMAIL，（2）驾驶证信息，有驾驶证号、驾照类型、驾龄、发证日期、失效日期，（3）抵押担保信息，有抵押证件、担保人、担保人身份证、担保人单位，（4）会员信息，有会员类型、享受折扣；
7、会员类型: 包括会员类型的添加、修改、删除。具体信息包括类型名称、折扣率；
8、汽车租赁: 包括汽车租赁信息的添加、修改、删除、租赁审核、续租、续租审核。具体信息包括合同编号、车牌号码、客户编号、租赁模式、工作日数、周末数、出车公里数、租车时间、还车时间、租车费用、经办人、享受折扣；
9、汽车归还: 包括汽车归还信息的归还、修改、结算审核。具体信息包括合同编号、回车公里数、实际还车时间、其它费用、实付金额、经办人；
10、系统用户信息: 包括添加用户和删除用户。具体信息包括用户名、密码、确认密码；
11、系统帮助信息: 包含软件使用过程中的一些重要的、需要注意的使用方法和其它一
总结
经过近几个月的学习和摸索，我终于完成了这个“机动车租赁管理系统”。通过开发过程，我比较深入地掌握了Visual Basic 6.0的使用方法，对数据库的理解也更加深刻了。由始至终的开发过程，让我深刻体会到软件工程这门学科对于程序开发的重要性。一个工程的开发，编程过程并不是最重要的，对于那些熟练掌握编程语言的软件开发者来说，一个工程的代码实现，并不难做到。真正重要的反而是那些在编程之前所需做的工作。从软件的需求分析到系统设计，每一步都非常重要，一个高质量的软件，从一开始就要扎扎实实的做好需求分析，为后续的系统设计和实现打下良好的基础。
本系统界面美观，设计合理，能够实现预计的功能，但系统的容错性还不很完善。这暴露出我的编程能力还有待提高。今后我会继续努力学习，不断充实自己，提高自己。
总的说来，本系统的设计是基本符合用户要求的，可以交付给用户使用。
由于本人水平有限，在设计思路和技巧方法上可能比较愚钝，在开发语言的掌握上可能相对肤浅，所以，反映到系统中，难免存在许多的不足之处，殷切希望各位老师批评、指正。
参考文献
刘铁春.我国机动车市场的分析研究. 汽车与社会.2003, (Z1)
徐铁军.目前机动车租赁中存在的问题及对策[J]中国工商管理研究 .1997, (05)
郭福顺.数据结构与算法基础.大连理工大学出版社 2002
萨师煊.数据库系统概论.高等教育出版社 2003
冯玉才.数据库基础.华中理工大学出版社 2005.4
(美)尼德斯特（Niederst,J.）著、赵声攀等译.WEB设计技术手册（第二版）.机械工业出版社 2003.1
王珊.数据库系统原理.清华大学出版社 2003.4
Jackson M A. Principles of Program Design.Academic Press 1975
常晋义.信息系统开发与管理.机械工业出版社 2003.12
Warnier J D. Logical Construction of Programs.Van Nostrand 1974
李帜.软件工程项目管理功能点分析方法实践.清华大学出版社 1999.4
王森主编.数据库应用基础 Access 2000.电子工业出版社 2002
赛奎春主编.Access数据库开发实例解析.机械工业出版社 2006
刘炳文. Visual Basic 程序设计教程.清华大学出版社 2002.3
[15] (美)海恩勒(Heinle)等著.Microsoft Visual Basic 6.0中文版组件工作指南.北京希望电子出版社 2003.7
[16] EricBrierley .Visual Basic 开发人员指南.机械工业出版社 2002.12
Vehicle Rental Management System
(
Abstract
In recent years, computer technology has matured, the continuous development of database technology, management information systems applications have extended to all areas of society. Combination of management information system development methods and steps for this as the theoretical basis to develop a small-scale information management system - vehicle rental management system.
Motor Vehicle Lease Management is a car rental company to carry out day to day operational activities must be links. The traditional manual management is not only a waste of manpower, time, and manage complex, error-prone. Computer-based technology, complete management system for motor vehicle lease data in some tedious calculations, information processing operations into simple instructions. The full realization of the computerized data and information management, a thorough man freed from the manual management. Through hard work, and finally to achieve the desired design objectives, to develop this vehicle has a certain practical value of the lease management system, using this system is conducive to raising the car rental company''s labor productivity, reduce production costs and increase economic benefits.
This paper describes the system-generated background and Visual Basic 6.0 and Access of the general principles. Set out the entire vehicle rental management system structure and working principle; analysis of the particularity of the system implementation, problems and priorities; Design and Implementation of the system user management, basic information management, business management, membership management, program modules; to analyze and solve in reality, a number of technical problems.
【Key Words】 database, Visual Basic6.0, motor vehicle leasing management
the Automobile Lend-lease Management System
dongfa hong
(School of mathematics, physics and information, Zhejiang Ocean University 316004)
Abstract
In recent years, the computer technique has become more and more ripe; the database technique develops constantly and the application of the information management system has stretched into every field of our society. Combining the methods and steps of the information management system and basing on the theory of it, I developed a small information management system - the automobile lend-lease management system.
The management of automobile lending and leasing is a necessary part of the company''s daily operation. Traditional way is a waste of human resources and time, and it is complicated and often runs with mistakes. Based on the computer technique, the perfect automobile lend-lease management turns those complicated data calculation and information processing into simple instructions.
It realized the electronic management of data information completely. It liberates people from the human management entirely. After hard work, I finally realized my design as expected, and developed this practical and valuable automobile lend-lease management system. Using it will raise the working rate, reduce the cost and raise the economic benefit of the company.
This paper mainly introduces the develop background of the system and the basic theory of Visual Basic 6.0 and Access Visual. It tells the structure of the automobile lend-lease management system and its working theory; it analyzes the specialty, difficulty and important things in system realization. The design realizes the management of the system users, the basic information, the business, and the members'' management.
【Keywords】 Database, Visual Basic6.0, The automobile lend-lease management
Directory
Summary I
Abstract II
1 Introduction 1
1.1 Background and Significance of a Research Project
1.2 subject to achieve the basic functions of a
1.2.1 Database Management System 2
1.2.2 SQL Language Profile 2
1.2.3 Access2003 Introduction 3
1.2.4 Visual Basic 6.0 Introduction 3
2 System Requirements Analysis and Feasibility Study 5
2.1 Business Process Analysis 5
2.2 Functional Analysis 5
2.3 Data Structure Analysis 5
3 System Design 7
3.1 System Functional Analysis 7
3.1.1 System Function Module 7
3.1.2 System Functional Block Diagram 7
3.2 Database Design 8
3.2.1 Data Dictionary 8
3.2.2 Design of the database table 9
4 system detailed design and implementation of 13
4.1 Login module design 13
4.2 Main Interface Design 13
4.3 Basic Information Management Menu Design 15
4.3.1 Vendor Information Form Design 15
4.3.2 Insurance Information Form Design 16
4.3.3 Vehicle Information Form Design 17
4.4 Customer Management menu to achieve 18 members
4.4.1 Customer Information Form to achieve 18
4.4.2 Member Information Form to achieve 19
4.4.3 Member Type Definition form to achieve 20
4.5 day to day business management menu to achieve 20
4.5.1 Car Rental Form to achieve 20
4.5.2 return the form to achieve 22 vehicles
4.6 User Information form to achieve 24
5 System Test 26
5.1 The purpose of software testing and test program 26
5.1.1 The purpose of software testing, 26
5.1.2 Software Testing Program 26
5.2 Software Testing Process 27
Summary 29
References 30
1 Introduction
1.1 Background and significance of the research
The development of modern science to enable computers into almost all fields. From scientific research to industrial and agricultural production, from production management to family life, and all walks of life are widely used with computers. The data and information management in today''s society can not do without computer technology support. How to realize the data fast, efficient, and practical management of the software development industry goal.
Today, with the development of social production, people''s living standards, motor vehicle leasing has become a great market potential of the industry, faced with the rapid development of the rental market, the traditional manual rental management during a multiplicity of business information processing seems very suited, therefore, it is about the use of computers to support coordination and management of rental demand is gradually increase the work of .
With the improvement of material conditions of society, the production pace of life speeds up, growing awareness of the importance of time, at work, life, more and more focus on how to save time and improve efficiency. Because of work and life''s sake, when necessary, car rental companies to lease the vehicles service requirements, has become a widely recognized and accepted by the public behavior and choices. In such a society driven by strong demand, vehicle leasing market has witnessed an unprecedented flourishing. Crowds of various car rental companies, business surged. However, in the busy behind the scenes, but it also exposed motor vehicle leasing companies in dealing with business information to artificially brought about mainly such as: inefficient management of confusion, mistakes increased, and many other disadvantages. In practice, the car rental industry, owners are increasingly aware of the use of computer leasing industry, the introduction of the importance of information management and began to constantly improve their own quality and high-tech investment in their work to improve information management, improve service efficiency .
Motor vehicle rental management is the vehicle information and customer information management, mainly including rental vehicles, state vehicles, basic information, the vehicle''s insurance situation, the vehicle''s factory situation, customer information management. Because the relationship between the complexity of these processes, there is one to one relationship, one to many relationship, there are many to many relationships, all of which have become the motor management of large and complex, previously included there is still a lot of rental the company manual management, directly led to the wrong generation, the low quality of service. Motor vehicle rental management system makes this situation has fundamentally improved. The management system includes covering all aspects of vehicle leasing business. Makes the motor vehicle rental services can be quickly completed specifications, saving manpower and material resources, improve the quality of service and economic benefits.
1.2 subject to achieve the basic functions of
Vehicle Rental Management System is aimed at motor vehicle rental companies provide rental cars to customers in the service process in the various problems faced by its business information automation, information processing, the vehicle lease administration has become standardized, fast, efficient .
Based on various aspects of research, while aiming at the actual situation of vehicle rental companies to access and apply databases, management information systems, software engineering, some of the basic principles and theories of thinking, a powerful application development features and database development functions Visual Basic6 .0 for the development of tools, designed and developed a set of vehicle rental management system. In the Windows environment, this system has a more friendly interface and the basic sound features, and easy to use, easy maintenance, strong adaptability.
The system, including customer information management, vehicle information management, car rental return of management, membership type, management, and membership information management, insurance companies, car dealers management. Have to add, modify, delete, query and other functions, through which management module, car rental services can be more clarity, more convenient and improve the quality of service, reducing the operator workload.
To standardize operational processes, reduce labor intensity and leasing business move towards a standardized and scientific, design and development of this management system, its use will help improve the leasing company''s labor productivity, reduce production costs and increase economic efficiency and, one hopes the industry''s job to provide some help.
1.2.1 Database Management System Introduction
Database is the latest data management technology is an important branch of computer science. The database is within the long-term storage in the computer, organized, and can share data sets. Data in the database organized according to a certain data model, description and storage, with less redundancy, higher data independence and easy extensibility, and can be for a variety of users to share. Database management system is located in a layer between the user and the operating system data management software . Main function of data definition, data manipulation functionality, database management and database running the establishment and maintenance functions. It is the database system is an important component of . More than ten years, database management systems from a dedicated application packages developed into a common system software. As the database has a data structure of the minimum redundancy, the higher the independence of the procedures and data, easy expansion, easy-to-application procedures for the preparation of the advantages of a larger information systems are built on top of database design . Therefore, not only large-scale computers and small computer, and even the microprocessor is equipped with a database management system. Currently, the database models of research and theoretical study are still thriving, its applications extend from general management to computer-aided design, artificial intelligence, and technical computing and other fields.
Today, the information resources has become an important asset in all departments and resources. The establishment of an information processing at all levels to meet the requirements of an effective information system has also become a business or organization an important condition for the survival and development . Therefore, as the core and foundation of information systems database technology has increasingly gained a wide range of applications, from small individual transaction processing systems to large-scale information systems, from the online transaction processing to online analytical processing, from general business management to computer-aided design and manufacturing ( CAD / CAM), computer integrated manufacturing system (CIMS), Office Information System (OIS), geographic information systems (GIS) and so on, more and more new applications using a database to store and manage their information resources . For a country, the construction of the database size, database size and the amount of information has become a measure of frequency of use in this country important indicator of the degree of information.
1.2.2 SQL Language Introduction
SQL (Structured Query Language) language is a 1974 made by Boyce and Chamberlin. 1975, -1,979, IBM''s San Jose Research Laboratory developed the well-known relational database management system prototype System R and implements the language. Because of its feature-rich, language simple Beishou the user and the computer industry welcomed by many computer companies and software used by companies. After the company''s continuously changing, and expanded and improved, SQL relational database language eventually developed into the standard language .
In October 1986 the U.S. National Bureau of Standards (American National Standard Institute, referred to as ANSI) Database Committee X3H2 approved a SQL relational database language of the United States as the standard. In the same year published a SQL standard text (the SQL-86). 1987 International Organization for Standardization (International Organization for Standardization, referred to as ISO) also adopted this standard. Since then, ANSI constantly modify and improve the SQL standard, and in 1989 published the SQL-89 standard, published in 1992, then SQL-92 standard .
Since the SQL as an international standard language after all database manufacturers have introduced their own software or with the SQL of SQL interface software. This makes the majority of the database are using SQL as a common data access language and standard interfaces, so that different database systems interoperability have a common basis . This is of great significance. Therefore, it was to establish the SQL relational database language standards and their subsequent development called a revolution. SQL as an international standard, outside the field of the database also had a significant impact, there are many software products will be SQL data query language features and graphics capabilities, software engineering tools, software development tools, artificial intelligence programs combined .
SQL is a relational algebra and the relationship between the structure between calculus-based query language, its function is not just inquiries. SQL is a generic, functional strong relational database language. SQL language set of data query, data manipulation, data definition and data control functions in one, the main features include: integrated and unified, highly non-procedural, set-oriented mode of operation to the same grammatical structure provides two kinds of usage, language simple easy to learn and easy to use. SQL database, the field has become a mainstream language.
Introduction 1.2.3 Access2003
Macrosoft companies produce go relational database package. It provides visual design interface, without writing code, you can quickly and easily develop a beautiful and practical database management system .
Access structure: Information (data) → field (field) → log (record) → file (file) → database (data base); information (data) → data item (item) → data record (record) → data table (table) → database (data base)
Access2003 has the following components:
Data Sheet: In order to access data storage place, is also a fundamental source of information, a database at least there is a table.
Inquiries: Keyi user needs, with some constraints (filter, filter ) to select the data table.
Forms: the establishment of a user input, query, modify the operation of the information screen.
Statement: The information on the use of statements made of the data library has information on the use of the value of the screen.
Data page: To access2003 additional objects, information released to the network medium. After the completion of the establishment of this object will be outside in the database file, and then generate a HTML file.
Macros: Create a simple data manipulation commands and the implementation of a series of actions will be automated. Applied to a number of repetitive movements or for the user to customize the working environment.
Module: development and application of the system tools. Is to allow users to control a more free-wheeling system .
3 System Design
3.1 System Functional Analysis
3.1.1 System Function Module Design
The completion of its main functions are as follows:
1, type information: including automotive types to add, modify or delete; car insurance types to add, modify or delete. Specific information including the category names, specific description;
2, vendors of information: including vendor information, to add, modify, delete, query, view the sales of cars. Specific information includes the vendor company name, contact address, telephone, fax, postal code, e-mail, contacts, notes;
3, the insurance company information: including insurance information to add, modify, delete, query, view the automobile insurance. Specific information, including insurance companies, company name, contact address, contact telephone, fax, postal code, e-mail, contacts, notes;
4, vehicle information: including vehicle information, search, modify, add, delete. Specific information, including the vehicle (1) basic information, there is plate number, vehicle type, vehicle name, vehicle color, engine number, chassis number, fuel oil number, purchase date, vendor, status, (2), insurance information, there is insurance company, policy number, start date, end date, insurance type, (3) rental price information, there is a deposit, Japan and rental, weekend rental, weekly rentals, monthly rentals, Japanese limited mileage, overtime costs, super-km costs, vehicle description;
5 Customer Information: including customer information to find, modify, add, delete, join the membership. Specific information includes (1) basic information, there are customer number, name, gender, age, ID number, telephone, work unit, address, ZIP, EMAIL, (2) driver''s license information, a driver''s permit number, license type, driving experience , certification date, expiration date, (3) collateral information, secured documents, guarantor, sponsor ID, sponsor units;
6, member information: membership information, including search, modify, cancel. Specific information includes (1) basic information, there are customer number, name, gender, age, ID number, telephone, work unit, address, ZIP, EMAIL, (2) driver''s license information, a driver''s permit number, license type, driving experience , certification date, expiration date, (3) collateral information, secured documents, guarantor, sponsor ID, sponsor unit, (4), membership information, with a membership type, discount;
7, member types: including membership types to add, modify or delete. Specific information includes the type name, the discount rate;
8, car rental: including car rental information to add, modify, delete, lease review, renewal, renewal audit. Specific information including contract number, license plate number, customer number, leasing model, number of working days over the weekend the number of mileage out of the bus, car rental time, off time, car rental costs, managers and enjoy the discount;
9, auto return: the return of information, the return of motor vehicles, modification, settlement auditing. Specific information including the contract number, enter the number of kilometers, the actual off time, other costs, paid the amount of managers;
10, the system user information: including adding users and delete users. Specific information including user name, password, confirm password;
11, the system help information: contains the software used in the process of a number of important and need to pay attention to the use of methods and other one
Summary
After the past few months of learning and exploration, I have finally completed the "motor vehicle rental management system." Through the development process, I am more in-depth grasp of the Visual Basic 6.0 to use the database and more profoundly understood. The very beginning of the development process, so I deeply appreciate the discipline of software engineering for the importance of program development. The development of a project, the programming process is not the most important, for those familiar with the programming language of software developers for a project code implementation is not difficult to achieve. Really important thing is those who needed to be done prior to programming. From software requirements analysis to system design, each step is very important, a high-quality software, from the outset of the good demand for solid analysis, system design and implementation of follow-up to lay a good foundation.
The system interface, beautiful design and reasonable, able to achieve the expected functionality, but the system fault-tolerance is not quite perfect. This shows that my programming skills to be improved. In the future I will continue to study hard and continue to enrich, and improve ourselves.
Overall, the system is designed to be broadly in line with user requirements and can be delivered to users.
Because I is limited, ideas and techniques in the design method may be more dull in the development of mastery of the language may be relatively shallow, therefore, reflected in the system, it is inevitable there are many shortcomings, the earnest hope that the teacher criticism, corrections.
References
Liu Tiechun. China''s vehicle market analysis study. The Automobile and Society .2003, (Z1)
Tie-Jun Xu. The current problems in vehicle leasing and countermeasures [J] China Business Research .1997, (05)
Guo Fushun. The basis of data structures and algorithms. Dalian University of Technology Press, 2002
Sa Shi Xuan. Introduction to Database System. Higher Education Press, 2003
Yu-Cai Feng. Database infrastructure. Huazhong University of Science Press, 2005.4
(U.S.) Nidesite (Niederst, J.) with, Zhao Sheng climbing, etc. translated. WEB Design Technical Manual (second edition). Mechanical Industry Press, 2003.1
Wang Shan. Principles of database systems. Tsinghua University Press, 2003.4
Jackson M A. Principles of Program Design.Academic Press 1975
Chang-Jin Yi. Information systems development and management. Machinery Industry Press, 2003.12
Warnier J D. Logical Construction of Programs.Van Nostrand 1974
Lee flag. Software Engineering Project Management Function Point Analysis method practice. Tsinghua University Press, 1999.4
Sen editor. Database application based Access 2000. Electronic Industry Press, 2002
Sai Kui-chun editor. Access database development instance of parsing. Mechanical Industry Press, 2006
Liu Bingwen. Visual Basic programming tutorial. Tsinghua University Press, 2002.3
[15] (U.S.) Hainle (Heinle) awaiting. Microsoft Visual Basic 6.0 components guide for Chinese version. Beijing Hope Electronic Press, 2003.7
[16] EricBrierley. Visual Basic Developer''s Guide. Mechanical Industry Press, 2002.12
