
96 ◾ Cloud Database Development and Management
e value in the column Dean is the faculty ID. e relationship is a nonidentifying rela-
tionship. Since each faculty member is related to the dean, the column Dean cannot have a
null value.
Sometimes, you may encounter a many-to-many recursive relationship. For example, in a
course catalog, a course may have several prerequisite courses and many courses may require
the same course as a prerequisite. e relationship between the courses and the prerequisites
is an M:N recursive relationship. To represent the M:N recursive relationship, you have to
add an intersection relation in the relat ...