數(shù)據(jù)庫高校教務(wù)管理系統(tǒng)-展示頁
2025-04-16 23:10本頁面
【正文】 lder環(huán)境）SQL Server 2008創(chuàng)建表格代碼（1）建立班級信息表格：CREATE TABLE [dbo].[班級信息]( [班級編號] [varchar](14) NOT NULL, [年級] [varchar](4) NULL, [班級名稱] [varchar](30) NULL, [班級簡稱] [varchar](16) NULL, [人數(shù)] [numeric](3, 0) NULL, [班主任] [varchar](8) NULL, CONSTRAINT [PK_班級信息] PRIMARY KEY CLUSTERED ( [班級編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（2）建立成績表格：CREATE TABLE [dbo].[成績表]( [編號] [int] IDENTITY(1,1) NOT NULL, [學(xué)號] [varchar](14) NOT NULL, [課程編號] [int] NOT NULL, [成績] [int] NOT NULL, [考試次數(shù)] [int] NULL, [是否補(bǔ)修] [varchar](2) NULL, [是否重考] [varchar](2) NULL, [是否已確定成績] [varchar](2) NULL, CONSTRAINT [PK_成績表] PRIMARY KEY CLUSTERED ( [編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（3）建立籍貫代碼表格：CREATE TABLE [dbo].[籍貫代碼表]( [籍貫編號] [varchar](2) NOT NULL, [籍貫] [varchar](18) NULL, CONSTRAINT [PK_籍貫代碼表] PRIMARY KEY CLUSTERED ( [籍貫編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（4）建立課程表格：CREATE TABLE [dbo].[課程表]( [編號] [int] IDENTITY(1,1) NOT NULL, [課序號] [varchar](14) NOT NULL, [課程編號] [int] NOT NULL, [上課時間天] [int] NOT NULL, [上課時間節(jié)] [int] NOT NULL, [上課地點] [varchar](20) NOT NULL, CONSTRAINT [PK_課程表] PRIMARY KEY CLUSTERED ( [編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（5）建立課程信息表格：CREATE TABLE [dbo].[課程信息]( [課程編號] [int] NOT NULL, [課程名稱] [char](40) NOT NULL, [課程簡稱] [char](40) NOT NULL, [拼音碼] [char](6) NULL, [本學(xué)期課程] [char](2) NOT NULL, [教師] [char](10) NULL, [開課系別] [char](30) NULL, [學(xué)分] [int] NULL, CONSTRAINT [PK_課程信息] PRIMARY KEY CLUSTERED ( [課程編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（6）建立民族代碼表格：CREATE TABLE [dbo].[民族代碼表]( [民族編號] [varchar](2) NOT NULL, [民族] [varchar](18) NULL, CONSTRAINT [PK_民族代碼表] PRIMARY KEY CLUSTERED ( [民族編號] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（7）建立選課表格：CREATE TABLE [dbo].[選課表]( [編號] [int] IDENTITY(1,1) NOT NULL, [學(xué)號] [varchar](14) NOT NULL, [課序號] [varchar](14) NOT NULL, CONSTRAINT [PK_選課表] PRIMARY KEY CLUSTERED ( [編號] ASC)WITH (PAD_INDEX = OFF, ST
公司管理相關(guān)推薦
鄂ICP備17016276號-1