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 statements is not true when having overall_gpa and gpa_in_major as attributes of the STUDENT table?

A) This will increase the time of retrieving the overall_gpa and gpa_in_major for students
B) This will increase the time of updates whenever a grade is changed
C) This will not change the normal form of the table STUDENT
D) This will avoid join operations when retrieving the gpa_in_major for a student