Home › GATE CSE › computerscience › Database Management Systems › Per the Methodist notes, BCNF violations typical…
Per the Methodist notes, BCNF violations typically arise in relations that
Ahave no foreign keys
Bstore only numeric attributes
Care already in 2NF and have a single candidate key
Dhave two or more composite candidate keys that overlap
Answer & Solution
Correct answer: D. have two or more composite candidate keys that overlap
The Methodist notes list this exact condition: 'Potential to violate BCNF may occur in a relation that contains two (or more) composite candidate keys; the candidate keys overlap (i.e. have at least one attribute in common).' Without overlap or with a single candidate key, 3NF and BCNF usually coincide.
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