Curioustab

Home » Database » The Relational Model and Normalization

For some relations, changing the data can have undesirable consequences called:

referential integrity constraints.
modification anomalies.
normal forms.
transitive dependencies.

Correct Answer: modification anomalies.

← Previous Question Next Question→

More Questions from The Relational Model and Normalization

Which of the following is not a restriction for a table to be a relation?
A functional dependency is a relationship between or among:
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
The functional dependency R → S means that the value of S can be determined when we are given a value of R.
A candidate key is a determinant that determines all the other columns is a relation.
In a relation, the rows are sometimes called "fields."
A relation is in 5NF when multivalued dependencies are isolated in their own relation.
Keys made up of two or more attributes are called composite keys.
A functional dependency is a relationship between or among attributes.
A primary key is a composite key that was selected to be the main identifier for the relation.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion