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

Question

Quizplus · Accepted Answer

The Answer of  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

A Database Consists of the Tables STUDENT (PK = Sno