Microsoft
98-364 · Question #31
Two tables, namely, OrderItem and Item are depicted below in which all attributes mentioned therein respectively, refer to column heading labels. If the ItemName attribute is moved from the Item…
The correct answer is D. 2NF. See the full explanation below for the reasoning.
Question
Two tables, namely, OrderItem and Item are depicted below 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?
Options
- AIt will not violate any normal form (NF).
- B1NF
- C3NF
- D2NF
How the community answered
(54 responses)- A9% (5)
- B4% (2)
- C15% (8)
- D72% (39)
Community Discussion
No community discussion yet for this question.