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

Discussion

Changing cardinalities in a database is:

  • A.a common database design task.
  • B.a rare database design task, but does occur.
  • C.a database design task that never occurs.
  • D.is impossible to do, so a new database must be constructed and the data moved into it.

Answer: A

Correct answer: a common database design task.

Cardinalities change because requirements change - a one-to-many relationship becomes many-to-many when the business decides an item may belong to more than one category, or a maximum cardinality of one becomes optional. Such changes are routine, and they are handled by adding or removing an intersection table, or by altering a foreign key and its constraints, not by rebuilding the database.

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

Post your comment

Please log in or register to post a comment.