SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Depart]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Depart](
[departID] [int] IDENTITY(1,1) NOT NULL,
[departName] [varchar](100) NULL,
CONSTRAINT [PK_Depart] PRIMARY KEY CLUSTERED
(
[departID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Users](
[adminName] [varchar](20) NOT NULL,
[adminPwd] [varchar](20) NULL,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[adminName] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Teacher]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Teacher](
[teaID] [varchar](20) NOT NULL,
[teaPwd] [varchar](20) NULL,
[teaName] [varchar](50) NOT NULL,
[teaDepart] [int] NULL,
CONSTRAINT [PK_Teacher] PRIMARY KEY CLUSTERED
(
[teaID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Student]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Student](
[stuID] [varchar](20) NOT NULL,
[stuPwd] [varchar](20) NULL,
[stuName] [varchar](10) NOT NULL,
[stuDepart] [int] NULL,
[stuGrade] [int] NULL,
[stuClass] [int] NULL,
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
[stuID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Cource]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Cource](
[courceID] [varchar](20) NOT NULL,
[teaID] [varchar](20) NOT NULL,
[courceName] [varchar](100) NOT NULL,
[courceTime] [varchar](20) NULL,
[courceAddress] [varchar](50) NULL,
[courceInfo] [text] NULL,
CONSTRAINT [PK_Cource_1] PRIMARY KEY CLUSTERED
(
[courceID] ASC,
[teaID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Elect]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Elect](
[stuID] [varchar](20) NOT NULL,
[courceID] [varchar](20) NOT NULL,
[teaID] [varchar](20) NOT NULL,
[Score] [int] NULL,
CONSTRAINT [PK_Elect] PRIMARY KEY CLUSTERED
(
[stuID] ASC,
[courceID] ASC,
[teaID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Teacher_Depart]') AND parent_object_id = OBJECT_ID(N'[dbo].[Teacher]'))
ALTER TABLE [dbo].[Teacher] WITH CHECK ADD CONSTRAINT [FK_Teacher_Depart] FOREIGN KEY([teaDepart])
REFERENCES [dbo].[Depart] ([departID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Student_Depart]') AND parent_object_id = OBJECT_ID(N'[dbo].[Student]'))
ALTER TABLE [dbo].[Student] WITH CHECK ADD CONSTRAINT [FK_Student_Depart] FOREIGN KEY([stuDepart])
REFERENCES [dbo].[Depart] ([departID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Cource_Teacher]') AND parent_object_id = OBJECT_ID(N'[dbo].[Cource]'))
ALTER TABLE [dbo].[Cource] WITH CHECK ADD CONSTRAINT [FK_Cource_Teacher] FOREIGN KEY([teaID])
REFERENCES [dbo].[Teacher] ([teaID])
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Elect_Cource]') AND parent_object_id = OBJECT_ID(N'[dbo].[Elect]'))
ALTER TABLE [dbo].[Elect] WITH CHECK ADD CONSTRAINT [FK_Elect_Co�
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
MyElectCourse.rar (61个子文件)
MyElectCourse
adminCourse.aspx.cs 5KB
studentElect.aspx 8KB
adminTeacherAdd.aspx.cs 2KB
App_Code
ClassDiagram.cd.exclude 436B
teacherSubmitScore.aspx.cs.exclude 6KB
adminCourse.aspx.cs.exclude 5KB
ClassDiagram2.cd.exclude 1B
DB
ElectClass.bak 1.64MB
ElectClass.sql 9KB
ElectClass.sql.bak 7KB
Desktop_1.ini 9B
adminCourse.aspx 2KB
Main.aspx 2KB
courseDetail.aspx 2KB
teacherSubmitScore.aspx.cs 6KB
teacherQueryElect.aspx.cs 2KB
adminTeacherDetails.aspx 3KB
Controls
left.ascx 2KB
left.ascx.cs 534B
Desktop_1.ini 9B
adminTeacherDetails.aspx.cs 6KB
courseDetail.aspx.cs 2KB
adminStudentAdd.aspx 3KB
Web.Config 8KB
adminStudentScore.aspx.cs 8KB
App_Data
aspnetdb_log.ldf 504KB
ASPNETDB.MDF 10MB
Desktop_1.ini 9B
teacherSubmitScore.aspx 3KB
adminTeacherAdd.aspx 2KB
adminStudentDetails.aspx.cs 8KB
Desktop_1.ini 9B
adminStudentScore.aspx 3KB
ModifyPwd.aspx.cs 3KB
Login.aspx.cs 3KB
teacherQueryElect.aspx 3KB
ModifyPwd.aspx 3KB
Images
RESET.GIF 1KB
CONFIRM.GIF 505B
Close.GIF 1KB
SubmitScore.GIF 1KB
movetoolright1.gif 171B
RETURN.GIF 505B
online_right.gif 923B
MM.GIF 322B
QUERY.GIF 1KB
online_left.gif 1KB
Login.GIF 1KB
movetool1.gif 922B
Desktop_1.ini 9B
online_middle.gif 670B
NAME.GIF 988B
FangKuai.gif 2KB
ADD.GIF 1KB
adminStudentDetails.aspx 5KB
adminStudentAdd.aspx.cs 3KB
Login.aspx 4KB
adminCourseDetails.aspx 10KB
adminCourseDetails.aspx.cs 8KB
Main.aspx.cs 405B
studentElect.aspx.cs 4KB
共 61 条
- 1
资源评论
- yuanfang20142013-05-30没仔细研究,但看起来还不错啦
夜飞鼠
- 粉丝: 637
- 资源: 43
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功