A Database Consists of the Tables STUDENT (PK = Sno

question 18

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 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

---

Definitions:

Architectural Framing Devices

Structural elements used in architecture to highlight or isolate certain views or aspects of a building, enhancing its aesthetic or functional qualities.

Illusionism

An artistic technique used to create the optical illusion of three-dimensionality on a two-dimensional surface, often employed in frescoes and murals.

Septimius Severus

A Roman Emperor who ruled from AD 193 to 211, known for his military campaigns, administrative reforms, and the construction of notable buildings in Rome.

Triumphal Arch

In Roman architecture, a freestanding arch commemorating an important event, such as a military victory or the opening of a new road.