Home › GATE CSE › computerscience › Database Management Systems › If a combined Staff+Branch table stores the bran…
If a combined Staff+Branch table stores the branch address inside every staff row, what happens when the LAST employee of the Aberdeen branch resigns?
Athe Aberdeen branch address is erased with her row, a delete anomaly
Bthe Aberdeen address is automatically promoted to a new table
Cthe database refuses the deletion and asks for confirmation
Da phantom row keeps the branch alive in the index
Answer & Solution
Correct answer: A. the Aberdeen branch address is erased with her row, a delete anomaly
When two unrelated facts (the staff member, the branch address) share rows, removing one row accidentally removes the other. That is the delete anomaly. Real DBMSs do not promote facts on delete, nor refuse normal deletes; they cannot save you from a poor schema. The cure is to split the table.
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