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:

Fungi

A kingdom of spore-producing organisms that include molds, yeast, and mushrooms, often playing a crucial role in the ecosystem.

Asthma

A chronic respiratory condition marked by episodes of wheezing, tightness in the chest, and difficulty breathing.

Diabetic Patients

Individuals who have been diagnosed with diabetes, a chronic health condition that affects how the body turns food into energy.

Treatment Regimens

Structured plans or strategies, including medications and therapies, designed to treat specific medical conditions.