What does a functional dependency X -> Y mean?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $24.99Unlock all

Get ready for your Fundamentals of Computing Test. Utilize flashcards and multiple-choice questions. Every question includes hints and explanations. Prepare effectively and ace your exam now!

Multiple Choice

What does a functional dependency X -> Y mean?

Explanation:
A functional dependency X -> Y means Y is determined by X: if two records have the same X value, their Y values must be identical. In other words, X carries enough information to fix Y. So the description that matches this idea is that Y depends on X. The other interpretations don’t fit: saying X depends on Y reverses the relationship, claiming X and Y are independent ignores the dependency, and saying X and Y are the same attribute confuses dependency with equality.

A functional dependency X -> Y means Y is determined by X: if two records have the same X value, their Y values must be identical. In other words, X carries enough information to fix Y.

So the description that matches this idea is that Y depends on X. The other interpretations don’t fit: saying X depends on Y reverses the relationship, claiming X and Y are independent ignores the dependency, and saying X and Y are the same attribute confuses dependency with equality.

More Multiple Choice Questions
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy