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:

Limbic System

A complex system of nerves and networks in the brain, involved in instinct and mood control and the basic emotions (fear, pleasure, anger).

Pleasure

A subjective feeling of enjoyment or satisfaction derived from sensory or emotional experiences.

Semantic Memory

A type of long-term memory that involves the storage of general knowledge and facts about the world, independent of personal experience.

Telephone Numbers

Sequences of digits assigned to telephones or other devices for the purpose of establishing telephone calls to those devices.