Neco 2020 Data Processing Question 39

Practice objective / multiple choice question 39 from the 2020 Neco Data Processing examination.

Neco 2020 Data Processing Objective / Multiple Choice Medium Difficulty
Question 39 NECO • 2020 • DATA_PROCESSING • objective

Consider a relation R(A,B,C,D) with functional dependencies: \\(A \rightarrow B\\), \\(BC \rightarrow D\\), and \\(D \rightarrow A\\).\n(a) List all candidate keys of R.\n(b) State the highest normal form (up to BCNF) that R satisfies, with justification.

Answer Options

A. Candidate keys: A, B, C. Highest normal form: BCNF.
B. Candidate keys: ABC, ABD, ACD. Highest normal form: 1NF.
C. Candidate keys: AB, AD, BD. Highest normal form: 2NF.
Correct Answer D. Candidate keys: AC, BC, CD. Highest normal form: 3NF.
Correct Answer
D
Correct Option:
Candidate keys: AC, BC, CD. Highest normal form: 3NF.

About This Question

This is Neco 2020 Data Processing Question 39. It is one of the objective questions from the 2020 Neco Data Processing examination.

Difficulty level: Medium .

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