2,227 views
1 votes
1 votes
Why 3NF is inadequate in situations where the relation:
1) has multiple candidates key
2) has candidate key that are composite
3) has overlapped candidate keys .

Example needed , I could justify a bit for point 3 where there may be partial FD's present in case we have candidate key that are composite , but I am not sure

1 Answer

Related questions

6 votes
6 votes
4 answers
1
learncp asked Aug 31, 2015
19,608 views
3NF is inadequate in situations where the relation:A. has multiple candidates keyB. has candidate key that are compositeC. has overlapped candidate keysD. all the above
1 votes
1 votes
2 answers
2
5 votes
5 votes
2 answers
3
learncp asked Aug 31, 2015
1,031 views
Is the following type of dependencies allowed in 3NF- ?A >Bwhere A is a proper subset of CKand    B is proper subset of another CK.
11 votes
11 votes
5 answers
4