What does converting a relation to 1NF accomplish (sample Q7)?
What does converting a relation to 1NF accomplish (sample Q7)?
Answer
It gives the relation a defined primary key and removes all repeating groups / multivalued attributes, leaving a single atomic value at every row/column intersection.
Removing all multivalued attributes is exactly the 1NF step — it does NOT by itself reach 2NF or 3NF.