Consider the following EER model.

Which statement is correct? 

a. When mapping the EER relationship type IS_ENROLLED between COURSE and STUDENT to the relational model, a new relation needs to be introduced. The relation is identified by GRADE as its primary key.

b. When mapping the EER relationship type INVOLVE between COURSE and ASSIGNMENT to the relational model, a new relation needs to be introduced. The 1..1 cardinalities of this relationship type cannot be enforced in the relational model.

c. When mapping the EER relationship type PARTICIPATE between GROUP ASSIGNMENT and STUDENT to the relational model, a new relation needs to be introduced. The four cardinalities of this EER relationship type can be perfectly mapped to the relational model.

d. The partial inheritance relationship between STUDENT and REPRESENTATIVE can be perfectly mapped to the relational model by the following two relations: STUDENT(StudentID, FirstName, LastName) and REPRESENTATIVE (S-StudentID, Email) whereby S-StudentID refers to StudentID in STUDENT.

Transcribed Image Text:

CourselD AssignmentNr GROUP ASSIGNMENT #GroupMembers PARTICIPATE (0...n) (0...n) (1...m) FirstName ASSIGNMENT Student D IS REP REPRESENTATIVE (1...1) STUDENT LastName (0...n) (0...n) Submission Date INDIVIDUAL ASSIGNMENT (0...n) Email (1...1) INVOLVE MAKE ASSIGNMENT (1...1) COURSE (0...m) IS ENROLLED CourselD CourseName Grade