Certificate in Business Data Analytics (CBDA) — Question 70

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

OrderId -

OrderDate -

ItemId -

ItemName -

Quantity -
ItemPrice

Answer options

• A. OrderDate - ItemPrice
• B. ItemName - ItemPrice
• C. OrderDate - ItemName
• D. ItemName - Quantity

Correct answer: B

Explanation

The correct answer is B, as ItemName and ItemPrice contain attributes that can lead to redundancy if not normalized. The other options either include attributes that do not contribute to redundancy or mix unrelated attributes.