计算机二级 20101113(2)

分数 n(3,0),;

primary key 学号+课程编号 tag tsh,; foreign key 学号 tag 学号 references 学生,;

foreign key 课程编号 tag 课程编号 references 课程)

添加系表

insert into 系 values ('01',"经管系") insert into 系 values ('02',"机电系") insert into 系 values ('03',"中文系") insert into 系 values ('04',"数学系") insert into 系 values ('05',"计科系") insert into 系 values ('06',"体育系") 添加学生表

insert into 学生 values ('20080235201','01',"张敏","女",{^1989-8-1},"汉",4500)

insert into 学生 values ('20080235202','01',"李敏","女",{^1989-8-1},"汉",1500)

insert into 学生 values ('20080235203','02',"张佳","女