Neco 2019 Data Processing Question 32

Practice objective / multiple choice question 32 from the 2019 Neco Data Processing examination.

Neco 2019 Data Processing Objective / Multiple Choice Medium Difficulty
Question 32 NECO • 2019 • 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\).\n(a) List all candidate keys of \(R\).\n(b) State the highest normal form (1NF, 2NF, 3NF or BCNF) that \(R\) satisfies, giving a brief justification.

Answer Options

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

About This Question

This is Neco 2019 Data Processing Question 32. It is one of the objective questions from the 2019 Neco Data Processing examination.

Difficulty level: Medium .

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