Database Reference
In-Depth Information
STUDENT
STUDENT_CLASS
COURSE
COURSE_PREREQUISITE
StudentID
P
StudentID (FK)
ClassID (FK)
CourseID
CourseID (FK)
FirstName
Prerequisite (FK)
P
CourseName
LastName
FacultyID (FK)
Grade
Credit
FACULT Y
CLASS
FACULT Y_CLASS
CLASS_CLASSROOM
ClassID (FK)
BuildingID (FK)
P
ClassID
FacultyID
FacultyID (FK)
TimeID (FK)
ClassID (FK)
FirstName
P
CourseID (FK)
SemesterID (FK)
ClassroomID (FK)
LastName
P
DayID (FK)
CLASSROOM
TIMEBLOCK
DAYS
SEMESTER
BUILDING
ClassroomID
DayID
TimeID
SemesterID
BuildingID
BuildingID (FK)
P
We ekDay
TimeBlock
Semester
BuildingName
Capacity
Figure 4.11
Class_Registration data model.
2. Click
New Query
to open the query tool. To create a foreign key constraint on the table
STUDENT, enter the following SQL statement. hen click
Run
as shown in Figure
4.12.
Figure 4.12
Create foreign key on STUDENT table.
