Functional Dependency Examples: 46 Problems with Answers
Worked examples of Functional Dependency to try before you open each solution, then practice problems with answers.
Worked Examples
Example 1
easyShow solution
Answer
First step
Full solution
- 2. Step 2: , . Each input gives one output.
- 3. Step 3: Yes, is a function of .
Example 2
mediumExample 3
mediumPractice Problems
Try each one, then open the solution to compare your method.
Example 1
easyExample 2
mediumExample 3
easyExample 4
easyExample 5
easyExample 6
easyExample 7
easyExample 8
easyExample 9
easyExample 10
easyExample 11
mediumExample 12
mediumExample 13
mediumExample 14
mediumExample 15
mediumExample 16
mediumExample 17
mediumExample 18
mediumExample 19
mediumExample 20
challengeExample 21
challengeExample 22
challengeExample 23
easyExample 24
easyExample 25
easyExample 26
easyExample 27
easyExample 28
easyExample 29
mediumExample 30
mediumExample 31
mediumExample 32
mediumExample 33
mediumExample 34
mediumExample 35
mediumExample 36
mediumExample 37
hardExample 38
hardExample 39
hardExample 40
hardExample 41
hardExample 42
challengeExample 43
challengeWhat to focus on
Core idea: Functional dependency means fixing the input forces a single determined output.
Common stuck point: The procedure for functional dependency is the easy part; the trap is allowing one input to give two outputs and still calling it a function. Asking "Does every allowed input produce exactly one output (never two)?" first is what keeps a correct-looking calculation from being attached to the wrong concept.
Ask yourself: Does every allowed input produce exactly one output (never two)?
Concept recap
A relationship where the value of one quantity (the output or dependent variable) is completely determined by the value of another quantity (the input or independent variable). If depends on , then knowing uniquely determines .
A functional dependency is like a library catalogue: each call number points to exactly one spot on the shelves, so knowing the number tells you where to look. Many books can share a subject, but a call number leading to two places would make the catalogue useless. The catalogue says nothing about why a book sits where it does.
Read the full lesson on Functional DependencyRelated concepts
Background knowledge
These ideas may be useful before you work through the harder examples.