UGC NET CS 2005 Dec-Paper-2
November 5, 2023Question 1783 – Nielit Scientist-B 17-12-2017
November 5, 2023Database-Management-System
| Question 745 |
Which of the following statements are not correct?
S1: 3NF decomposition is always lossless join and dependency preserving
S2: 3NF decomposition is always lossless join but may or may not be dependency preserving
S3: BCNF decomposition is always lossless join and dependency preserving
S4: BCNF decomposition is always lossless join but may or may not be dependency preserving
S1: 3NF decomposition is always lossless join and dependency preserving
S2: 3NF decomposition is always lossless join but may or may not be dependency preserving
S3: BCNF decomposition is always lossless join and dependency preserving
S4: BCNF decomposition is always lossless join but may or may not be dependency preserving
| Only S1 | |
| Only S4 | |
| boh S1 and S4 | |
| Both S2 and S3 |
Question 745 Explanation:
→ Sometimes, BCNF may not be functional dependency preserving.
→ lossless join should be compulsory in any normal form.
→ lossless join should be compulsory in any normal form.
Correct Answer: D
Question 745 Explanation:
→ Sometimes, BCNF may not be functional dependency preserving.
→ lossless join should be compulsory in any normal form.
→ lossless join should be compulsory in any normal form.