Chapter 4 (Final) Flashcards
When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.
False
A primary key is an attribute that uniquely identifies each row in a relation.
True
Anomalies do not generally arise out of transitive dependencies.
False
A relation that contains minimal redundancy and allows easy use is considered to be:
well-structured.
Which of the following violates the atomic property of relations?
Sam Hinz
A transversal dependency is a functional dependency between two or more nonkey attributes.
False
View integration is the process of merging relations together.
True
A candidate key must satisfy all of the following conditions EXCEPT:
the key must indicate the row’s position in the table.
A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.
True
The entity integrity rule states that a primary key attribute can be null.
False
A primary key whose value is unique across all relations is called a(n):
enterprise key.
The normal form which deals with multivalued dependencies is called:
fourth normal form.
When a regular entity type contains a multivalued attribute, two new relations are created.
True
________ anomalies can be caused by editing data in tables.
Modification
A synonym is an attribute that may have more than one meaning.
False
An attribute that may have more than one meaning is called a(n):
homonym.
A two-dimensional table of data sometimes is called a:
relation.
A rule that states that each foreign key value must match a primary key value in the other relation is called the:
referential integrity constraint.
In the SQL language, the ________ statement is used to make table definitions.
create table
________ problems are encountered when removing data with transitive dependencies.
Deletion
When a regular entity type contains a multivalued attribute, one must:
create two new relations, one containing the multivalued attribute.