ExamLookup
Menu mobile
Home
Current Affairs
General Knowledge
Computer
Python
HTML
GATE
: Computer Science and IT
Consider the relation X (P, Q, R, S, T, and U) with the following set of functional dependencies , Consider the relation X (P, Q, R, S, T, and U) with the following set of functional dependencies
Consider the relation X (P, Q, R, S, T, and U) with the following set of functional dependencies
A.
{P, R}→{S, T}
{P, R}→{S, T}
B.
{P, R}→{R, T}
{P, R}→{R, T}
C.
{P, S}→{S}
{P, S}→{S}
D.
{P, S, U} → {Q}
{P, S, U} → {Q}
Solution
C. {P, S}→{S}
Explanation
A functional dependency X -> Y is trivial if Y is a subset of X. In relational database theory, a functional dependency is a constraint between two sets of attributes in a relation from a database. In other words, functional dependency is a constraint that describes the relationship between attributes in a relation. The result is {P, S} →{S}
CCC Online Test 2021
CCC Practice Test Hindi
Python Programming Tutorials
Best Computer Training Institute in Prayagraj (Allahabad)
O Level NIELIT Study material and Quiz
Bank SSC Railway TET UPTET Question Bank
career counselling in allahabad
Sarkari Exam Quiz
Website development Company in Allahabad