Problem 3 (10 points): Given the following table defining Relation R: ID SpongeBob Squidward 444 ABC...

 

Transcribed Image Text:

Problem 3 (10 points): Given the following table defining Relation R: ID SpongeBob Squidward 444 ABC 555 | XYX 666 ABC 777 JJJ 888 PQR 999 JJJ MrKrab $$ ## $$ %% $$ %% 11 22 33 44 55 55 How would you characterize the existence of the Functional Dependencies (a. - e.) listed below. Explain why in each case. (You have to assume that the table can be expanded) a. ID SpongeBob b. Squidward MrKrab a. MrKrab SpongeBob b. SpongeBob ID c. SpongeBob Mrkrab d. Explain why {SpongeBob, MrKrab) is not a candidate key for the table presented. Problem 3 (10 points): Given the following table defining Relation R: ID SpongeBob Squidward 444 ABC 555 | XYX 666 ABC 777 JJJ 888 PQR 999 JJJ MrKrab $$ ## $$ %% $$ %% 11 22 33 44 55 55 How would you characterize the existence of the Functional Dependencies (a. - e.) listed below. Explain why in each case. (You have to assume that the table can be expanded) a. ID SpongeBob b. Squidward MrKrab a. MrKrab SpongeBob b. SpongeBob ID c. SpongeBob Mrkrab d. Explain why {SpongeBob, MrKrab) is not a candidate key for the table presented.