Top "Functional-dependencies" questions

A functional dependency is a constraint between two sets of attributes in a relation, in relational algebra, databases and type systems.

Finding candidate keys for given relation

R = (A, B, C, D, E) The functional dependencies are: A -> B ED -> A BC -&…

functional-dependencies candidate-key
Lossless Join and Decomposition From Functional Dependencies

Suppose the relation R( K, L, M, N, P), and the functional dependencies that hold on R are: - L …

join database-normalization relational-algebra functional-dependencies lossless
Dependency preserving

So I am looking over my database notes and material trying to refresh myself on the general concepts and terminology …

database database-normalization functional-dependencies
Consider the following set F of functional dependencies on the relation schema r(A,B,C,D,E,F):

I have tried to reach out to my instructor with no luck and I really want to understand this process, …

functional-dependencies database-theory
Finding a relation in 3NF but not in BCNF

I've been reading many different sources on how to differentiate relations that are in 3NF/BCNF. And I've so far …

database database-normalization functional-dependencies 3nf bcnf
BCNF Decompositions and Lossless joins for Databases

Hey all I have an assignment that says: Let R(ABCD) be a relation with functional dependencies A → B, C → …

database database-design functional-dependencies bcnf
Difference between canonical cover and minimal cover

Apologies if this is a ridiculous question; I've searched high and low for an answer with no avail. I know …

database database-normalization functional-dependencies
Identifying Functional Dependencies II

I was getting a little confused with the last post so I found a nice example which should clear things …

database database-design relational-database functional-dependencies
BCNF decomposition algorithm explanation

I looked in Decomposing a relation into BCNF answers and tried it on my homework, but i don't get the …

database functional-dependencies decomposition bcnf
algorithm for computing closure of a set of FDs

I'm looking for an easy to understand algorithm to compute (by hand) a closure of a set of functional dependencies. …

database functional-dependencies