24
In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
- AFunctional dependencies.
- BData integrity
- CReferential integrity
- DNormal Form
Answer not set
Discussion 1
Log in or create a free account to reply and vote.
0
CCommunity
A functional dependency is a constraint that describes the relationship between attributes in a relation. Data integrity refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or another construct.
Referential integrity is a relational database concept, which states that table relationships must always be consistent.
Normalization is a process of organizing the data in the database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
1NF, 2NF, 3NF and BCNF are types of normal forms.
So, option (D) is correct.
Referential integrity is a relational database concept, which states that table relationships must always be consistent.
Normalization is a process of organizing the data in the database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
1NF, 2NF, 3NF and BCNF are types of normal forms.
So, option (D) is correct.