郑洋 课程设计数据库.txt

课程设计课程设计课程设计课程设计课程设计课程设计

//jianli de shenqing biao

create table sqbiao1
(
bumensq char(10),
zcsq char(5),
name char(15),
numsq char(5),
mjsq char(10),
zfjf char(5)
);


//jianli de ti jiao shenqing biao
create table tjsqbiao1
(
bumensq char(10),
zcsq char(5),
name char(15),
numsq char(5),
mjsq char(10),
zfjf char(5)
);


//jianli kong fang wenjian
create table kfwenjian1
(
fangh char(10),
mianj char(10),
zdjifen char(5),
zjin char(10)
);
insert 
into kfwenjian1
values('001','100','6','100');

insert 
into kfwenjian1
values('002','110','7','105');

insert 
into kfwenjian1
values('003','90','5','90');

insert 
into kfwenjian1
values('004','120','8','110');

insert 
into kfwenjian1
values('005','100','6','100');

insert 
into kfwenjian1
values('006','130','9','120');

insert 
into kfwenjian1
values('007','150','12','140');

insert 
into kfwenjian1
values('008','100','6','100');

//jianli yifen fang wenjian
create table yffwenjian1
(name char(15),
bumen char(10),
zc char(5),
num char(5),
zffs char(5),
fangh char(10),
mianj char(10)
);

//diao fang biao
create table dfbiao
(
bumendf char(10),
zcdf char(5),
numdf char(5),
zfjf char(5),
yfmj char(10),
yfangh char(10),
yqmj char(10)
);