cpgl.sql

课程设计自己写的一个汽车票管理系统用Visual C++实现的程序代码

create database cpgl
go 
use cpgl
go
/*创建车票表,包括车次(cc),票价(pj)和终点(zd)*/
create table cp
(
	cc varchar(5) primary key,
	pj real,
	zd varchar(20)
)

/*创建车次表,包括车次(cc),发车时间(fcsj)*/
create table cc
(
	cc varchar(5) foreign key references cp(cc),
	fcsj varchar(10),
	primary key(cc,fcsj)
)

/*主表,即整个过程中维护的最重要的一张表包括车票号(cph)车次(cc)发车日期(fcrq)和发出时间(fcsj)*/
create table main
(
	cph varchar(10) primary key,
	cc varchar(5) foreign key references cp(cc),
	fcrq varchar(5),
	fcsj varchar(10)
)
/*插入初始化数据*/
insert into cp values('N421',95,'济南'
insert into cp values('N486',80,'德州')
insert into cp values('N571',60,'青岛')

insert into cc values('N421','12:35')
insert into cc values('N421','09:40')
insert into cc values('N421','15:20')
insert into cc values('N421','17:35')

insert into cc values('N486','06:00')
insert into cc values('N486','12:25')
insert into cc values('N486','14:50')

insert into cc values('N571','09:00')
insert into cc values('N571','15:30')