>
Exams
>
Data Science and Artificial Intelligence
>
Database Concepts
>
given the relational schema r u v w x y z and the
Question:
Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies :
{U → V,U → W, WX → Y,WX → Z,V → X}
Which of the following functional dependencies can be derived from the above set ?
GATE DA - 2024
GATE DA
Updated On:
Feb 3, 2026
VW → YZ
WX → YZ
VW → U
VW → Y
Hide Solution
Verified By Collegedunia
The Correct Option is
A,
B,
D
Solution and Explanation
The correct option is (A) : VW → YZ, (B) : WX → YZ and (D) : VW → Y.
Download Solution in PDF
Was this answer helpful?
0
0
Top Questions on Database Concepts
Given the relation:
\[ R = \{A, B, C, D, E, F, G\} \]
With the following functional dependencies (FDs):
\[ A \rightarrow BCEF, \quad E \rightarrow DG, \quad BC \rightarrow A \]
Which of the following statements is correct?
GATE DA - 2025
Data Science and Artificial Intelligence
Database Concepts
View Solution
Consider the following database schema:
\[ \text{Person (aadhar CHAR(12) PK, name VARCHAR(32))} \] \[ \text{Customer (name VARCHAR(32), email VARCHAR(32) PK, phone CHAR, aadhar CHAR(12) FK(aadhar))} \]
Which of the following statements is/are correct?
GATE DA - 2025
Data Science and Artificial Intelligence
Database Concepts
View Solution
The Debentures that are payable on the expiry of the specific period either in lumpsum or in instalments during life time of the company are called:
CUET (UG) - 2025
Accountancy
Database Concepts
View Solution
Identify the other name by which Liquid ratio is known:
CUET (UG) - 2025
Accountancy
Database Concepts
View Solution
Match List I with List II:
Choose the correct answer from the options given below:
CUET (UG) - 2025
Accountancy
Database Concepts
View Solution
View More Questions
Questions Asked in GATE DA exam
Which of the following statements is/are correct?
GATE DA - 2025
Linear Algebra
View Solution
Choose the most appropriate word to complete the analogy:
Courage : Bravery :: Yearning :
GATE DA - 2025
Analogies
View Solution
When does the worst case of binary search occur?
GATE DA - 2025
Algorithm
View Solution
Suppose that insertion sort is applied to the array \([1,2,3,5,7,9,11,x,15,13]\) and it takes exactly 2 swaps to sort the array. Select all possible values of \( x \).
GATE DA - 2025
Algorithm
View Solution
Given the lists:
\[ A = [1,2,3], \quad B = [4,5,6] \]
Which of the following statements will result in
\[ A = [1,2,3,4,5,6]? \]
GATE DA - 2025
Programming in Python
View Solution
View More Questions