数据库建库代码以及与该库有关的练习

•     学生表：Student(Sno,Sname,Ssex,Sage,Sdept)
•     课程表：Course(Cno,Cname,Cpno,Ccredit)
•     学生选课表：SC(Sno,Cno,Grade)

student表

sno	sname	ssex	sage	sdept
200215121	李勇	男	20	软件工程
200215122	刘晨	女	19	计算机科学与技术
200215123	王敏	女	18	信管
200215125	张立	男	19	计算机科学与技术

create table student(
	sno varchar(15),
	sname varchar(15),
	ssex varchar(4),
	sage int(4),
	sdept varchar(15),
	constraint pk_student primary key(sno)
);

insert into student VALUES("200215121", "李勇", "男", 20, "软件工程");
insert into student VALUES("200215122", "刘晨", "女", 19, "计算机科学与技术");
insert into student VALUES("200215123", "王敏", "女", 18, "信管");
insert into student VALUES("200215125", "张立", "男", 19, "计算机科学与技术");

---

course表

cno	cname	cpno	ccredit
1	数据库	5	4
2	数学		2
3	信息系统	1	4
4	操作系统	6	3
5	数据结构	7	4
6	数据处理	5	2
7	PASCAL语言	6	4

create table course (
	cno int(4) primary key,
	cname varchar(15),
	cpno int(4),
	ccredit int(4)
);

insert into course values(1, "数据库", 5, 4);
insert into course(cno, cname, ccredit) values(2, "数学", 2);
insert into course values(3, "信息系统", 1, 4);
insert into course values(4, "操作系统", 6, 3);
insert into course values(5, "数据结构", 7, 4);
insert into course values(6, "数据处理", 5, 2);
insert into course values(7, "PASCAL语言", 6, 4);

---

sc表

sno	cno	grade
200215121	1	92
200215121	2	85
200215121	3	88
200215122	2	90
200215122	3	80

create table sc(
	sno varchar(15),
	cno int(4),
	grade int(4),
	constraint pk_sc primary key(sno, cno)
);

insert into sc values("200215121",1, 92);
insert into sc values("200215121",2, 85);
insert into sc values("200215121",3, 88);
insert into sc values("200215122",2, 90);
insert into sc values("200215122",3, 80);