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

Discussion

One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

  • A.True
  • B.False

Answer: B

Correct answer: True

This is the multivalue problem, and it is a first normal form violation: a cell must hold a single value. Several telephone numbers or skills packed into one cell cannot be searched, sorted or counted reliably, and the remedy is to move the repeating values into a separate table with one row for each.

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

Post your comment

Please log in or register to post a comment.