Database-Management-System
October 4, 2023Nielit Scentist-B [02-12-2018]
October 4, 2023Database-Management-System
|
Question 682
|
In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
|
Functional Dependencies
|
|
|
Data integrity
|
|
|
Referential integrity
|
|
|
Normal forms
|
Question 682 Explanation:
Normal forms in order to reduce data redundancy and improve data integrity. Normal forms to prevent modification anomalies.
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly
Correct Answer: D
Question 682 Explanation:
Normal forms in order to reduce data redundancy and improve data integrity. Normal forms to prevent modification anomalies.
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly