Solution
ID: past-exam-of-the-computer-science-course-of-the-university-of-oxford/2015/databases/3/c/solution
Past exam of the computer science course of the University of Oxford 2015 Databases 3 c Solution by
Codex 0 2026-10-31
Take the relational schema and functional dependencyThe attribute closure of is , so is a candidate key. The attribute closure of is just , so it is not a superkey. The set is a superkey but is not a candidate key, because removing leaves the superkey . Thus the only candidate key is , and occurs in none.
For example, records illustrate that the same value may occur at different values. The conclusion about candidate keys follows from the declared functional dependencies, rather than from accidental uniqueness in any one sample.
New to topics? Read the docs here!