Normal form | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 3

Normal form

Is the third normal form adequate for database normalisation ?

21st Aug 2019, 2:50 AM
Sanjay Kamath
Sanjay Kamath - avatar
3 Answers
+ 3
Chee Chang Long Thanks 🌞.... Is BCNF necessary ? 🤔
21st Aug 2019, 3:05 AM
Sanjay Kamath
Sanjay Kamath - avatar
+ 2
Yes, third normal form should be enough. Its depend on which kind of your design, some others may need higher form
21st Aug 2019, 2:57 AM
Uchiha Itachi
Uchiha Itachi - avatar
+ 2
BCNF is the special case for 3th normal form. Both are necessary if you use with correct condition
21st Aug 2019, 3:07 AM
Uchiha Itachi
Uchiha Itachi - avatar