206 views

1 Answer

0 votes
0 votes
Suppose you have a fd set : { A->B , B->C , A->C }. now remove one by one each fd and try to generate it with other fd's if you are able to generate it with the help of other fd's then removed fd id redundant fd. In the given example A->C is redundant as it can be produced with the help of A->B and A->C.

Related questions

1 votes
1 votes
0 answers
1
JAINchiNMay asked Dec 1, 2022
439 views
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
1 votes
1 votes
0 answers
3
Manisha Jaishwal asked Jun 5, 2022
455 views
Consider the relation R(ABCDE) with the FD set F={A >E,BC >D,E >CD} . find the 3NF decomposition .
4 votes
4 votes
4 answers
4
Tuhin Dutta asked May 27, 2019
2,448 views
In a relation, if every attribute is prime but key may not be simple then the relation is in ______.A. 1NFB. 2NFC. 3NFD. BCNF