Q2
The different classes of relations created by the technique for preventing modification anomalies are called:
A.
normal forms.
AnswerB.
referential integrity constraints.
C.
functional dependencies.
D.
None of the above is correct.
Answer: Option A
Solution
Answer: Option A
Solution:
Option1: Normal forms are different levels of organization for a relational database table to reduce redundancy and dependency. Each normal form represents a higher level of normalization, which helps in preventing modification anomalies.Option2: Referential integrity constraints are rules that enforce relationships between tables in a database. They ensure that data is consistent and accurate by preventing actions that would destroy links between tables.
Option3: Functional dependencies are relationships between attributes in a database table. They help in understanding how data is related and can be used to determine the normal form of a table.
Option4: None of the above is correct. This option implies that the classes of relations created to prevent modification anomalies do not fall under normal forms, referential integrity constraints, or functional dependencies.
In conclusion, the different classes of relations created by the technique for preventing modification anomalies are known as normal forms. These normal forms help in organizing data in a relational database to reduce redundancy and dependency, ultimately improving data integrity and consistency.