汽车站数据库设计.doc

. . . .
6 / 6
汽车站数据库设计
系统简要介绍
主要实现的功能是汽车站驾驶人员和路线及汽车等基本信息进行管理,包括浏览驾驶员信息、路线信息,查询和word>
>;


insert into car values<'091201','飞鹤','45'>;
insert into car values<'091202','快鹿','40'>;
insert into car values<'091203','鸵鸟','42'>;
insert into car values<'091204','风火轮','45'>;
insert into car values<'091205','筋斗云','38'>;
insert into car values<'091206','白龙马','42'>;
insert into car values<'091207','毛驴','36'>;
insert into car values<'091208','青牛','50'>;

insert into driver <driverID,car_ID,name,brithday,sex,standing>
values <'19491001','091201','吴士','1981','1','6'>;
insert into driver <driverID,car_ID,name,brithday,sex,standing>
values <'19491002','091204','悟','1974','1','15'>;
insert into driver <driverID,car_ID,name,brithday,sex,standing>
values <'19491003','091203','娇','1979','0','9'>;
insert into driver <driverID,car_ID,name,brithday,sex,standing>
values <'19491004','091202','夏雨荷','1983','0','6'>;
insert into driver <driverID,car_ID,name,brithday,sex,standing>
. . . .
4 / 6
values <'19491005','091205','备','1977','1','16'>;
insert into driver <driverID,car_ID,name,brithday,sex,standing>
values <'19491006','091208','诸亮','1985','1','4'>;
insert into driver <driverID,car_ID,name,brithday,sex,standing>
values <'19491007','091206','娜','1975','0','17'>;
insert i