Neco 2025 Data Processing Question 18

Practice objective / multiple choice question 18 from the 2025 Neco Data Processing examination.

Neco 2025 Data Processing Objective / Multiple Choice Medium Difficulty
Question 18 NECO • 2025 • DATA_PROCESSING • objective

Consider the relation R(StuID, CourseID, Instructor, Grade) with functional dependencies: StuID, CourseID \rightarrow Grade and Instructor \rightarrow CourseID. Determine whether R is in Boyce‑Codd Normal Form (BCNF). If it is not, give a lossless‑join decomposition of R into relations that are in BCNF.

Answer Options

Correct Answer A. R is not in BCNF. Decompose into R1(Instructor, CourseID) and R2(StuID, CourseID, Grade), both in BCNF.
B. R is not in BCNF. Decompose into R1(StuID, Instructor) and R2(CourseID, Grade), both in BCNF.
C. R is in BCNF. No decomposition is needed.
D. R is not in BCNF. Decompose into R1(Instructor, Grade) and R2(StuID, CourseID), both in BCNF.
Correct Answer
A
Correct Option:
R is not in BCNF. Decompose into R1(Instructor, CourseID) and R2(StuID, CourseID, Grade), both in BCNF.

About This Question

This is Neco 2025 Data Processing Question 18. It is one of the objective questions from the 2025 Neco Data Processing examination.

Difficulty level: Medium .

View More Neco 2025 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