學(xué)生信息管理數(shù)據(jù)庫設(shè)計報告(更新版)
【正文】 __0425A276] PRIMARY KEY CLUSTERED ( [Sno], [Cno] ) ON [PRIMARY] GO ALTER TABLE [dbo].[STUDENT] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [Sno] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TEACHER] WITH NOCHECK ADD CONSTRAINT [PK_TEACHER] PRIMARY KEY CLUSTERED ( [Tno] ) ON [PRIMARY] GO ALTER TABLE [dbo].[COURSE] WITH NOCHECK ADD CONSTRAINT [UQ__COURSE__023D5A04] UNIQUE NONCLUSTERED ( [Cno] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DEPART] WITH NOCHECK ADD UNIQUE NONCLUSTERED ( [Dno] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SC] WITH NOCHECK ADD CONSTRAINT [CK_SC] CHECK ([GRADE] = 100) GO ALTER TABLE [dbo].[STUDENT] WITH NOCHECK ADD UNIQUE NONCLUSTERED ( [Sno] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TEACHER] WITH NOCHECK ADD UNIQUE NONCLUSTERED ( [Tno] ) ON [PRIMARY] GO CREATE UNIQUE INDEX [COURSE_Index_1] ON [dbo].[COURSE]([Cname]) ON [PRIMARY] GO 8）完整性約束 ALTER TABLE [dbo].[SC] ADD CONSTRAINT [FK__SC__Cno__060DEAE8] FOREIGN KEY ( [Cno] ) REFERENCES [dbo].[COURSE] ( [Cno] ), CONSTRAINT [FK__SC__Sno__0519C6AF] FOREIGN KEY ( [Sno] ) REFERENCES [dbo].[STUDENT] ( [Sno] ) ON DELETE CASCADE GO ALTER TABLE [dbo].[STUDENT] ADD FOREIGN KEY ( [Sdno] ) REFERENCES [dbo].[DEPART] ( [Dno] ) GO ALTER TABLE [dbo].[TC] ADD CONSTRAINT [FK__TC__Cno__09DE7BCC] FOREIGN KEY ( [Cno] ) REFERENCES [dbo].[COURSE] ( [Cno] ), CONSTRAINT [FK__TC__Tno__08EA5793] FOREIGN KEY ( [Tno] ) REFERENCES [dbo].[TEACHER] ( [Tno] ) GO ALTER TABLE [dbo].[TEACHER] ADD FOREIGN KEY ( [Dno] ) REFERENCES [dbo].[DEPART] ( [Dno] ) GO 7 VB 部分 登陸界面 登陸后界面 學(xué)生基本信息 修改學(xué)生信息 學(xué)生課程信息查詢 課程信息 、 課程查詢 教師信息查詢 教師信息增添
公司管理相關(guān)推薦
鄂ICP備17016276號-1