ExamGecko
Home Home / IIBA / CBDA
Question list
Search
Search

List of questions

Search

Related questions











Question 59 - CBDA discussion

Report
Export

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

. Orderld

. OrderDate

. Itemld

. ItemName

. Quantity

. ItemPrice

A.
OrderDate ItemPrice
Answers
A.
OrderDate ItemPrice
B.
ItemName ItemPrice
Answers
B.
ItemName ItemPrice
C.
OrderDate ItemName
Answers
C.
OrderDate ItemName
D.
Item Name Quantity
Answers
D.
Item Name Quantity
Suggested 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

asked 18/09/2024
taheireem shaikh
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first