Consider the following ER model for a course administration.

Which statement is not correct?

a. When mapping the ER relationship type teaches between Session and Teacher to the relational model, a new relation needs to be introduced. The four cardinalities of this ER relationship type can be perfectly mapped to the relational model.

b. When mapping the ER relationship type organizes between Course and Session to the relational model, the primary key “cnb” of the Course relation will be included as a NOT NULL foreign key in the Session relation. The four cardinalities of this ER relationship type can be perfectly mapped to the relational model.

c. When mapping the ER relationship type enrollment between Session and Student to the relational model, a new relation needs to be introduced. The four cardinalities of this ER relationship type can be perfectly mapped to the relational model.

d. Both the ER and the relational model cannot enforce that a teacher can only teach sessions of courses for which he/she is qualified.

Transcribed Image Text:

0..n COURSE prerequisites cnb cname 0..n qualified 1..1 0..n organizes 0..n tname 0..n teaches 1..n tnb TEACHER location SESSION 0..n 0..n date result enrollment 0..n STUDENT sname snb