If attribute A determines both attributes B and C, then it is also true that:
If attribute A determines both attributes B and C, then it is also true that:
Which of the following is a group of one or more attributes that uniquely identifies a row?
Which of the following is a group of one or more attributes that uniquely identifies a row?
A functional dependency is a relationship between or among:
A functional dependency is a relationship between or among:
A functional dependency is a relationship between or among attributes.
A functional dependency is a relationship between or among attributes.
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
The only reason for the existence of relations is to store instances of functional dependencies.
The only reason for the existence of relations is to store instances of functional dependencies.
A key is a group of one or more attributes that uniquely identifies a row.
A key is a group of one or more attributes that uniquely identifies a row.
In a relation, the rows are sometimes called "fields".
In a relation, the rows are sometimes called "fields".
A tuple is a(n):
A tuple is a(n):
A primary key is a composite key that was selected to be the main identifier for the relation.
A primary key is a composite key that was selected to be the main identifier for the relation.
A primary key is a composite key that was selected to be the main identifier for the relation.
A primary key is a composite key that was selected to be the main identifier for the relation.
For some relations, changing the data can have undesirable consequences called:
For some relations, changing the data can have undesirable consequences called:
A relation has cells that hold multi-value entries.
A relation has cells that hold multi-value entries.
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Any table that meets the definition of a relation is said to be in first normal form.
Any table that meets the definition of a relation is said to be in first normal form.
Row is synonymous with the term:
Row is synonymous with the term:
Given the functional dependency R → S , R is called the determinant.
Given the functional dependency R → S , R is called the determinant.
Keys made up of two or more attributes are called composite keys.
Keys made up of two or more attributes are called composite keys.
Which of the following is not a restriction for a table to be a relation?
Which of the following is not a restriction for a table to be a relation?
A primary key is a composite key that was selected to be the main identifier for the relation.
A primary key is a composite key that was selected to be the main identifier for the relation.
In a relation, the columns are sometimes called "attributes".
In a relation, the columns are sometimes called "attributes".
A relation is considered a:
A relation is considered a:
In a relation, the order of the columns does not matter.
In a relation, the order of the columns does not matter.
A relation in this form is free of all modification anomalies.
A relation in this form is free of all modification anomalies.
In the relational model, relationships between relations or tables are created by using:
In the relational model, relationships between relations or tables are created by using:
One solution to the multivalued dependency constraint problem is to:
One solution to the multivalued dependency constraint problem is to:
The functional dependency R → S means that the value of S can be determined when we are given a value of R.
The functional dependency R → S means that the value of S can be determined when we are given a value of R.
Given the functional dependency R → (S,T) , then it is also true that R → S.
Given the functional dependency R → (S,T) , then it is also true that R → S.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A relation is in this form if it is in BCNF and has no multivalued dependencies:
Relations are categorized into normal forms according to the referential integrity constraints that they have.
Relations are categorized into normal forms according to the referential integrity constraints that they have.
A relation is a two-dimensional table.
A relation is a two-dimensional table.
In a relation, the order of the rows matters.
In a relation, the order of the rows matters.
A functional dependency is always an equation.
A functional dependency is always an equation.
A relation is in 5NF when multivalued dependencies are isolated in their own relation.
A relation is in 5NF when multivalued dependencies are isolated in their own relation.
The primary key is selected from the:
The primary key is selected from the:
An attribute is a(n):
An attribute is a(n):
The different classes of relations created by the technique for preventing modification anomalies are called:
The different classes of relations created by the technique for preventing modification anomalies are called:
If attributes A and B determine attribute C, then it is also true that:
If attributes A and B determine attribute C, then it is also true that:
A primary key is a composite key that was selected to be the main identifier for the relation.
A primary key is a composite key that was selected to be the main identifier for the relation.
Table is synonymous with the term:
Table is synonymous with the term:
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):
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):
In a relation, the rows are sometimes called "records".
In a relation, the rows are sometimes called "records".
A candidate key is a determinant that determines all the other columns is a relation.
A candidate key is a determinant that determines all the other columns is a relation.
