Database Design Multiple Choice Let us apply class material, we are given the fo

Question

Database Design Multiple Choice

Let us apply class material, we are given the following table structure for table/relation STUDENT: STUDENT(Student_ID, Student_Name, Student_Addr, Student_Age, Student_GPA) Primary Key: Student_ID Secondary Key (Another Candidate Key): Student_Name and Student_Addr combined Which of the attributes in STUDENT is/are "non-prime" attributes? (a) Student_Name (b) Student_Addr (c) Student_ID (d) Student_GPA (e) Only (a) and (c) are non-prime attributes (f) Only (b) and (c) are non-prime attributes (g) Only (a) and (b) are non-prime attributes (h) None of (a) through (g) is the correct answer.

Explanation / Answer

The non -prime attributes are those attributes which do not figure in any candidate key. In our case Candidate keys are (Student_ID) and (Studen_Name , Student_Addr).
The atttribute which do not figure in any candidate ket are non prime so we have such attributes as Student_GPA and Student_Age.
So the correct option is (d) Student_GPA

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.