《汽车站管理系统设计方案》由会员分享，可在线阅读，更多相关《汽车站管理系统设计方案（15页珍藏版）》请在金锄头文库上搜索。
1、汽车站管理系统设计方案汽车站管理系统设计方案一、一、 系统简要介绍系统简要介绍主要实现的功能是汽车站驾驶人员和路线及汽车等基本信息进行管理，包括浏览驾驶员信息、路线信息，查询和统计一些驾驶员、汽车等数据，修改驾驶员行走的路线信息等。二、二、 本系统有四张表组成，表结构如下：本系统有四张表组成，表结构如下：驾驶员表：（驾驶员编号，汽车编号，姓名，生日，性别，工作年限）汽车表：（汽车编号，型号，载客量，票价）路线表：（路线编号，目的地，行程时间，出发地）汽车路线表：（汽车编号，路线编号）三、三、 表间关系说明表间关系说明一个驾驶员属于一辆车，一辆车可以有多个驾驶员，一辆车可以行走多条路线，一条路线
2、也可有多辆车行走。四、四、ER 图如下图如下：驾驾 驶驶 员员 表表 属属于于 汽汽车车表表 路路线线表表 汽汽 车车 路路 线线表表 驾驶员表驾驶员表属于属于汽车表汽车表路线表路线表汽车路线汽车路线 表表五五.各表的简单介绍和创建代码：各表的简单介绍和创建代码：1.驾驶员表 driver字段含义字段名称字段类型驾驶员编号driverIDNUMBER汽车编号carIDNUMBER姓名nameVARCHAR2(20)生日birthdayDATETIME性别sexNUMBER工作年限standingNUMBER创建驾驶员表：CREATE TABLE driver(driverID INTEGER
3、NOT NULL ,car_ID INTEGER NOT NULL ,name VARCHAR2(20) NULL ,brithday DATE NULL ,sex INTEGER NULL ,standing INTEGER NULL )2.汽车表 car：字段含义字段名称字段类型汽车编号carIDNUMBER类型typeVARCHAR2(20)载客量capacityNUMBER票价ticket_priceNUMBER创建汽车表表：CREATE TABLE car(car_ID INTEGER NOT NULL ,type VARCHAR2(20) NULL ,capacity VARCHA
4、R2(20) NULL ,ticket_price INTEGER NULL );3.路线表 line字段含义字段名称字段类型路线编号lineIDNUMBER目的地destinationVARCHAR2(20)所需时间take_timeVARCHAR2(20)出发地start_addressVARCHAR2(20)创建活动表：CREATE TABLE line(lineID INTEGER NOT NULL ,destination VARCHAR2(20) NULL ,take_time VARCHAR2(20) NULL ,start_address VARCHAR2(20) NULL )
5、;六六.插入数据插入数据 insert1.汽车表数据insert into car (car_ID,type,capacity,ticket_price) values (091201,飞鹤,45,56);insert into car (car_ID,type,capacity,ticket_price) values (091202,快鹿,40,70);insert into car (car_ID,type,capacity,ticket_price) values (091203,鸵鸟,42,34);insert into car (car_ID,type,capacity,ticke
6、t_price) values (091204,风火轮,45,56);insert into car (car_ID,type,capacity,ticket_price) values (091205,筋斗云,38,46);insert into car (car_ID,type,capacity,ticket_price) values (091206,白龙马,42,79);insert into car (car_ID,type,capacity,ticket_price) values (091207,毛驴,36,99);insert into car (car_ID,type,cap
7、acity,ticket_price) values (091208,青牛,50,88);2.驾驶员数据insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491001,091201,吴士,TO_DATE(1-2 月 -1981,dd-Mon-yyyy),1,6);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491002,091204,孙悟,TO_DATE(11-9 月 -1974,dd-Mon-yy
8、yy),1,15);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491003,091203,李娇,TO_DATE(12-4 月 -1979,dd-Mon-yyyy),0,9);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491004,091202,夏雨荷,TO_DATE(5-1 月 -1983,dd-Mon-yyyy),0,6);insert into driver (driverID,car
9、_ID,name,brithday,sex,standing)values (19491005,091205,刘备,TO_DATE(12-5 月 -1977,dd-Mon-yyyy),1,16);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491006,091208,诸葛亮,TO_DATE(1-1 月 -1985,dd-Mon-yyyy),1,4);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19
10、491007,091206,陈娜,TO_DATE(11-3 月 -1975,dd-Mon-yyyy),0,17);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491008,091207,张海风,TO_DATE(8-4 月 -1978,dd-Mon-yyyy),1,10);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491009,091201,朱翠翠,TO_DATE(10-1 月 -1980,d
11、d-Mon-yyyy),0,8);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491010,091204,赵薇,TO_DATE(8-9 月 -1988,dd-Mon-yyyy),0,1);insert into driver (driverID,car_ID,name,brithday,sex,standing)values (19491011,091208,李鸣,TO_DATE(10-2 月 -1978,dd-Mon-yyyy),1,12);insert into driver (drive
12、rID,car_ID,name,brithday,sex,standing)values (19491012,091203,周杰磊,TO_DATE(6-6 月 -1981,dd-Mon-yyyy),1,4);3.路线表数据insert into line (lineID,destination,take_time,start_address) values (201001,上海,3 小时,南京);insert into line (lineID,destination,take_time,start_address) values (201002,南通,4 小时,南京);insert into
13、 line (lineID,destination,take_time,start_address) values (201003,苏州,3 个半小时,南京);insert into line (lineID,destination,take_time,start_address) values (201004,盐城,3 小时 20 分,南京);insert into line (lineID,destination,take_time,start_address) values (201005,泰州,2 个半小时,南京);insert into line (lineID,destinatio
14、n,take_time,start_address) values (201006,扬州,2 小时,南京);insert into line (lineID,destination,take_time,start_address) values (201007,上海,3 小时,南京);insert into line (lineID,destination,take_time,start_address) values (201008,苏州,3 小时,南京);4.汽车路线表数据insert into car_line (carID,lineID) values (91202,201001 );
15、insert into car_line (carID,lineID) values (91207,201002 );insert into car_line (carID,lineID) values (91208,201007 );insert into car_line (carID,lineID) values (91206,201003 );insert into car_line (carID,lineID) values (91205,201008 );insert into car_line (carID,lineID) values (91204,201005 );insert into car_line (carID,lineID) values (91201,201004 );insert into car_line (carID,lineID) values (91203,201006 );inse
