Database Reference
In-Depth Information
ALTER TABLE STUDENT ADD
CONSTRAINT Student_FacultyID_fk
FOREIGN KEY (FacultyID)
REFERENCES FACULTY (FacultyID)
3. Similarly, you can enter the following SQL statements to create the rest of the foreign
key constraints. hen, highlight each SQL Statement and click
Run
.
ALTER TABLE STUDENT_CLASS ADD CONSTRAINT SC_StudentID_fk
FOREIGN KEY (StudentID) REFERENCES STUDENT (StudentID)
ALTER TABLE STUDENT_CLASS ADD CONSTRAINT SC_ClassID_fk
FOREIGN KEY (ClassID) REFERENCES CLASS (ClassID)
ALTER TABLE COURSE_PREREQUISITE ADD CONSTRAINT CP_CourseID_fk
FOREIGN KEY (CourseID) REFERENCES COURSE (CourseID)
ALTER TABLE COURSE_PREREQUISITE
ADD CONSTRAINT CP_Prerequisite_fk
FOREIGN KEY (Prerequisite) REFERENCES COURSE (CourseID)
ALTER TABLE FACULTY_CLASS ADD CONSTRAINT FC_FacultyID_fk
FOREIGN KEY (FacultyID) REFERENCES FACULTY (FacultyID)
ALTER TABLE FACULTY_CLASS ADD CONSTRAINT FC_ClassID_fk
FOREIGN KEY (ClassID) REFERENCES CLASS (ClassID)
ALTER TABLE CLASS ADD CONSTRAINT CLASS_CourseID_fk
FOREIGN KEY (CourseID) REFERENCES COURSE (CourseID)
ALTER TABLE CLASS ADD CONSTRAINT CLASS_DayID_fk
FOREIGN KEY (DayID) REFERENCES DAYS (DayID)
ALTER TABLE CLASS ADD CONSTRAINT CLASS_TimeID_fk
FOREIGN KEY (TimeID) REFERENCES TIMEBLOCK (TimeID)
ALTER TABLE CLASS ADD CONSTRAINT CLASS_SemesterID_fk
FOREIGN KEY (SemesterID) REFERENCES SEMESTER (SemesterID)
ALTER TABLE CLASSROOM ADD CONSTRAINT CLASS_BuildingID_fk
FOREIGN KEY (BuildingID) REFERENCES BUILDING (BuildingID)
ALTER TABLE CLASS_CLASSROOM ADD CONSTRAINT CC_ClassID_fk
FOREIGN KEY (ClassID) REFERENCES CLASS (ClassID)
ALTER TABLE CLASS_CLASSROOM ADD CONSTRAINT CC_ClassroomID_fk
FOREIGN KEY (ClassroomID, BuildingID)
REFERENCES CLASSROOM (ClassroomID, BuildingID))
4. To view a newly created constraint, click
Design
on the left-hand side of the screen.
Select the table
CLASS_CLASSROOM
and then click
Edit
. Click
Indexes And
Keys
, and you should be able to see the foreign keys as shown in Figure 4.13.