学生信息数据库
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
create database xs
go
use xs
go
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsXJ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsXJ]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsKC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsKC]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsZY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsZY]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsBJ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsBJ]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsCJ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsCJ]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsYH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsYH]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[xsOD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[xsOD]
GO
/*建立学生信息表xsXJ*/
create table xsXJ(
sno char(15) primary key,
sname char(20),
sex char(5),
politics_status char(12),
birth date,
profession char(20),
class char(20),
addr varchar(50),
tel char(15),
remark varchar(50)
);
/*建立课程信息表xsKC*/
create table xsKC(
cname char(20) primary key,
profession char(20)
);
/*建立专业信息表xsZY*/
create table xsZY(
pro_no char(20) primary key,
dept char(20)
);
/*建立班级信息表xsBJ*/
create table xsBJ(
class char(20) primary key,
dept char(20),
instructor char(10),
classroom char(15),
num char(3)
);
/*建立成绩信息表xsCJ*/
create table xsCJ(
sno char(15)
sname char(20)
profession char(20)
cno identity,
cname char(20),
grade char(3),
primary key(sno,cname),
foreign key(sno) references xsXJ(sno),
foreign key(cname) references xsKC(cname)
);
/*建立用户表xsYH*/
create table xsYH(
sno char(15) primary key,
sname char(20),
password char(15)，
user_name char(20)，
foreign key(sno) references xsXJ(sno)
);
/*操作日记表xsOD*/
create table xsOD(
user_name char(20),
od_date datetime,
od_time datetime,
primary key(user_name,od_date,od_time)
);