DBI202Xuất hiện trong 1 đề thi
Consider the relation: OrderDetail (orderNumber, productCode, productName, quantity, dateOrdered, salesDiscount). And FDs: $$\begin{aligned}(orderNumber, productCode) &\to quantity \\ orderNumber &\to dateOrdered \\ productCode &\to productName, salesDiscount\end{aligned}$$ And the key of OrderDetail is $\{orderNumber, productCode\}$. Which of the following is full dependency on the key?
Các lựa chọn
A$orderNumber, productCode \to quantity$
B$orderNumber \to dateOrdered$
C$productCode \to productName$
D$productCode \to productName, salesDiscount$