數(shù)據(jù)庫高校教務(wù)管理系統(tǒng)(編輯修改稿)
2025-05-04 23:10 本頁面
【文章內(nèi)容簡介】 har](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, [是否補修] [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, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]（8）建立學(xué)籍代碼表格：CREATE TABLE [dbo].[學(xué)籍代碼表]( [學(xué)籍編號] [varchar](2
公司管理相關(guān)推薦
鄂ICP備17016276號-1