Machine-translated by Google. Questions are authored in English.
Top

Discussion

When mapping a multivalued attribute into a relation which of the following is true?

  • A.One relation is created.
  • B.Two relations are created.
  • C.Three relations are created.
  • D.Four relations are created.

Answer: B

Correct answer: Two relations are created.

A multivalued attribute cannot be held in a single-valued column, so it is placed in a relation of its own together with the key of the entity it belongs to. That gives two relations: the entity and the attribute’s, joined by the foreign key - and it is exactly what first normal form requires.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.