Question 9
NECO
•
2022
•
DATA_PROCESSING
•
objective
Consider a relational table STUDENT_ENROLLMENT with attributes: StudentID, Name, Dept, CourseCode, CourseName, Instructor. Each student can enrol in multiple courses, each course can have multiple students, and each course is taught by a single instructor.\n\n(a) List the functional dependencies that hold in this table.\n(b) Identify the candidate key(s).\n(c) State whether the table is in Second Normal Form (2NF). Provide a brief justification.
Answer Options
A.
FDs: StudentID → Name, Dept; Instructor → CourseName; (StudentID, CourseCode) → all attributes. Candidate key: StudentID. The table is in 2NF because all non‑key attributes depend on the whole key.
Correct Answer
B.
FDs: StudentID → Name, Dept; CourseCode → CourseName, Instructor; (StudentID, CourseCode) → all attributes. Candidate key: (StudentID, CourseCode). The table is not in 2NF because non‑key attributes depend on parts of the composite key.
C.
FDs: StudentID → Name, Dept, CourseCode; CourseCode → CourseName; (StudentID, CourseCode) → Instructor. Candidate key: StudentID. The table is in 2NF as there are no partial dependencies.
D.
FDs: StudentID → Name; CourseCode → CourseName, Instructor; Instructor → Dept. Candidate key: (StudentID, Instructor). The table is not in 2NF because Instructor depends only on CourseCode.
Correct Answer
B
Correct Option:
FDs: StudentID → Name, Dept; CourseCode → CourseName, Instructor; (StudentID, CourseCode) → all attributes. Candidate key: (StudentID, CourseCode). The table is not in 2NF because non‑key attributes depend on parts of the composite key.
About This Question
This is
Neco
2022
Data Processing
Question 9.
It is one of the
objective
questions from the
2022
Neco
Data Processing
examination.
Difficulty level:
Medium
.