Which of the following functional dependencies does NOT exist in the table ENROL

Question

Which of the following functional dependencies does NOT exist in the table ENROLLMENT?

ENROLLMENT

Observe the table ENROLLMENT:

ENROLLMENT

StudentID    StudentName    ClassID     ClassName

    111               Joe                    E1           English1

    222               Bob                   E1           English1

    333               Lisa                  H1          History1

Select one:

a. aStudentID -> ClassID

b. StudentName -> StudentID

c. StudentID -> StudentName

d. ClassID -> ClassName

Explanation / Answer

Answer: b. StudentName -> StudentID

StudentName -> StudentID functional dependencies does NOT exist in the table ENROLLMENT

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

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