A relation in this form is free of all modification anomalies.
A. First normal form
B. Second normal form
C. Third normal form
D. Domain/key normal form
Answer: Option C
Solution (By Examveda Team)
Option1: First normal formIn the first normal form, all attributes in a relation must have atomic values. This means that each attribute cannot be further divided into smaller components. This helps in eliminating repeating groups and ensures that each attribute contains only a single value.
Option2: Second normal form
The second normal form builds on the first normal form by ensuring that all non-key attributes are fully functional dependent on the primary key. This means that each attribute in a relation must be dependent on the entire primary key, not just a part of it. This helps in eliminating partial dependencies.
Option3: Third normal form
The third normal form further refines the normalization process by ensuring that all attributes are dependent only on the primary key and not on other non-key attributes. This helps in eliminating transitive dependencies and ensures data integrity.
Option4: Domain/key normal form
The domain/key normal form is not a standard form in the normalization process. It refers to a state where all attributes are dependent on the primary key and are in their simplest form. This helps in ensuring data consistency and reducing redundancy.
Conclusion:
Based on the explanation provided, the option that best fits the description of being free of all modification anomalies is Third normal form. This is because it ensures that all attributes are dependent only on the primary key and not on other non-key attributes, thereby eliminating transitive dependencies and ensuring data integrity.
Join The Discussion