1621232265911_problems based on keys_cb19c9711ea9a3b7f668bc741ffb57a8 (1).pptx

Database

1. PROBLEMS BASED ON KEYS

2. Find out the candidate keys R(ABCD) A->B B->C C->A R(ABCD) A -> CD D -> A R(ABCDEF) AB->C C -> D B->AE

3. 4. R(ABCD) AB->CD C->A D->B 5. R(ABCDEFGH) AB -> C A -> DE B -> F F ->GH

4. 6. R(ABCDEFGH) AB -> C BD ->EF AD -> G A -> H 7. R(ABCDE) BC ->ADE D -> B 8. R(WXYZ) Z-> W Y-> XZ WX-> Y

5. ANS: AD,BD,CD AB,BD BF AB,AD,BC,CD AB ABD BC, CD Y, WX,XZ