Neco 2022 Data Processing Question 31

Practice objective / multiple choice question 31 from the 2022 Neco Data Processing examination.

Neco 2022 Data Processing Objective / Multiple Choice Medium Difficulty
Question 31 NECO • 2022 • DATA_PROCESSING • objective

Relation \(R(StudentID, CourseCode, Instructor, Grade)\) has functional dependencies: \(StudentID \rightarrow Instructor\), \(CourseCode \rightarrow Instructor\), and \((StudentID, CourseCode) \rightarrow Grade\).\n\n(a) Identify all candidate keys of \(R\).\n\n(b) State the highest normal form (up to BCNF) that \(R\) satisfies.\n\n(c) Decompose \(R\) into a set of relations that are in BCNF. List each resulting relation with its attributes.

Answer Options

A. Candidate key: (StudentID, CourseCode, Instructor). Highest normal form: 2NF. BCNF decomposition: R1(StudentID, CourseCode), R2(CourseCode, Instructor), R3(StudentID, Instructor, Grade).
B. Candidate key: (StudentID, Instructor). Highest normal form: 2NF. BCNF decomposition: R1(StudentID, Instructor), R2(CourseCode, Instructor), R3(StudentID, CourseCode, Grade).
C. Candidate key: (CourseCode, Grade). Highest normal form: 3NF. BCNF decomposition: R1(StudentID, Grade), R2(CourseCode, Instructor), R3(StudentID, CourseCode).
Correct Answer D. Candidate key: (StudentID, CourseCode). Highest normal form: 1NF. BCNF decomposition: R1(StudentID, Instructor), R2(CourseCode, Instructor), R3(StudentID, CourseCode, Grade).
Correct Answer
D
Correct Option:
Candidate key: (StudentID, CourseCode). Highest normal form: 1NF. BCNF decomposition: R1(StudentID, Instructor), R2(CourseCode, Instructor), R3(StudentID, CourseCode, Grade).

About This Question

This is Neco 2022 Data Processing Question 31. It is one of the objective questions from the 2022 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2022 Data Processing Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support