Hi there,

I had a normal form problem, my relation is R(a, b, c, d) with functional dependencies of F = { [abc > d], [bcd > a], [a > b] }

just wondering what the possible subsets of F are?

Thanks

May is surely homework season on dbforums.

It's actually work related, but thanks for your reply.

The possible subsets of F are:

Scope 0: The empty set
Scope 1: a, b, c, d
Scope 2: ab, ac, ad, bc, bd, cd
Scope 3: abc, acd, bcd
Scope 4: abcd

Just an observation, but there are a very small subset of people that use Relational Algebra for work. None of those people would ask this question. If you're going to try to blow smoke, at least try to blow plausible smoke.

-PatP

Especially when you posted the problem earlier as an end of semester test question.

You are employed by a company that makes curly braces, perhaps?