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.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.