LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   General (https://www.linuxquestions.org/questions/general-10/)
-   -   Method to find partial and transitive dependencies in database tables (https://www.linuxquestions.org/questions/general-10/method-to-find-partial-and-transitive-dependencies-in-database-tables-4175537462/)

aniammu 03-21-2015 01:57 PM

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?

unSpawn 03-21-2015 02:12 PM

Duplicate of https://www.linuxquestions.org/quest...es-4175537463/
Please do not do that again.


All times are GMT -5. The time now is 08:48 AM.