Home › GATE CSE › computerscience › Database Management Systems › Opening a brand-new branch with no staff yet, in…
Opening a brand-new branch with no staff yet, in a combined Staff+Branch table, causes
Ano problem; the branch row inserts cleanly
Ba delete anomaly when staff are later assigned
Can insert anomaly: branch cannot exist without staffNo
Da modification anomaly on the existing branches
Answer & Solution
Correct answer: C. an insert anomaly: branch cannot exist without staffNo
In a combined Staff+Branch table every row needs a staffNo; you cannot record the branch alone. The fact about the branch has no home until you also invent a staff member. That is the insert anomaly. Delete and modification anomalies show up on later operations, not on this insert.
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