CREATE TABLE [dbo].[Course] (
[Course_id] [int] IDENTITY (1, 1) NOT NULL ,
[Course_name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Credit] [smallint] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Student] (
[Student_id] [int] IDENTITY (1, 1) NOT NULL ,
[Student_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[Birth] [smalldatetime] NULL ,
[Nation] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[Class_id] [int] NOT NULL ,
[Entrance_date] [smalldatetime] NOT NULL ,
[home] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[politic] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ID] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[Job] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[specialty] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Student_JC] (
[Student_id] [int] NOT NULL ,
[Reward] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Punish] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Time] [smalldatetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Student_course] (
[Course_id] [int] NOT NULL ,
[Student_id] [int] NOT NULL ,
[Grade] [float] NOT NULL ,
[Credit] [smallint] NULL ,
[SC_semester] [smallint] NOT NULL ,
[School_year] [smallint] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[SyUser] (
[Use_id] [int] IDENTITY (1, 1) NOT NULL ,
[Use_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Use_role] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Password] [char] (6) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[class] (
[Class_id] [int] IDENTITY (1, 1) NOT NULL ,
[Class_name] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Grade] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SumStu] [int] NULL ,
[MaxNum] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Course] WITH NOCHECK ADD
CONSTRAINT [PK_Course] PRIMARY KEY CLUSTERED
(
[Course_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Student] WITH NOCHECK ADD
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
[Student_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Student_JC] WITH NOCHECK ADD
CONSTRAINT [PK_Student_JC] PRIMARY KEY CLUSTERED
(
[Student_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Student_course] WITH NOCHECK ADD
CONSTRAINT [PK_Student_course] PRIMARY KEY CLUSTERED
(
[Course_id],
[Student_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SyUser] WITH NOCHECK ADD
CONSTRAINT [PK_SyUser] PRIMARY KEY CLUSTERED
(
[Use_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[class] WITH NOCHECK ADD
CONSTRAINT [DF_class_SumStu] DEFAULT (0) FOR [SumStu],
CONSTRAINT [DF_class_MaxNum] DEFAULT (30) FOR [MaxNum],
CONSTRAINT [PK_class] PRIMARY KEY CLUSTERED
(
[Class_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Student] ADD
CONSTRAINT [FK_Student_class] FOREIGN KEY
(
[Class_id]
) REFERENCES [dbo].[class] (
[Class_id]
)
GO
ALTER TABLE [dbo].[Student_JC] ADD
CONSTRAINT [FK_Student_JC_Student] FOREIGN KEY
(
[Student_id]
) REFERENCES [dbo].[Student] (
[Student_id]
)
GO
ALTER TABLE [dbo].[Student_course] ADD
CONSTRAINT [FK_Student_course_Course] FOREIGN KEY
(
[Course_id]
) REFERENCES [dbo].[Course] (
[Course_id]
),
CONSTRAINT [FK_Student_course_Student] FOREIGN KEY
(
[Course_id]
) REFERENCES [dbo].[Student] (
[Student_id]
)
GO
没有合适的资源?快使用搜索试试~ 我知道了~
学生信息管理系统(源码)
共55个文件
resources:14个
cs:13个
resx:12个
需积分: 0 7 下载量 118 浏览量
2008-11-19
15:54:12
上传
评论 1
收藏 456KB RAR 举报
温馨提示
学生信息管理系统(源码) 学生信息管理系统(源码)
资源推荐
资源详情
资源评论
收起资源包目录
.rar (55个子文件)
第二章 学生信息管理系统
代码
StudentManagementsystem.sln 955B
StudentManagementsystem
QueryStuGrade.cs 8KB
QueryStu.cs 8KB
Login.cs 7KB
bin
Debug
StudentManagementsystem.pdb 132KB
NewStu.cs 17KB
NewClass.resx 13KB
obj
Debug
StudentManagementsystem.QuyChgStuInfo.resources 3KB
StudentManagementsystem.SysHelp.resources 5KB
StudentManagementsystem.InputGrade.resources 13KB
StudentManagementsystem.projdata 60KB
StudentManagementsystem.QueryStuGrade.resources 9KB
StudentManagementsystem.ChgPsw.resources 8KB
StudentManagementsystem.MainFrm.resources 11KB
StudentManagementsystem.UpdateRole.resources 9KB
StudentManagementsystem.Login.resources 8KB
StudentManagementsystem.pdb 132KB
StudentManagementsystem.Stu_JC.resources 8KB
temp
TempPE
QryStu.cs.dll 13KB
PrintStuSys.cs.dll 5KB
StudentManagementsystem.AddCourse.resources 8KB
StudentManagementsystem.NewClass.resources 9KB
StudentManagementsystem.QueryStu.resources 9KB
StudentManagementsystem.NewStu.resources 19KB
StudentManagementsystem.UpdateStu.resources 10KB
SysHelp.resx 8KB
UpdateStu.resx 14KB
MainFrm.cs 10KB
StudentManagementSystem.csproj 11KB
AddCourse.resx 11KB
UpdateRole.cs 7KB
InputGrade.resx 17KB
NewClass.cs 7KB
SysHelp.cs 3KB
UpdateStu.cs 12KB
StudentManagementsystem.csproj.user 2KB
Login.resx 12KB
InputGrade.cs 12KB
NewStu.resx 23KB
UpdateRole.resx 13KB
MainFrm.resx 13KB
App.ico 1KB
AddCourse.cs 7KB
QueryStu.resx 13KB
ChgPsw.cs 6KB
AssemblyInfo.cs 2KB
ChgPsw.resx 12KB
QueryStuGrade.resx 13KB
StudentManagementsystem.suo 16KB
StudentManagementsystem.suo 13KB
代码.rar 202KB
建库脚本
StuMagSys 1.14MB
StuMagSys_Data.MDF 1.13MB
StuMagSys.sql 7KB
StuMagSys_Log.LDF 1024KB
共 55 条
- 1
资源评论
market_market
- 粉丝: 7
- 资源: 60
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- beyondCompare3安装文件带序列号beyondCompare3安装文件带序列号
- BIIIIIIIIIIIIII
- docker111安装步骤
- STM32器件包(支持新版蓝桥杯嵌入式开发板) Keil.STM32G4xx-DFP.1.5.0
- PACSdicom 测试图像
- Keil.STM32F1xx-DFP.2.2.0.pack
- sumo交通建模-过程性成果(完成十字交通路口车辆流向配置).zip
- 国花花卉数据集 JPG(9类 4K+ 图片)
- esp32s3 n8r16 micropython固件自编译支持MicroPython v1.22.0
- 三菱PLC例程源码二用一备恒压供水程序及图纸
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功