Which attributes from the Order entity will need to be normalized to avoid redundancies? . Orderld . OrderDate . Itemld . ItemName . Quantity…

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

them through a foreign key12 Reference: 1: Balancing

Data Integrity and Performance: Normalization vs … 2: Normalization Process in DBMS -

GeeksforGeeks