First Normal Form requires that
Aevery relation has at most three attributes
Bno attribute can be NULL anywhere in the table
Cevery row-column cell holds exactly one atomic value
Dthe primary key is a single attribute, never composite
Answer & Solution
Correct answer: C. every row-column cell holds exactly one atomic value
1NF forbids multi-valued cells, nested tables and lists inside a single cell. NULL is allowed in 1NF, primary keys can be composite, and the attribute count is unbounded. The atomic-single-value-per-cell rule is the only 1NF constraint that matters in standard textbooks.
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