Home › MBA › Information Systems › Database Management › A designer organises the data so each fact is st…
A designer organises the data so each fact is stored only once and duplication disappears. That technique is:
ACompression
BNormalization
CEncryption
DReplication
Answer & Solution
Correct answer: B. Normalization
1. Duplication is the enemy here.
2. Each fact lives in one place.
3. It is normalization.
_Source: OpenStax Foundations of Information Systems, Chapter 3, Database Management Systems._
Related questions
In a table of employees, entering the employee ID gives you the name and address. That relA cloud provider copies data to several geographic locations so a hardware failure cannot Routine database work includes performance tuning, security enforcement and, above all, reSensitive records must be protected both while stored and while moving across the network.A manager asks what data integrity actually means. It refers to the accuracy and:A record still points at another record that has been deleted. That dangling record is calTransactions protect consistency and integrity through four properties: atomicity, consistAnother store keeps huge volumes of raw data in their original format until somebody needs