>
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 AR - 2024
GATE AR
Updated On:
Jul 9, 2024
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
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
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
An alternate key is ________.
CUET (UG) - 2024
Computer Science
Database Concepts
View Solution
A relation in a relational database is also known as:
CUET (UG) - 2024
Computer Science
Database Concepts
View Solution
A domain in a relational database refers to:
CUET (UG) - 2024
Computer Science
Database Concepts
View Solution
View More Questions
Questions Asked in GATE AR exam
Which of the following methods is/are used in traffic survey to measure the Running Speed and Journey Speed?
GATE AR - 2024
Traffic survey methods, Traffic flow Analysis
View Solution
For the beam shown below, ignoring the self-weight, the maximum hogging moment (in kN·m) generated for the loads indicated is _______ (rounded off to one decimal place).
GATE AR - 2024
High Rise and Long Span structures, gravity and lateral load resisting systems
View Solution
Let f: R→ R be a function. Note: R denotes the set of real numbers.
\(f(x) = \left\{ \begin{array}{ll} -x, & \text{if } x < -2 \\ ax^2+bx+c, & \text{if }\ x \in[-2,2]\\ x, & \text{if } x>2 \end{array} \right.\)
Which ONE of the following choices gives the values of a, b, c that make the function f continuous and differentiable ?
GATE AR - 2024
Differential Equations
View Solution
A ramp with a slope of 1 : 12 is required for wheelchair access. Intermediate landings of length 1.5 m each have to be provided after every 9 m running length. The running length of a straight ramp including landing, to negotiate a level difference of 900 mm vertical height, in m, is ( rounded off to two decimal places).
GATE AR - 2024
Urban renewal and conservation
View Solution
The 15 parts of the given figure are to be painted such that no two adjacent parts with shared boundaries (excluding corners) have the same color. The minimum number of colors required is
GATE AR - 2024
Image Based
View Solution
View More Questions