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

Question

Quizplus · Accepted Answer

Having sname as an attribute in ENROLLMENT will facilitate retrieving grades of students in different offerings. However, it will not necessarily result in update anomalies as long as the sname attribute is not used to identify records. It will not cause ENROLLMENT to violate 2NF because sname is functionally dependent on the PK of STUDENT and not on any other non-key attribute. It will not violate referential integrity in table ENROLLMENT as long as it is a foreign key referencing the PK of STUDENT.

A Database Consists of the Tables STUDENT (PK = Sno