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

Discussion

The process of eliminating redundancy in a database is called

  • A.Replication
  • B.Virtualization
  • C.Normalization
  • D.Minimization

Answer: C

The process is called normalization.

Normalization organises a database into tables so that each fact is stored once, by decomposing relations according to their functional dependencies through the normal forms (1NF, 2NF, 3NF, BCNF). Removing redundancy also removes the insertion, update and deletion anomalies it causes.

Replication does the opposite, deliberately copying data to several sites for availability. Virtualization abstracts hardware resources and has nothing to do with table design. Minimization is not a database design term.

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

Post your comment

Please log in or register to post a comment.