466 views

1 Answer

2 votes
2 votes

here if you Look carefully .....

common attributes in table (ABC) and (ACD)....is a set of attributes ....

so common set is AC....

now this set must be key in either of table ....either in ABC or in ACD....

but as per FD it totally fails ...because AC togather is not key in either of table ....so its lossy decomposition......

while in all other attributes ...a common attributes among any 2 table is a KEY ...but it fails in this decomposition ...so it is answer...

Related questions

2 votes
2 votes
2 answers
1
atulcse asked Jan 22, 2022
620 views
If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency?
1 votes
1 votes
2 answers
3
Na462 asked Jun 29, 2018
569 views
1 votes
1 votes
2 answers
4
agoh asked May 10, 2017
1,130 views
Does any normal form impose the condition "every non-key should depend upon every key"?