Two tables, namely, OrderItem and Item are depictedbelow 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.