學生檔案管理系統(tǒng)數(shù)據(jù)庫設計書-在線瀏覽
2025-06-26 22:11本頁面
【正文】 use StudentRecordDBgoalter table Reward add constraint pk_RewardID primary key(RewardID)goroom表約束use StudentRecordDBgoalter table Room add constraint pk_RoomID primary key(RoomID)gosc表約束use StudentRecordDBgoalter table SC add constraint pk_sc primary key(Sno,Cno)gostudent表約束use StudentRecordDBgoalter table Student add constraint pk_Sno primary key(Sno)goUsers表約束use StudentRecordDBgoalter table Users add constraint pk_Uid primary key(Uid)goweiji表約束use StudentRecordDBgoalter table WeiJi add constraint pk_weiji primary key(Sno)go參照完整性use StudentRecordDBgoALTER TABLE SC WITH NOCHECK ADD CONSTRAINT FK_student_sc FOREIGN KEY(Sno) REFERENCES Student(Sno) ON DELETE CASCADEALTER TABLE SC WITH NOCHECK ADD CONSTRAINT FK_course_sc FOREIGN KEY(Cno) REFERENCES Course(Cno) ON DELETE CASCADEALTER TABLE HuoJiang WITH NOCHECK ADD CONSTRAINT FK_student_huojiang FOREIGN KEY(Sno) REFERENCES Student(Sno) ON DELETE CASCADEALTER TABLE HuoJiang WITH NOCHECK ADD CONSTRAINT FK_reward_huojiang FOREIGN KEY(RewardID) REFERENCES Reward(RewardID) ON DELETE CASCADEALTER TABLE WeiJi WITH NOCHECK ADD CONSTRAINT FK_student_weiji FOREIGN KEY(Sno) REFERENCES Student(Sno) ON DELETE CASCADEALTER TABLE WeiJi WITH NOCHECK ADD CONSTRAINT FK_punish_weiji FOREIGN KEY(PunishID) REFERENCES Punish(PunishID) ON DELETE CASCADEuse StudentRecordDBgocreate index ind_ClassID on Class(ClassID)create index ind_Cno on Course(Cno)create index ind_DeptID on Dept(DeptID)create index ind_huojiang on HuoJiang(Sno,RewardID)create index ind_PunishID on Punish(PunishID)create index ind_RewardID on Reward(RewardID)create index ind_RoomID on Room(RoomID)create index ind_sc on SC(Sno,Cno)create index ind_Sno on Student(Sno)create index ind_Uid on Users(Uid)create index ind_weiji on WeiJi(Sno,PunishID)goclass表約束(實體完整性)use StudentRecordDBgoalter table Class add constraint pk_ClassID primary key(ClassID)gocourse表約束(實體完整性)use StudentRecordDBgoalter table Course add constraint pk_Cno primary key(Cno)godept表約束(實體完整性)use StudentRecordDBgoalter table Dept add constraint pk_DeptID primary key(DeptID)gohuojiang表約束(實體完整性)use StudentRecordDBgoalter table HuoJiang add constraint pk_huojiang primary key(Sno,RewardID)gopunish表約束(實體完整性)use StudentRecordDBgoalter table Punish add constraint pk_PunishID primary key(PunishID)goreward表約束(實體完整性)use StudentRecordDBgoalter table Reward add constraint pk_RewardID primary key(RewardID)goroom表約束(實體完整性)use StudentRecordDBgoalter table Room add constraint pk_RoomID primary key(RoomID)gosc表約束(實體完整性)use StudentRecordDBgoalter table SC add constraint pk_sc primary key(Sno,Cno)gostudent表約束(實體完整性)use StudentRecordDBgoalter table Student add constraint p
教學教案相關推薦
鄂ICP備17016276號-1