Which of the following contains a repeating group where the primary key is OrderNum?
A) Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) )
B) Orders (OrderNum, OrderDate, ItemNum, NumOrdered )
C) Orders (OrderNum, OrderDate)
D) Orders (OrderNum, ItemNum, NumOrdered )

Question

Quizplus · Accepted Answer

Choice A contains a repeating group of (ItemNum, NumOrdered) which can occur multiple times for a single OrderNum. This violates the database normalization rules and can lead to data redundancy and inconsistency. The best choice would be to separate this repeating group into a separate table with a foreign key referencing the Orders table. Therefore, Choice B, C, and D are not the best choices.

Which of the Following Contains a Repeating Group Where the Primary