# UGCNET-Oct2020-II: 14

38 views

Consider a relational schema $S=(U,V,W,X,Y,Z)$ on which the following functional dependencies hold:

$(U \rightarrow V, VW \rightarrow X, Y \rightarrow W, X \rightarrow U)$

Which are the candidate keys among following options?

1. $UY, VY$
2. $UY, VY, XY$
3. $UYZ, VYZ, VWZ$
4. $UYZ, VYZ, XYZ$

recategorized
0
UYZ,VYZ,XYZ

Option (D)

Given FD

U->V  , Y->W,  X->U, VW->X  SO

{UY}+->VWXUY

everything  except Z in relation so add Z too to get relation S  i.e {UYZ}

similarly {VY}+ ->VYWXU  again add Z  {VYZ}

also {XY}+ ->VWXU  again add Z     {XYZ}

so ans is 4

note:- VWZ wont give  Y hence 3 is incorrect

## Related questions

1
24 views
In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if At least one of the operations is write operation Both the operations are performed on the same data item Both the operations are performed by different transactions Both the operations are performed on different ... $(b)$ and $(c)$ only $(a)$, $(c)$ and $(d)$ only $(c)$ and $(d)$ only
Match $\text{List I}$ with $\text{List II}$ Choose the correct answer from the options given below: $A-II, B-IV, C-III, D-I$ $A-IV, B-I, C-II, D-III$ $A-II, B-I, C-IV, D-III$ $A-III, B-IV, C-I, D-II$
Consider the following table structures related to a university for the below question. EMPLOYEE NAME VARCHAR (30) NOT NULL, EID VARCHAR (10) NOT NULL, DEPTNO INT (5) NOT NULL, HODEID VARCHAR (10), SALARY INT (10), PRIMARY KEY (EID), FOREIGN KEY (HODEID) REFERENCES ... $II$ are false Statement $I$ is correct but Statement $II$ is false Statement $I$ is incorrect but Statement $II$ is true