GATE 2002: Relation R with an associated set of…

0

GATE 2002:
Relation R with an associated set of functional dependencies, F, is decomposed into
BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations
is
(a) Zero
(b) More than zero but less than that of an equivalent 3NF decomposition
(c) Proportional to the size of F
(d) Indetermine

Ravi Garg edited question
    0
    Madhav Purohit (anonymous)

    Ankit Mittal: I have read that relational schemas in BCNF form are free from redundancy and anamolies…

    Madhav Purohit answered
      0
      Hima Mehta (anonymous)

      a?

      Hima Mehta answered
        0
        Ankit Mittal (anonymous)

        i think redundancy exists due to MVD(multivalued dependency) Revise Gate – target GATE
        wats d answer ?

        Ankit Mittal answered
          0
          Ankit Mittal (anonymous)

          then y there is requirement of 4NF Madhav Purohit

          Ankit Mittal answered
            0
            Ankit Mittal (anonymous)

            i think 4NF is required to eliminate redundancy because of MVD

            Ankit Mittal answered
              Add image to editor add image from link

              Question stats

              • Active
              • Views1010 times
              • Answers10 answers
              • Followers1 follower
              Question and answer is powered by AnsPress