Database - Database Design Using Normalization - Discussion
Discussion Forum : Database Design Using Normalization - True or False (Q.No. 7)
7.
In all cases, normalization into BCNF is desirable.
Discussion:
2 comments Page 1 of 1.
Hrishikesh said:
8 years ago
Nope. 3NF is always desirable.
Even though BCNF is a part of 3NF, BCNF give lossy join.
While 3NF gives lossless join. So 3NF is desirable.
Even though BCNF is a part of 3NF, BCNF give lossy join.
While 3NF gives lossless join. So 3NF is desirable.
Ashutosh Sanap said:
10 years ago
Not in all cases, might be in some cases only.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers