
资源由 www.eimhe.com 美河学习在线收集分享
CName nvarchar(20) not null,
T# varchar(3) not null foreign key references tblTeacher(teaId)
)
create table SC
(
S# varchar(5) not null foreign key references Student(S#),
C# varchar(3) not null foreign key references Course(C#),
Score float
)
----------------------------------表结构----------------------------------------------------
--学生表 Student(编号 S#、姓名 SName、年龄 SAge、性别 SSex)
--课程表 Course(课程编号 C#、课程名称 CName、教师编号 T#)
--成绩表 SC(学生编号 S#、课程编号 C#、成绩 Score)
--教师表 Teacher(教师编号 T#、姓名 TName)
--------------------------------插入数据-------------------------------------------------
insert into Student
select '1000','张无忌',18,'男' union
select '1001','周芷若',19,'女' union
select '1002','杨过',19,'男' union
select '1003','赵敏',18,'女' union
select '1004','小龙女',17,'女' union
select '1005','张三丰',18,'男' union
select '1006','令狐冲',19,'男' union
select '1007','任盈盈',20,'女' union
select '1008','岳灵珊',19,'女' union
select '1009','韦小宝',18,'男' union
select '1010','康敏',17,'女' union
select '1011','萧峰',19,'男' union
select '1012','黄蓉',18,'女' union
select '1013','郭靖',19,'男' union
select '1014','周伯通',19,'男' union
select '1015','瑛姑',20,'女' union
select '1016','李秋水',21,'女' union
select '1017','黄药师',18,'男' union
select '1018','李莫愁',18,'女' union
评论