Two tables, namely, OrderItem and Item are depicted below in which all attributes mentioned
therein respectively, refer to column heading labels.
If the ItemName attribute is moved from the Item table to the OrderItem table, then will it violate
any normalization form? If yes, then which
of the following normalization forms will be violated?
A.
It will not violate any normal form (NF).
B.
1NF
C.
3NF
D.
2NF
Explanation:
It will violate 2NF, as ItemName is functionally dependent on ItemNumber, which is the primary key
of the Item table.
ItemNumber is the foreign key of the OrderItem table, and OrderNumber is the primary key of the
OrderItem table. According to 2NF, all the
non-key attributes in a table must be functionally dependent on the primary key column. Migrating
ItemName to the OrderItem table will
violate 2NF, since ItemName (a non-key attribute) is not functionally dependent on OrderNumber,
which is the primary key of the OrderItem
table.