Method to find partial and transitive dependencies in database tables
Hello everyone..
Relation is given,What are the methods to find the dependencies in that table.
for example
if a Relation R(A,B,C,D) exist
ABC->D
D->A
are its functional dependencies.
Then the table is in which normal form?
Also another Relation R(A,B,C,D,E)
A->BCDE
BC->ADE
D->E
D->B
are the FDs
In which normal form the table exits and why?what are the methods to find transitive dependency in a table?
|