A Database Consists of the Tables STUDENT (PK = Sno

Multiple Choice

A database consists of the tables STUDENT (PK = sno, sname, major) , COURSE (PK = cno, major, ) , OFFERINGS (PK = cno and ofno, ) , ENROLLMENT (sno, cno, ofno, grade) . All tables satisfy BCNF. Overall_gpa and gpa_in_major are computed for each student.
-Which of the following is not true of having sname as an attribute of ENROLLMENT?

A) This will facilitate retrieving grades of students in different offerings
B) This will result in update anomalies when the student's grades are updated
C) This will cause ENROLLMENT to violate 2NF
D) This will violate referential integrity in table ENROLLMENT