Home › GATE CSE › computerscience › Database Management Systems › When you decompose a table into smaller tables, …
When you decompose a table into smaller tables, the two properties you must preserve are
Alossy compression and dependency tracking
Blossless-join and dependency preservation
Cschema constancy and foreign-key independence
Dredundancy minimisation and normal-form maximisation
Answer & Solution
Correct answer: B. lossless-join and dependency preservation
A safe decomposition must let you rejoin the pieces to reconstruct the original (lossless-join) AND let you enforce the original constraints from constraints on the pieces (dependency preservation). The Methodist notes list these as the two important decomposition properties.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment