Learn and practice Aptitude questions and answers with explanation for interview, competitive exam (Pariksha Corner )

Friday, January 24, 2020

Given the relational functional dependencies x —> w ; x ->y

Given the relational functional dependencies x —> w ; x ->y ; y -> z and z -> pq which of the following is NOT VALID ?
Ax -> z
Bx ->wy
Cy —> pq
Dw ->z

Answer:w ->z

Explanation:

If X→Y and Y→Z then X→Z so it is valid.
If X→W and X→Y then X→WY so it is valid.
If Y→Z and Z→PQ then Y→PQ so it is valid.
w not implies anything so w ->z is not valid.
so answer is w->Z

Akilesh Kharvi
answered Dec 8 '2016 at 21:33

All Comments

Post your answers here:

Post

Post your comments here:

Post

Categories