A 3 NF relation is split into 4 NF

M

Mr. Dubey • 52.30K Points
Coach

Q. A 3 NF relation is split into 4 NF

(A) by removing overlapping composite keys

(B) by splitting into relations which do not have more than one independent multi valued dependency

(C) removing multivalued dependency

(D) by putting dependent non-key attribute in a separate table

Correct : Option (B)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. A rate distortion function is a

Q. Activities that cannot be started until one or more of the other activities are completed, but immediately succeed them are called ……act

Q. can help us detect poor E- R design.

Q. Which of the following condition(s) is/are required for a deadlock to be possible?

Q. Which method of representation has two representations for ‘0’?

Q. During the development phase, the following testing approach is not adopted

Q. When is the user controls code is executed

Q. DS acquired a building for Rs. $15 l a k h \in J u \neq, 2016 \in a d d i t i o n \to \cos t o f l and b e \neq a t h t h e b u i l d \in g o f$ $15 lakh in June, 2016 in addition to cost of land beneath the building of$ 3 lakh. It was used for personal purposes

Q. Mouse is replacement of .

Q. A* Search Algorithm _________