寄骆氏亭 拼音版:数据描述、定义(实验一)
来源:百度文库 编辑:偶看新闻 时间:2024/04/26 06:37:14
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