In a relation, the columns are sometimes called "attributes".
In a relation, the columns are sometimes called "attributes".
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.
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 relation has cells that hold multi-value entries.
A relation has cells that hold multi-value entries.
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.
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.
A functional dependency is a relationship between or among attributes.
A functional dependency is a relationship between or among attributes.
In a relation, the order of the rows matters.
In a relation, the order of the rows matters.
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.
A tuple is a(n):
A tuple is a(n):
In a relation, the rows are sometimes called "records".
In a relation, the rows are sometimes called "records".
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:
A relation is considered a:
A relation is considered a:
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.
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:
Table is synonymous with the term:
Table is synonymous with the term:
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:
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:
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 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 functional dependency is a relationship between or among:
A functional dependency is a relationship between or among:
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 relation is a two-dimensional table.
A relation is a two-dimensional table.
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.
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:
In a relation, the rows are sometimes called "fields".
In a relation, the rows are sometimes called "fields".
Given the functional dependency R → S , R is called the determinant.
Given the functional dependency R → S , R is called the determinant.
One solution to the multivalued dependency constraint problem is to:
One solution to the multivalued dependency constraint problem is to:
In a relation, the order of the columns does not matter.
In a relation, the order of the columns does not matter.
The primary key is selected from the:
The primary key is selected from the:
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?
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.
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.
A functional dependency is always an equation.
A functional dependency is always an equation.
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 in this form is free of all modification anomalies.
A relation in this form is free of all modification anomalies.
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:
Row is synonymous with the term:
Row 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):
An attribute is a(n):
An attribute is a(n):
Keys made up of two or more attributes are called composite keys.
Keys made up of two or more attributes are called composite keys.
