Neco 2017 Computer Studies Question 12

Practice objective / multiple choice question 12 from the 2017 Neco Computer Studies examination.

Neco 2017 Computer Studies Objective / Multiple Choice Hard Difficulty

Question 12 NECO • 2017 • COMPUTER_STUDIES • objective

Consider a relation R(E, P, S, D, M) with the functional dependencies: \(E \rightarrow S\), \(D \rightarrow M\), \((E,P) \rightarrow D\), \((E,P) \rightarrow S\).\n(a) Identify all candidate keys of R.\n(b) State whether R is in Third Normal Form (3NF). If it is not, decompose R into a set of relations that are in 3NF using the synthesis algorithm. List the resulting relations with their attributes.

A. R1(E,S); R2(D,M); R3(E,P)

Correct Answer B. R1(E,S); R2(D,M); R3(E,P,D)

C. R1(E,S,D); R2(D,M); R3(E,P)

D. R1(E,P); R2(D,M); R3(E,S)

Correct Answer

Correct Option:

R1(E,S); R2(D,M); R3(E,P,D)

This is Neco 2017 Computer Studies Question 12. It is one of the objective questions from the 2017 Neco Computer Studies examination.

Difficulty level: Hard .

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