IS 441 - CH 4

Referring to the figure below, which of the following is NOT true? A component can be part of an item. A component is always used in only one item. A component may be used in many items. A component is part of an item.

A component is always used in only one item.

When a regular entity type contains a multivalued attribute, one must: None of these. create two new relations, both containing the multivalued attribute. create two new relations, one containing the multivalued attribute. create a single relation with multiple lines for each instance of the multivalued attribute.

create two new relations, one containing the multivalued attribute.

The attribute on the left-hand side of the arrow in a functional dependency is the: primary key. foreign key. candidate key. determinant.

determinant

When all multivalued attributes have been removed from a relation, it is said to be in: third normal form. Boyce-Codd normal form. first normal form. second normal form.

first normal form.

The normal form which deals with multivalued dependencies is called: Boyce-Codd normal form. fifth normal form. fourth normal form. sixth normal form.

fourth normal form.

A constraint between two attributes is called a(n): functional relation constraint. functional relation. functional dependency. attribute dependency.

functional dependency.

A domain definition consists of the following components EXCEPT: integrity constraints. size. domain name. data type.

integrity constraints

All of the following are the main goals of normalization EXCEPT: make it easier to maintain data. maximize storage space. simplify the enforcement of referential integrity. minimize data redundancy.

maximize storage space.

The entity integrity rule states that: referential integrity must be maintained across all entities. a primary key must have only one attribute. no primary key attribute can be null. each entity must have a primary key.

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. merged relation partial key-based partial functional cross key

partial functional

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. entity key group rule. key match rule. foreign/primary match rule.

referential integrity constraint.

A candidate key must satisfy all of the following conditions EXCEPT: the key must uniquely identify the row. the key must be nonredundant. each nonkey attribute is functionally dependent upon it. the key must indicate the row's position in the table.

the key must indicate the row's position in the table.

A functional dependency between two or more nonkey attributes is called a: partial transitive dependency. transitive dependency. partial nonkey dependency. partial functional dependency.

transitive dependency.

Which of the following are properties of relations? Each attribute has a unique name. No two rows in a relation are identical. All of these. There are no multivalued attributes in a relation.

All of these Unique Name Atomic (not multivalued, not composite) Every row is unique Attribute Columns in tables must have unique names Order of Columns and Rows must be irrelevant

Which of the following are anomalies that can be caused by redundancies in tables? Insertion All of these Modification Deletion

All of these Deletion Insertion Modification

In the figure below, what is depicted? An associative entity A unary relationship A one-to-one relationship A one-to-many relationship

An Associative entity

In the figure below, the primary key for "Order Line" is which type of key? Foreign Standard Grouped Composite

Composite

A primary key that consists of more than one attribute is called a: composite key. multivalued key. cardinal key. foreign key.

Composite Key

The relational data model consists of which components? All of these Data integrity Data manipulation Data structure

Data Integrity Data Manipulation Data Structure

A composite key consists of only one attribute. True False

False

A relation is in first normal form if it has no more than one multivalued attribute. True False

False

The primary key of the many side migrates to the one side when transforming a one-to-many relationship. True False

False

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 attribute. link key. foreign key. link attribute.

Foreign Key

Which of the following anomalies results from a transitive dependency? Modification All of these Insertion Deletion

Insertion Deletion Modification

In the figure below, what type of relationship do the relations depict? Many-to-many Strong entity/weak entity Ternary One-to-many

One to many

An attribute (or attributes) that uniquely identifies each row in a relation is called a: column. duplicate key. foreign field. primary key

Primary Key

A two-dimensional table of data sometimes is called a: group. set. relation. declaration

Relation

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 Fourth Third First

Second

In the figure below, what type of relationship do the relations depict? Composite foreign key Multivalued Strong entity/weak entity One-to-many

Strong entity/weak entity

The figure below is an example of mapping which type of relationship? First Ternary Unary Second

Ternary

A partial functional dependency is a functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key. True False

True

A primary key is an attribute that uniquely identifies each row in a relation. True False

True

A referential integrity constraint is a rule that maintains consistency among the rows of two relations. True False

True

If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations. True False

True

In the figure below, each employee has exactly one manager. True False

True

One property of a relation is that each attribute within a relation has a unique name. True False

True

The allowable range of values for a given attribute is part of the domain constraint. True False

True

When a regular entity type contains a multivalued attribute, two relations are created. True False

True

When normalizing, the goal is to decompose relations with anomalies to produce smaller, well-structured relations. True False

True

A relation that contains minimal redundancy and allows easy use is considered to be: simple. complex. well-structured. clean.

Well structured