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
    Hima Mehta (anonymous)

    dunt say 4nf 5nf ka full implementation he sylabbus me please say NO

    Hima Mehta 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
              • Views913 times
              • Answers10 answers
              • Followers1 follower
              Question and answer is powered by AnsPress