数据描述、定义（实验一）

create database 学生课程;
use 学生课程;
go
create table Student
(
 Sno int primary key,
 Sname char(10),
 Ssex char(2),
 Sage int,
 Sdept char(10)
);
go
create table Course
(
 Cno int primary key,
 Cname char(20),
 Cpno int,
 Credit int
);
go
create table SC
(
 Sno int,
 Cno int,
 Grade int,
 primary key(Sno,Cno)
);
go

insert into Student values(1222,'张丽','女',21,'计算机');
insert into Student values(1223,'刘立','男',25,'生物');
insert into Student values(1224,'王晓华','女',22,'计算机');
insert into Student values(1225,'李佳','男',23,'计算机');
insert into Student values(1226,'张月','女',22,'建筑');
go

insert into Course values(1,'数据库',2,4);
insert into Course values(2,'数据结构',3,4);
insert into Course values(3,'C语言',0,4);
insert into Course values(4,'数学',0,4);
insert into Course values(5,'生物学导论',0,3);
go

insert into SC values(1222,1,95);
insert into SC values(1222,2,80);
insert into SC values(1222,3,92);
insert into SC values(1222,4,90);
insert into SC values(1223,4,85);
insert into SC values(1223,2,90);
insert into SC values(1224,1,93);
insert into SC values(1225,1,87);
insert into SC values(1226,5,88);
insert into SC values(1224,2,89);

go