Which attributes from the Order entity will need to be normalized to avoid redundancies?

Which attributes from the Order entity will need to be normalized to avoid redundancies?

. Orderld

. OrderDate

. Itemld

. ItemName

. Quantity

. ItemPrice
A . OrderDate ItemPrice
B . ItemName ItemPrice
C . OrderDate ItemName
D . Item Name Quantity

View Answer

Answer: B

Explanation:

The attributes ItemName and ItemPrice need to be normalized to avoid redundancies because they depend on the attribute ItemId, which is not part of the primary key of the Order entity. This is a case of partial dependency, which violates the second normal form (2NF) of database normalization. To achieve 2NF, the Order entity should be split into two entities: Order and Item, where Item contains the attributes ItemId, ItemName, and ItemPrice, and Order contains the attributes OrderId, OrderDate, ItemId, and Quantity. This way, the ItemName and ItemPrice are stored only once for each ItemId, and the Order entity references them through a foreign key12

Reference: 1: Balancing Data Integrity and Performance: Normalization vs … 2: Normalization Process in DBMS – GeeksforGeeks