Contents
Chapter 4 · DatabasePractice
← Return to textbook

CONCEPT PRACTICE

Transitive functional dependencies

1 related published questions. Take them one at a time.

Filter questions
Question sources

1 of 1 questions match.

ITPEC Practice
0/1 answered

Question 1 of 1

0/1 answered

2025 Autumn · Subject A · Q19

Original exam question · Select the image to enlarge
Read the question as text

Q19. When the functional dependencies shown below are satisfied, which of the following is the transitive functional dependency that holds? Here, “A→B” indicates that B is functionally dependent on A, and “A→{B, C}” indicates that “A→B” and “A→C ” both hold. [Functional dependencies] {OrderCode, ProductCode} → {CustomerOrderQuantity, OrderAmount} OrderCode → {OrderDate, CustomerCode, OrderManagerCode} ProductCode → {ProductName, SupplierCode, ProductSalePrice} SupplierCode → {SupplierName, SupplierAddress, SupplierManagerCode} CustomerCode → {CustomerName, CustomerAddress}

The original image above preserves the complete exam wording and layout.

Choose your answer
Choose an option to check your answer.
1 / 1Back to lesson →

Source: 2025A_FE-A_Questions.pdf, PDF page 11. ID: 2025A-A-Q019. Explanation written for this textbook.

Original question · Q19
Q19. When the functional dependencies shown below are satisfied, which of the following is the transitive functional dependency that holds? Here, “A→B” indicates that B is functionally dependent on A, and “A→{B, C}” indicates that “A→B” and “A→C ” both hold. [Functional dependencies] {OrderCode, ProductCode} → {CustomerOrderQuantity, OrderAmount} OrderCode → {OrderDate, CustomerCode, OrderManagerCode} ProductCode → {ProductName, SupplierCode, ProductSalePrice} SupplierCode → {SupplierName, SupplierAddress, SupplierManagerCode} CustomerCode → {CustomerName, CustomerAddress}

Scroll horizontally to read the image at full size.