學(xué)生檔案管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)書(編輯修改稿)
2025-06-05 22:11 本頁面
【文章內(nèi)容簡介】 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)go、自定義約束class表約束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 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參照完整性u(píng)se 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表約束(實(shí)體完整性)use StudentRecordDBgoalter table Class add constraint pk_ClassID primary key(ClassID)gocourse表約束(實(shí)體完整性)use StudentRecordDBgoalter table Course add constraint pk_Cno primary key(Cno)godept表
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1