Relational-databases
October 4, 2023Nielit Scentist-B [02-12-2018]
October 4, 2023Relational-databases
| Question 7 |
In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
| Functional Dependencies | |
| Data integrity | |
| Referential integrity | |
| Normal forms |
Question 7 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 7 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
Subscribe
Login
0 Comments