how to check a database for functional dependencies

[rotaryfreak]

hi all,

im new to databases and im trying to build a small database for a small side project im working on. I was trying to optimize it by removing any dependencies and i was just wondering if i can query my database to find out whether functional dependency A → B holds, for example, on a relation R with attributes ABCD, or any other relation with any number of attributes for that matter?

thank you

[patjones]

I think I understand what you are asking, but you're asking it in a very abstract way. Perhaps you can be a little more concrete rather than expressing the problem in set theory notation.

For instance, maybe you could give us some table schema from your actual database; not the entire schema...just enough to for us to discuss the issue. Thanks.

Pat