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
    Ravi Garg (anonymous)

    The correct answer is b)

    Ravi Garg 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
          Madhav Purohit (anonymous)

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

          Madhav Purohit answered
            0
            Ankit Mittal (anonymous)

            then y there is requirement of 4NF Madhav Purohit

            Ankit Mittal answered
              Add image to editor add image from link

              Question stats

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