数据库普通作业——建库

最新推荐文章于 2024-07-25 14:08:23 发布

sevenlob

最新推荐文章于 2024-07-25 14:08:23 发布

阅读量171

点赞数

分类专栏：笔记文章标签： mysql sqlserver

本文链接：https://blog.csdn.net/sevenlob/article/details/117105784

版权

笔记专栏收录该内容

20 篇文章 2 订阅

订阅专栏

数据库普通作业——建库

USE master
GO
SET NOCOUNT ON
create table Student(
    Sno char(10)  primary key,
    Sname varchar(20),
    Ssex char(2),
    Sage smallint,
    Sdept varchar(20),

);

create table Course(
	Cno char(10) primary key,
	Cname varchar(20),
	Cpno char(20),
	Ccredit smallint,
);

create table SC(
Sno char(10),
Cno char(10),
primary key(Sno,Cno),
Grade smallint,
);

insert into Student values ('001','Cindy','f','18','MU');
insert into Student values ('002','Seven','f','21','CS');
insert into Student values ('003','Tom','m','12','CS');
insert into Student values ('004','Jim','m','20','MA');
insert into Student values ('005','Tina','f','21','MA');
insert into Student values ('006','Christy','f','23','MU');
insert into Student values ('007','Live','f','16','MU');
insert into Student values ('008','Jesscia','f','20','MA');
insert into Student values ('009','Judy','f','21','CS');
insert into Student values ('010','Amber','f','16','MU');
insert into Student values ('011','Chirs','f','18','MU');
insert into Student values ('012','Jackson','m','22','CS');

insert into Course(cno,cname,ccredit) values ('C01','Sports','2');
insert into Course values ('C02','Oracle','C01','3');
insert into Course values ('C03','Arithmetic','C01','2');
insert into Course values ('C04','DB','C03','2');
insert into Course(Cno,Cname,Ccredit) values ('C05','Music','2');
insert into Course values ('C06','Chinese','C01','2');
insert into Course values ('C07','English','C06','2');
insert into Course values ('C08','Java','C03','2');

insert into SC values('001','C01','70');
insert into SC values('001','C02','82');
insert into SC values('002','C01','86');
insert into SC values('002','C02','83');
insert into SC values('002','C03','90');
insert into SC values('002','C04','98');
insert into SC values('002','C05','96');
insert into SC values('002','C06','85');
insert into SC values('002','C07','88');
insert into SC values('002','C08','78');
insert into SC values('003','C01','89');
insert into SC values('003','C03','90');
insert into SC values('003','C05','87');
insert into SC values('003','C06','86');
insert into SC values('003','C07','68');
insert into SC values('003','C08','86');
insert into SC values('004','C01','60');
insert into SC values('004','C02','62');
insert into SC values('004','C03','53');
insert into SC values('004','C06','45');
insert into SC values('004','C07','65');
insert into SC values('005','C01','98');
insert into SC values('005','C06','85');
insert into SC values('006','C01','90');
insert into SC values('006','C02','82');
insert into SC values('006','C03','77');
insert into SC values('006','C04','65');
insert into SC values('006','C05','95');
insert into SC values('006','C06','55');
insert into SC values('006','C07','82');
insert into SC values('006','C08','79');
insert into SC values('007','C01','98');
insert into SC values('007','C02','86');
insert into SC values('008','C01','64');
insert into SC values('009','C01','97');
insert into SC values('009','C02','55');
insert into SC values('010','C01','88');
insert into SC values('010','C03','89');
insert into SC values('010','C06','84');
insert into SC values('011','C01','87');

GO