in Databases reopened by
604 views
2 votes
2 votes
Is minimal set of functional dependency for a functional dependency set is always unique???
in Databases reopened by
604 views

1 comment

Not always unique.
1
1

2 Answers

0 votes
0 votes
A - B

B - C

C - A

  

 

Select any 2

3 Comments

 

can you explain more clearly

when you write the answer try to write everything, otherwise you write in the comment section

ok?

0
0
edited by

@

why you select this is the best answer?

please remove it?

0
0

$"$Is canonical cover(minimal set) always unique for any relationship$"?$

this is counterexample 

Given FD's

X→YZ
Y→XZ
Z→XY

https://stackoverflow.com/questions/34332781/is-canonical-cover-always-unique-for-any-relationship

0
0
0 votes
0 votes
Minimal Set may not be unique always.

Consider this R(ABC) with FD:{ A→ B,B→ C,C→ A, B→ A, C→ B, A→ C}

By solving we can get 2 minimal sets

M1: A→ B, B→ C. C→ A

M2: B→ A, C→ B, A→ C

Related questions

3 votes
3 votes
4 answers
1