Database - The Relational Model and Normalization - Discussion
Discussion Forum : The Relational Model and Normalization - General Questions (Q.No. 16)
16.
A relation in this form is free of all modification anomalies.
Discussion:
12 comments Page 2 of 2.
Jatin said:
1 decade ago
Yes, the answer is Domain/key normal form. See there might be some anomalies left in the 3NF and BCNF.
Rohit 98 said:
10 years ago
After a SQL database is in third normal form, you've eliminated most, but not all, chances of modification anomalies. Normal forms beyond the third are defined to squash those few remaining bugs.
Domain-key normal form (DK/NF):
Boyce-Codd normal form (BCNF), fourth normal form (4NF), and fifth normal form (5NF) are examples of such forms. Each form eliminates a possible modification anomaly but does not guarantee prevention of all possible modification anomalies. Domain-key normal form, however, provides such a guarantee.
Domain-key normal form (DK/NF):
Boyce-Codd normal form (BCNF), fourth normal form (4NF), and fifth normal form (5NF) are examples of such forms. Each form eliminates a possible modification anomaly but does not guarantee prevention of all possible modification anomalies. Domain-key normal form, however, provides such a guarantee.
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers