Home › GATE CSE › computerscience › Database Management Systems › A relation is in BCNF if and only if
A relation is in BCNF if and only if
Ano non-key attribute is transitively dependent on the primary key
Bevery determinant of a non-trivial FD is a candidate key (superkey)
Cthe primary key is a single non-composite attribute
Dthe relation has fewer than three candidate keys
Answer & Solution
Correct answer: B. every determinant of a non-trivial FD is a candidate key (superkey)
BCNF's defining condition: for every non-trivial FD A → B in the relation, A by itself must be a superkey (candidate key). 'No transitive dependency' is 3NF, weaker. Single-attribute key and number-of-candidate-keys are not BCNF requirements.
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