Neco 2020 Data Processing Question 41

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

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

A relation R(A,B,C,D) has the functional dependencies A\rightarrow B, B\rightarrow C, AD\rightarrow C, and C\rightarrow D. Determine the highest normal form of R and, after decomposing R into BCNF, state how many relations result.

Answer Options

Correct Answer A. 2NF; 3
B. 1NF; 2
C. BCNF; 2
D. 3NF; 4
Correct Answer
A
Correct Option:
2NF; 3

About This Question

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

Difficulty level: Medium .

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