(完整word版)汽车租赁系统数据库设计.pdf

汽车租赁系统一、课程设计的目的和意义随着汽车租赁领域的繁荣和飞速发展，租车行业的信息量越来越大，越来越复杂。传统的管理方式无法适应当前迅速发展的市场，计算机和计算机网络技术迅速发展和普及，使用汽车租赁系统可以使得汽车租赁的效率得到很大的提高，同时降低经营成本，提高利润。应用对数据库原理的理论学习，通过实践熟练掌握数据库创建、基本操作、程序系统的建立。并通过数据库原理软件设计实践，巩固在课堂教学中学习的关于数据库原理的有关知识和数据库系统建立的方法，熟练掌握对于实际问题，为了建立一个关系数据库信息管理系统，必须得经过需求分析、概念结构设计、逻辑结构设计、物理结构设计、数据库实施以及数据库运行和维护的一般过程，为毕业设计打下基础。二、术语定义E-R 图：为理解和表示问题域的信息而建立的数据模型，简称E-R 图。具有实体、关系、属性三要素。数据流图：数据流图是用来描绘软件系统逻辑模型的图形工具，是描绘信息在系统中流动和处理的情况的。数据字典：数据字典是对数据流图中出现的所有数据元素、数据流、文件、处理的定义的集合。三、数据库的要求主要功能：本系统包括客户信息管理、车辆信息管理、汽车租赁归还管理、会员类型管理、会员信息管理、保险公司管理、汽车经销商管理等。具有添加、修改、查询、删除等功能。方便租赁公司的工作，提高租赁公司的工作质量和工作效率。性能要求：租借和归还信息必须及时更新，汽车租赁系统的信息必须无差错的存储在主服务器上。输出要求：数据完整，详实。输出要求：简捷，快速，实时、准确。安全与保密要求：管理员享有对客户信息库及汽车租借信息库和职员信息库的管理与修改。工作人员只享有对汽车租赁信息库的部分修改（写入与读出）。完成期限：预计三个月一、汽车租赁系统需求分析：系统功能需求：1）客户可以通过不同的方式（包括电话、前台、网上）预订车辆1、能够保存客户的预订申请单2、能够保存客户的历史记录3、工作人员可以处理申请4、技术人员可以保存对车辆检修的结构2）满足以上功能需要以下几个模块：1、基本数据维护模块。基本数据维护模块提供了使用者录入、修改并维护基本数据的途径。例如对客户的个人信息、租赁信息、车辆的基本信息等的录入和修改2、基本业务模块。基本业务模块中，客户可以填写汽车租赁申请表，工作人员负责处理这些表格。同时，技术人员可以提交每辆车的状态，以便工作人员根据这些资料决定是否批准客户的请求。3、数据库管理模块。在汽车租赁系统中，对客户、工作人员及车辆的信息都要进行统一管理，车辆的租赁情况也要进行详细的登记。4、信息查询模块。信息查询模块主要用于查询相关信息，例如工作人员查询车辆信息和客户信息等。文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9如以下层次图所示：基本业务模块信息管理模块信息查询模块基本数据维护模块管理员处理续租请求客户填写还车信息管理员处理还车请求删除客户信息修改客户信息添加客户信息删除车辆信息修改车辆信息添加车辆信息客户填写预定信息客户填写续租信息管理员处理预定请求管理员填写服务记录车辆信息管理租赁信息管理客户信息管理查询租赁服务记录查询客户信息查询车辆信息查询租赁信息汽车租赁系统数据字典1、公司数据字典属性名存储代码类型长度备注编号Fno char 20 汽车租赁公司的编号名称Fname char 20 汽车租赁公司名称电话Ftell char 20 汽车租赁公司联系方式地址Faddress char 50 汽车租赁公司的地址电子邮箱Femail char 50 汽车租赁公司的电子邮箱传真Ffax char 20 汽车租赁公司的传真邮编Fzip char 10 汽车租赁公司的邮编2、汽车数据字典属性名存储代码类型长度备注文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9编号Cno char 20 汽车车牌号名称Cname char 20 汽车品牌名类型Ctype char 20 汽车所属类型颜色Colour char 20 汽车颜色使用时间Ctime char 20 汽车从投入使用到现在的时间行驶里程Cmileage char 20 汽车总共行驶的时间租赁价格Cprice long 10 租赁汽车每小时多少钱逾期价格Oprice long 10 超过该时间每小时多少钱状态State char 10 在库或不在库3、车辆保险数据字典属性名存储代码类型长度备注车险号Bno char 20 车辆保险类型号码车险名Bname char 20 车辆保险保单名字所保车号Cnumber char 20 投保车辆的车牌号投保时间Bdate date 8 签订保单的时间年限Btime int 10 车辆保险的有效时间保险额Bmoney int 10 投保金额所属公司Dname char 20 保险公司名字4、保险公司数据字典属性名存储代码类型长度备注公司名Dname char 20 保险公司名公司地址Daddress char 20 保险公司地址联系电话Dtel1 int 20 公司联系电话文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9投诉电话Dtel2 int 20 事故报警电话5、客户数据字典属性名存储代码类型长度备注编号Kno char 20 客户编号姓名Kname char 20 客户姓名身份证号Knumber int 20 客户身份证号码性别Ksex char 4 客户性别联系电话Ktel int 20 客户联系电话电子邮箱Kemail char 50 客户电子邮箱有无驾照Klicense char 4 客户是否持有驾驶证驾驶证编号Lnumber char 30 有驾驶证的客户的驾照编号驾驶证类型Lkind char 20 有驾驶证的客户的驾照类型家庭住址Kaddress char 20 客户的家庭住址工作单位Kwork char 20 客户工作单位取车时间gettime char 20 客户取车时间预定使用时间usetime char 20 客户使用车多久还车时间returntime char 20 客户最后的还车时间6、会员类型信息表属性名存储代码类型长度备注会员编号Mno char 20 会员编号用户名Mmane char 20 会员姓名级别Mlevel Double 8 会员所在级别7、司机数据字典文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9属性名存储代码类型长度备注姓名Sname char 20 司机姓名性别Ssex char 4 司机性别年龄Syear int 4 司机年龄身份证号Snumber1 int 20 司机身份证号码职工号Snumber2 int 20 司机职工号码驾龄Sold int 4 司机驾驶车辆的时间驾照类别Sclass char 4 司机所持驾照类别联系电话Stel int 20 司机联系电话8、租赁数据字典属性名存储代码类型长度备注流水号Znumber int 20 客户签订租赁单据的号码客户姓名Kname char 20 客户姓名身份证号Knumber int 20 客户身份证号联系电话Ktel int 20 客户联系电话车名Cname char 20 客户所租的车辆的车名车辆类型Ctype char 20 客户所租的车辆的类型车辆牌号Cnumber char 20 客户所租的车辆的车牌号司机姓名Sname char 20 客户所雇佣的司机，是否雇司机遵循自愿原则司机工号Snumber2 int 20 司机的职工号起租时间Sdate1 date 12 开始租车的时间，精确到分。例：201110291551 还租时间Sdate2 date 12 还车时间，精确到分。押金Smoney1 int 10 押在租赁公司的资金，换车时退还。文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9租金Smoney2 int 10 租赁公司收取的租车费用是否投保Sbaoxan char 4 所租车辆是否投保9、雇佣数据字典属性名存储代码类型长度备注客户姓名Kname char 20 客户姓名身份证号Knumber int 20 客户的身份证号联系电话Ktel int 20 客户的联系电话司机姓名Sname char 20 雇佣司机的姓名司机工号Snumber2 int 20 司机的职工号司机性别Ssex char 4 司机的性别驾照类别Sclass char 4 司机的驾照类型司机驾龄Sold int 4 司机的驾龄开始时间Gdate1 date 12 客户开始雇佣司机的时间，精确到分结束时间Gdate2 date 12 客户与司机结束雇佣关系的时间司机电话Stel int 20 司机的联系电话佣金Gmoney int 10 客户付给司机的工钱E-R 图公司实体E-R 图汽车实体E-R 图车辆保险E-R 图保险公司E-R 图客户信息E-R 图会员实体E-R 图司机实体E-R 图文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8 HR5T10C6U8I6 ZF3R1X3K7C9文档编码:CC4D3V4S6Z8