郑洋 课程设计数据库.txt

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

//jianli de shenqing biao

create table sqbiao
(
bumensq char(10),
zcsq int,
name char(10),
numsq int,
mjsq int,
zfjf int
);


create view yff_tj
as
select bumensq,zcsq,name,numsq,mjsq,zfjf
from tjsqbiao;

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


//jianli kong fang wenjian
create table kfwenjian
(
fangh int,
mianj int,
zdjifen int,
zjin int
);
insert 
into kfwenjian
values('101','100','10','100');

insert 
into kfwenjian
values('102','110','11','105');

insert 
into kfwenjian
values('103','90','9','90');

insert 
into kfwenjian
values('104','120','8','120');

insert 
into kfwenjian
values('105','100','10','100');

insert 
into kfwenjian
values('106','130','13','130');

insert 
into kfwenjian
values('107','150','15','150');

insert 
into kfwenjian
values('108','100','10','100');

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

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