Database chp4 - test
Referring to the figure below, which of the following is NOT true?
A component is always used in only one item.
In the figure below, the primary key for "Order Line" is which type of key?
Composite
_______ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.
Data integrity
An attribute that may have more than one meaning is called a(n)
homonym.
A domain definition consists of the following components EXCEPT:
integrity constraints.
In the figure below, what type of relationship do the relations depict?
one to many
Two or more attributes having different names but the same meaning are called:
synonyms
A functional dependency between two or more nonkey attributes is called a:
transitive dependency.
The relational data model consists of which components?
All of these
Physical database design decisions must be made carefully because of impacts on:
All of these.
in the figure below, what type of relationship is depicted?
Many-to-many
In the figure below, what type of key is depicted?
Recursive foreign
Which of the following is NOT a reason to create an instance of a relational schema with sample data?
Sample data can reverse database implementation errors.
A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?
Second
In the figure below, what type of relationship do the relations depict?
Strong entity/weak entity
An alternative name for an attribute is a(n):
alias
Which of the following anomalies result from a transitive dependency?
all
Which of the following are anomalies that can be caused by redundancies in tables?
all
Which of the following are properties of relations?
all
An understanding of how to merge relations is important because:
all of these
A primary key that consists of more than one attribute is called a:
composite key.
In the SQL language, the ________ statement is used to make table definitions.
create table
When a regular entity type contains a multivalued attribute, one must
create two new relations, one containing the multivalued attribute.
A nonkey attribute is also called a(n):
descriptor.
The attribute on the left-hand side of the arrow in a functional dependency is the
determinant.
The ________ states that no primary key attribute may be null.
entity integrity rule
When all multivalued attributes have been removed from a relation, it is said to be in:
first normal form
An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:
foreign key.
A constraint between two attributes is called a(n):
functional dependency
All of the following are the main goals of normalization EXCEPT:
maximize storage space.
The entity integrity rule states that:
no primary key attribute can be null.
A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.
partial functional
A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:
physical.
an attribute (or attributes) that uniquely identifies each row in a relation is called a:
primary key.
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.
A two-dimensional table of data is called a:
relation.
The figure below is an example of mapping which type of relationship?
ternary
A candidate key must satisfy all of the following conditions EXCEPT:
the key must indicate the row's position in the table.
A relation that contains minimal redundancy and allows easy use is considered to be:
well-structured
Understanding the steps involved in transforming EER diagrams into relations is important because:
you must be able to check the output of a CASE tool.
