3
In RDBMS, different classes of relations are created using technique to prevent modification anomalies.
EXPLANATION
Relational Model
- Database Normalization and Modification Anomalies:
- In relational database design, unnormalized schemas suffer from severe update, insertion, and deletion anomalies due to data redundancy.
- Normal Forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF) decompose relations using functional and multivalued dependencies into progressively higher normal forms.
- This decomposition eliminates undesirable dependencies and prevents modification anomalies while preserving data integrity.
- Conclusion: Different classes of relations are created using Normal Forms (Option 4).
Correct option: (4) Normal Forms
Explanation not matching this question?
क्या व्याख्या इस प्रश्न से मेल नहीं खा रही?
Report
Want to practice this paper in exam conditions?
क्या आप परीक्षा जैसे माहौल में अभ्यास करना चाहते हैं?
Test yourself in 5-question batch format with timer and hidden answers.
5-प्रश्नों के बैच फॉर्मैट, टाइमर और छिपे उत्तरों के साथ खुद को परखें।
Start Practice Mode →
प्रैक्टिस टेस्ट मोड शुरू करें →