James converts a table with this notation: INVOICES (INVOICE_NUM, INVOICE_DATE, (ITEM_ID, QUANTITY))
Into a table with this notation:
INVOICES (INVOICE_NUM, INVOICE_DATE, ITEM_ID, QUANTITY)
James has _____.
A) made the table design worse
B) converted a table in first normal form into a table in second normal form
C) converted an unnormalized relation into a table in first normal form
D) added a repeating group to a table

Question

Quizplus · Accepted Answer

James has converted an unnormalized relation (a table with nested relations, indicated by the parentheses around ITEM_ID and QUANTITY) into a table in first normal form by removing the nested relation and ensuring each row/column intersection contains a single value.

James Converts a Table with This Notation: INVOICES (INVOICE_NUM, INVOICE_DATE