⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 jimmy.txt

📁 学生类：Student 教师类：Teacher 主任：AdminTeacher 班主任：MasterTeacher 授课老师： PrelectTeacher 班级类：classTeam 班
💻 TXT
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	claMasterID int default 10000 constraint FK_ClassInfo_claMasterID
foreign key(claMasterID) references TeacherInfo(teaID),	--班主任编号
	claMonitorID int default 10001,			--班长编号
	claStartDate smalldatetime default getDate(),	--开学日期
	claCeaseDate smalldatetime default '2000-01-01',--结业日期
	claHours int default 0,				--总课时
	claStudentNumber int default 0,			--学生总数
	claRemark text default ''			--备注
)
go



---------------------输入班级基本信息表数据----------------------------------
--插入一条公共班级信息和，其本身并不存在，作为必要时的默认值是用
insert ClassInfo values('0000',default,default,'2000-01-01','2000-01-01',default,default,default)
----实际班级信息------
insert ClassInfo values('S150',10005,default,'2005-03-05','2005-07-25',200,35,default)
insert ClassInfo values('S151',10005,default,'2005-04-05','2005-08-25',200,33,default)
insert ClassInfo values('S152',10005,default,'2006-01-05',default,200,30,default)
insert ClassInfo values('S153',10005,default,'2006-04-05',default,200,31,default)
insert ClassInfo values('S230',10003,default,'2005-08-30','2006-02-26',246,32,default)
insert ClassInfo values('S231',10003,default,'2006-09-03',default,246,33,default)
insert ClassInfo values('S232',10003,default,'2006-10-08',default,246,34,default)
insert ClassInfo values('Y210',10004,default,'2006-03-01','2006-09-24',292,31,default)
insert ClassInfo values('Y211',10004,default,'2006-10-10',default,292,30,default)
go




------------------------------创建教师授课信息表-------------------------------
if exists(select * from sysobjects where name = 'PrelectInfo')
	drop table PrelectInfo
go
Create table PrelectInfo
(
	teaID int not null constraint FK_PrelectInfo_teaID
foreign key(teaID) references TeacherInfo(teaID),--教师编号
	claID varchar(10) constraint FK_PrelectInfo_claID
foreign key(claID) references ClassInfo(claID)
primary key(teaID,claID),			--班级编号
	Remark text default ''			--备注
)


------------------------------输入教师授课信息表数据-----------------------------
insert PrelectInfo values(10008,'S150','C语言,VB,HTML,SQL')
insert PrelectInfo values(10009,'S151','C语言,VB,HTML,SQL')
insert PrelectInfo values(10008,'S152','C语言,VB,HTML,SQL')
insert PrelectInfo values(10009,'S153','C语言,VB,HTML,SQL')
insert PrelectInfo values(10006,'S230','Java,Java Web,软件测试')
insert PrelectInfo values(10001,'S230','SQL数据库设计和实现')
insert PrelectInfo values(10010,'S230','.NET平台和C#,WinForms')
insert PrelectInfo values(10007,'S231','Java,Java Web,软件测试')
insert PrelectInfo values(10010,'S231','SQL数据库设计和实现')
insert PrelectInfo values(10006,'S231','.NET平台和C#,WinForms')
insert PrelectInfo values(10007,'S232','Java,Java Web,软件测试')
insert PrelectInfo values(10010,'S232','SQL数据库设计和实现')
insert PrelectInfo values(10006,'S232','.NET平台和C#,WinForms')
insert PrelectInfo values(10006,'Y210','OOAD,XML')
insert PrelectInfo values(10001,'Y210','Oracle')
insert PrelectInfo values(10010,'Y210','J2EE,Linux')
insert PrelectInfo values(10007,'Y210','ASP.NET')
insert PrelectInfo values(10008,'Y211','OOAD,XML')
insert PrelectInfo values(10007,'Y211','Oracle')
insert PrelectInfo values(10009,'Y211','J2EE,Linux')
insert PrelectInfo values(10006,'Y211','ASP.NET')
go



-----------------------------创建教室信息表-------------------------------
if exists(select * from sysobjects where name = 'ClassroomInfo')
	drop table ClassroomInfo
Create table ClassroomInfo
(
	crID varchar(10) primary key,	--教室编号
	crSeatNumber int not null,	--座位数
	Remark text default ''	--备注
)
go



--------------------------------输入教室信息表数据-----------------------------
insert ClassroomInfo values('R1',35,default)
insert ClassroomInfo values('R2',35,default)
insert ClassroomInfo values('R3',36,default)
insert ClassroomInfo values('R4',36,default)
insert ClassroomInfo values('L1',36,default)
insert ClassroomInfo values('L2',36,default)
insert ClassroomInfo values('L3',36,default)
insert ClassroomInfo values('L4',36,default)
insert ClassroomInfo values('C1',40,default)
go



----------------------------创建教室使用信息表----------------------------
if exists(select * from sysobjects where name = 'ClassroomUserInfo')
	drop table ClassroomUserInfo
Create table ClassroomUserInfo
(
	claID varchar(10) not null constraint FK_ClassroomUserInfo_claID
foreign key(claID) references ClassInfo(claID),	--班级编号
	crID varchar(10) not null constraint FK_ClassroomUserInfo_crID
foreign key(crID) references ClassroomInfo(crID),--教室编号
	cuDay int not null,			--每周使用的日期
	cuTime int not null,			--使用的时段
	cuRemark text default '',		--备注
	cuID int identity(1,1) primary key	--编号
)
go



-------------------------输入教室使用信息表数据-----------------------------------
insert ClassroomUserInfo values('S150','C1',1,1,default)
insert ClassroomUserInfo values('S150','C1',1,2,default)
insert ClassroomUserInfo values('S150','C1',3,1,default)
insert ClassroomUserInfo values('S150','C1',3,2,default)
insert ClassroomUserInfo values('S150','C1',5,1,default)
insert ClassroomUserInfo values('S150','C1',5,2,default)
insert ClassroomUserInfo values('S151','R4',1,1,default)
insert ClassroomUserInfo values('S151','L4',1,2,default)
insert ClassroomUserInfo values('S151','R4',3,1,default)
insert ClassroomUserInfo values('S151','L4',3,2,default)
insert ClassroomUserInfo values('S151','R4',5,1,default)
insert ClassroomUserInfo values('S151','L4',5,2,default)
insert ClassroomUserInfo values('S152','R3',1,3,default)
insert ClassroomUserInfo values('S152','L3',1,4,default)
insert ClassroomUserInfo values('S152','R3',3,3,default)
insert ClassroomUserInfo values('S152','L3',3,4,default)
insert ClassroomUserInfo values('S152','R3',5,3,default)
insert ClassroomUserInfo values('S152','L3',5,4,default)
insert ClassroomUserInfo values('S153','C1',6,5,default)
insert ClassroomUserInfo values('S153','C1',7,5,default)
insert ClassroomUserInfo values('S230','R3',2,1,default)
insert ClassroomUserInfo values('S230','L3',2,2,default)
insert ClassroomUserInfo values('S230','R3',4,1,default)
insert ClassroomUserInfo values('S230','L3',4,2,default)
insert ClassroomUserInfo values('S230','R3',6,1,default)
insert ClassroomUserInfo values('S230','L3',6,2,default)
insert ClassroomUserInfo values('S231','R3',2,3,default)
insert ClassroomUserInfo values('S231','L3',2,4,default)
insert ClassroomUserInfo values('S231','R3',4,3,default)
insert ClassroomUserInfo values('S231','L3',4,4,default)
insert ClassroomUserInfo values('S231','R3',6,3,default)
insert ClassroomUserInfo values('S231','L3',6,4,default)
insert ClassroomUserInfo values('S232','L3',2,3,default)
insert ClassroomUserInfo values('S232','R3',2,4,default)
insert ClassroomUserInfo values('S232','L3',4,3,default)
insert ClassroomUserInfo values('S232','R3',4,4,default)
insert ClassroomUserInfo values('S232','L3',6,3,default)
insert ClassroomUserInfo values('S232','R3',6,4,default)
insert ClassroomUserInfo values('Y210','R2',1,1,default)
insert ClassroomUserInfo values('Y210','L2',1,2,default)
insert ClassroomUserInfo values('Y210','R2',3,1,default)
insert ClassroomUserInfo values('Y210','L2',3,2,default)
insert ClassroomUserInfo values('Y210','R2',5,1,default)
insert ClassroomUserInfo values('Y210','L2',5,2,default)
insert ClassroomUserInfo values('Y211','R1',2,1,default)
insert ClassroomUserInfo values('Y211','L1',2,2,default)
insert ClassroomUserInfo values('Y211','R1',4,1,default)
insert ClassroomUserInfo values('Y211','L1',4,2,default)
insert ClassroomUserInfo values('Y211','R1',6,1,default)
insert ClassroomUserInfo values('Y211','L1',6,2,default)
go



----------------------创建学生基本信息表---------------------------
if exists(select * from sysobjects where name = 'StudentInfo')
	drop table StudentInfo
go
Create table StudentInfo
(
	stuName varchar(20) not null,			--姓名
	stuSex bit not null,				--性别，0：男  1：女
	stuOrigin varchar(20) default '',		--籍贯
	stuNation varchar(20) default '',		--民族
	stuTelephone varchar(20) default '' 
constraint Check_stuTelephone check(stuTelephone like
'[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
or stuTelephone like
'[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
or stuTelephone like
'[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
or stuTelephone like
'[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),--联系电话
	stuAddress text default '',			--地址
	stuPostcode varchar(10)
constraint Check_stuPostcode check(stuPostcode like
'[0-9][0-9][0-9][0-9][0-9][0-9]') default '000000',	--邮政编码
	stuGrade1 varchar(10) default '0000' constraint FK_StudentInfo_stuGrade1
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -