Neco 2017 Data Processing Question 2

Practice objective / multiple choice question 2 from the 2017 Neco Data Processing examination.

Neco 2017 Data Processing Objective / Multiple Choice Medium Difficulty
Question 2 NECO • 2017 • DATA_PROCESSING • objective

Consider a relation R(A,B,C,D) with the functional dependencies: A \rightarrow B, BC \rightarrow D, and D \rightarrow A. Determine (i) a candidate key for R, and (ii) the highest normal form (up to BCNF) that R satisfies.

Answer Options

Correct Answer A. Candidate key: AC; Highest normal form: 1NF
B. Candidate key: AB; Highest normal form: 3NF
C. Candidate key: CD; Highest normal form: BCNF
D. Candidate key: AD; Highest normal form: 2NF
Correct Answer
A
Correct Option:
Candidate key: AC; Highest normal form: 1NF

About This Question

This is Neco 2017 Data Processing Question 2. It is one of the objective questions from the 2017 Neco Data Processing examination.

Difficulty level: Medium .

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