Relational-databases

Question 7

In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.

A	Functional Dependencies
B	Data integrity
C	Referential integrity
D	Normal forms

Database-Management-SystemRelational-databasesUGC NET CS 2017 Nov- paper-2

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

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