create database PXSCJ
on
(
name='PXSCJ_data',
filename='E:\SQL实验\DATA\PXSCJ.mdf',
size=3mb,
maxsize=unlimited,
filegrowth=1mb
)
log on
(
name='PXSCJ_log',
filename='E:\SQL实验\DATA\PXSCJ.ldf',
size=1mb,
maxsize=unlimited,
filegrowth=10%
)
go
use PXSCJ
go
create table XSB
(
XH char(6) not null primary key,
XM char(8) not null,
XB bit null default 1,
CSSJ datetime null,
ZY char(12) null,
ZXF int null default 0 check(ZXF>=0 and ZXF<=160),
BZ varchar(500) null,
LXFS xml null,
ZP image null,
)
go
use PXSCJ
go
create table KCB
(
KCH char(3) not null primary key,
KCM char(16) not null,
KKXQ tinyint null default 1,
XS tinyint null default 0,
XF tinyint not null default 0,
)
go
use PXSCJ
go
create table CJB
(
XH char(6) not null primary key,
KCH char(3) not null primary key,
CJ int null default 0,
)
go
use PXSCJ
go
insert into XSB values('081101','王林',1,'1990-2-10','计算机',50,
null,null,null)
insert into XSB values('081102','程明',1,'1991-2-1','计算机',50,
null,null,null)
insert into XSB values('081103','王燕',0,'1989-10-6','计算机',50,
null,null,null)
insert into XSB values('081104','韦严平',1,'1990-8-26','计算机',50,
null,null,null)
insert into XSB values('081106','李方方',1,'1990-11-20','计算机',50,
null,null,null)
insert into XSB values('081107','李明',1,'1990-5-1','计算机',54,
'提前修完《数据结构》，并获学分',null,null)
insert into XSB values('081108','林一帆',1,'1989-8-5','计算机',52,
'已提前修完一门课',null,null)
insert into XSB values('081109','张强民',1,'1989-8-11','计算机',50,
null,null,null)
insert into XSB values('081110','张蔚',0,'1991-7-22','计算机',50,
'三好学生',null,null)
insert into XSB values('081111','赵琳',0,'1990-3-18','计算机',50,
null,null,null)
insert into XSB values('081113','严红',0,'1989-8-11','计算机',48,
'有一门课不及格，待补考',null,null)
insert into XSB values('081201','王敏',1,'1989-6-10','通信工程',42,
null,null,null)
insert into XSB values('081202','王林',1,'1989-1-29','通信工程',40,
'有一门课不及格，待补考',null,null)
insert into XSB values('081203','王玉民',1,'1990-3-26','通信工程',42,
null,null,null)
insert into XSB values('081204','马琳琳',0,'1989-2-10','通信工程',42,
null,null,null)
insert into XSB values('081206','李计',1,'1989-9-20','通信工程',42,
null,null,null)
insert into XSB values('081210','李红庆',1,'1989-5-1','通信工程',44,
'已提前修完一门课，并获得学分',null,null)
insert into XSB values('081216','孙祥欣',1,'1989-3-19','通信工程',42,
null,null,null)
insert into XSB values('081218','孙研',1,'1990-10-9','通信工程',42,
null,null,null)
insert into XSB values('081220','吴薇华',0,'1990-3-18','通信工程',42,
null,null,null)
insert into XSB values('081221','刘燕敏',0,'1989-11-12','通信工程',42,
null,null,null)
insert into XSB values('081241','罗琳琳',0,'1990-1-30','通信工程',50,
'转专业学习',null,null)
go
use PXSCJ
go
insert into KCB values('101','计算机基础',1,80,5)
insert into KCB values('102','程序设计与语言',2,68,4)
insert into KCB values('206','离散数学',4,68,4)
insert into KCB values('208','数据结构',5,68,4)
insert into KCB values('210','计算机原理',5,85,5)
insert into KCB values('209','操作系统',6,68,4)
insert into KCB values('212','数据库原理',7,68,4)
insert into KCB values('301','计算机网络',7,51,3)
insert into KCB values('302','软件工程',7,51,3)
go
use PXSCJ
go
insert into CJB values('081101','101',80)
insert into CJB values('081101','102',78)
insert into CJB values('081101','206',76)
insert into CJB values('081103','101',62)
insert into CJB values('081103','102',70)
insert into CJB values('081103','206',81)
insert into CJB values('081104','101',90)
insert into CJB values('081104','102',84)
insert into CJB values('081104','206',65)
insert into CJB values('081102','102',78)
insert into CJB values('081102','206',78)
insert into CJB values('081106','101',65)
insert into CJB values('081106','102',71)
insert into CJB values('081106','206',80)
insert into CJB values('081107','101',78)
insert into CJB values('081107','102',80)
insert into CJB values('081107','206',68)
insert into CJB values('081108','101',85)
insert into CJB values('081108','102',64)
insert into CJB values('081108','206',87)
insert into CJB values('081109','101',66)
insert into CJB values('081109','102',83)
insert into CJB values('081109','206',70)
insert into CJB values('081110','101',95)
insert into CJB values('081110','102',90)
insert into CJB values('081110','206',89)
insert into CJB values('081111','101',91)
insert into CJB values('081111','102',70)
insert into CJB values('081111','206',76)
insert into CJB values('081113','101',63)
insert into CJB values('081113','102',79)
insert into CJB values('081113','206',60)
insert into CJB values('081201','101',80)
insert into CJB values('081202','101',65)
insert into CJB values('081203','101',87)
insert into CJB values('081204','101',91)
insert into CJB values('081210','101',76)
insert into CJB values('081216','101',81)
insert into CJB values('081218','101',70)
insert into CJB values('081220','101',82)
insert into CJB values('081221','101',76)
insert into CJB values('081241','101',90)
go
- 1
- 2
前往页