Home › GATE CSE › computerscience › Database Management Systems › A relation is in 2NF if it is in 1NF AND
A relation is in 2NF if it is in 1NF AND
Ano attribute is transitively dependent on the primary key
Bevery determinant is a candidate key
Cno attribute is multi-valued
Devery non-primary-key attribute is fully dependent on the PK
Answer & Solution
Correct answer: D. every non-primary-key attribute is fully dependent on the PK
2NF's defining condition is full functional dependency of non-key attributes on the primary key (no partial dependencies). 'No transitive dependency' is 3NF; 'every determinant is a candidate key' is BCNF; 'no multi-valued' is 1NF. Each normal form adds a distinct rule on top.
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