A Database Consists of the Tables STUDENT (PK = Sno

question 76

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

---

Definitions:

Maintenance Activities

Tasks performed to keep equipment or systems operating efficiently, preventing breakdowns and extending their useful life.

Task Activities

Specific actions or work that needs to be accomplished as part of a broader project or role.

Norming Stage

Refers to the stage in group development where members establish norms, roles, and build relationships to facilitate group harmony and teamwork.

Critical Zone

An area of the Earth's surface where the interaction between the lithosphere, atmosphere, hydrosphere, and biosphere shapes our planet's environment.