
46 ◾ Cloud Database Development and Management
key attributes are not null, the courses that do not have a prerequisite will not be present in the
intersection entity. For the meaning of the letter P, refer to Table 2.7.
Ternary relationship: ere are three entities involved in a ternary relationship. For example,
from the requirement analysis, one or more instances of the FACULTY entity are associated with
one or more instances of the CLASS entity and one or more instances of the CLASSROOM
entity. is relationship is a many-to-many-to-many ternary relationship shown in Figure 2.13.
In some cases, a ternary relationship can be treated as two ...