Database Reference
In-Depth Information
Figure 3.15
Table design of CLASS.
Figure 3.16
Table design of STUDENT_CLASS.
STUDENT_CLASS are consistent. Make sure that the same is true for the StudentID col-
umn in both the STUDENT_CLASS and STUDENT tables.
4.
Categorization relationship
: In Chapter 2, we examined the categorization relationship among
the entities of FACULTY, PROFESSOR, and INSTRUCTOR as shown in Figure 3.17.
he entities involved in the above categorization relationship can be represented by the
following relations:
FACULTY(
FacultyID
, FirstName, LastName, JobCode)
PROFESSOR(
FacultyID
, Rank, OicePhone)
INSTRUCTOR(
FacultyID
, Position, HomePhone)
