Question 1

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

Accepted Answer

The answer of A functional dependency between two or more...

Question 2

Understanding the steps involved in transforming EER diagrams into relations is important because:
A) one must be able to check the output of a CASE tool.
B) there are rarely legitimate alternatives from which to choose.
C) CASE tools can model any situation.
D) CASE tools model hypothetical business problems.

Accepted Answer

The answer of Understanding the steps involved in transforming EER...

Question 3

________ problems are encountered when removing data with transitive dependencies.
A) Insertion
B) Modification
C) Deletion
D) Merging

Accepted Answer

Deletion problems are encountered when removing data with transitive dependencies. Transitive dependencies occur when a relation depends on another relation via a third relation. Deletion of data with such dependencies can cause loss of data integrity or inconsistency in the database. This is because deleting data from one relation may also affect data in other related relations. Therefore, careful handling is required when removing data with transitive dependencies.

Question 4

An alternative name for an attribute is called a(n):
A) synonym.
B) alias.
C) alternate attribute.
D) related characteristic.

Accepted Answer

An alternate name for an attribute is commonly referred to as an alias. A synonym is a word or phrase that means the same as another word or phrase. An alternate attribute and related characteristic are not commonly used terms to describe an attribute's alternate name.

Question 5

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

Accepted Answer

The relations between the entities show a one-to-many relationship. Specifically, each employee can have many dependents, but each dependent can only have one employee as their sponsor.

Question 6

In the figure below, what type of key is depicted? 
A) Primary
B) Recursive primary
C) Composite
D) Recursive foreign

Accepted Answer

The answer of In the figure below, what type of...

Question 7

A nonkey attribute is also called a(n):
A) column.
B) unimportant datum.
C) descriptor.
D) address.

Accepted Answer

A nonkey attribute is a descriptive attribute in a database table that can be used to provide additional information about the entity represented by the primary key attribute. Nonkey attributes are not used to uniquely identify a record in the table but can be used to provide additional context or descriptive labels. Therefore, the best choice is C, descriptor.

Question 8

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.
A) partial key-based
B) partial functional
C) cross key
D) merged relation

Accepted Answer

A partial functional dependency occurs when a non-key attribute is functionally dependent on only part of the primary key, meaning that it is not fully dependent on the entire key. This type of dependency violates the rules of normalization and can lead to data inconsistencies and redundancies.

Question 9

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

Accepted Answer

A candidate key need not indicate the row's position in the table. Its primary function is to uniquely identify the row and ensure nonredundancy.

Question 10

Two or more attributes having different names but the same meaning are called:
A) homonyms.
B) aliases.
C) synonyms.
D) alternate attributes.

Accepted Answer

The answer of Two or more attributes having different names...

Question 11

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

Accepted Answer

A constraint between two attributes in a database is a functional dependency. This means that the value of one attribute can be determined by the value of another attribute. A functional dependency is a rule that is used in database normalization to ensure that data is organized efficiently and accurately. Choice A, functional relation, is not a commonly used term in database design. Choice B, attribute dependency, is a broader term that could refer to any relationship between attributes, not just functional dependencies. Choice D, functional relation constraint, is not a standard term in database design.

Question 12

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?
A) First
B) Second
C) Third
D) Fourth

Accepted Answer

The answer of A relation that contains no multivalued attributes...

Question 13

The normal form which deals with multivalued dependencies is called:
A) fifth normal form.
B) fourth normal form.
C) Boyce-Codd normal form.
D) sixth normal form.

Accepted Answer

The normal form which deals with multivalued dependencies is the fourth normal form, which addresses situations where a relation has multiple independent sets of multivalued dependencies. The other options are incorrect as they address other types of dependencies or are not related to multivalued dependencies.

Question 14

The need to ________ relations commonly occurs when different views need to be integrated.
A) metadata
B) system
C) drop
D) merge

Accepted Answer

The best choice is "merge" as it means to combine or blend different things together, which is necessary when there are different views that need to be integrated. The other options, such as "metadata" (data that describes other data) and "system" (a set of interconnected components that work together) do not directly relate to integrating different views. "Drop" means to let go or eliminate something, which would not be helpful in integrating different views.

Question 15

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

Accepted Answer

The answer of In the figure below, what is depicted?...

Question 16

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

Accepted Answer

In a functional dependency, the attribute on the left-hand side (LHS) of the arrow is known as the determinant, which determines the value of the attribute(s) on the right-hand side (RHS). The determinant is a candidate key or a set of attributes that uniquely identifies the values in the relation. Therefore, option B - determinant is the correct answer, and the candidate key, primary key, and foreign key are not the attributes on the left-hand side of the arrow in a functional dependency.

Question 17

An attribute that may have more than one meaning is called a(n):
A) homonym.
B) alias.
C) double defined attribute.
D) synonym.

Accepted Answer

Homonym refers to a word that has two or more different meanings. Therefore, an attribute that may have more than one meaning is called a homonym.

Question 18

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

Accepted Answer

The answer of In the figure below, what type of...

Question 19

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:
A) fifth normal form.
B) fourth normal form.
C) Boyce-Codd normal form.
D) sixth normal form.

Accepted Answer

The Boyce-Codd normal form deals with functional dependencies where there are multiple candidate keys. It ensures that each determinant is a candidate key, making sure that there is no redundancy or anomalies in the database. This is different from the fourth normal form, which deals with multivalued dependencies, and the fifth and sixth normal form which are less commonly used. Therefore, the best choice is C, as it specifically addresses the issue presented in the question.

Question 20

When a regular entity type contains a multivalued attribute, one must:
A) create a single relation with multiple lines for each instance of the multivalued attribute.
B) create two new relations, one containing the multivalued attribute.
C) create two new relations, both containing the multivalued attribute.
D) delete the relation and start over.

Accepted Answer

When a regular entity type contains a multivalued attribute, it is best to create two new relations: one for the regular entity type and another for the multivalued attribute. The new relation for the multivalued attribute should have a foreign key that references the primary key of the regular entity type. This approach ensures that the database is normalized and avoids duplication of data.

Quiz 4: Logical Database Design and the Relational Model

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

Understanding the steps involved in transforming EER diagrams into relations is important because:

________ problems are encountered when removing data with transitive dependencies.

An alternative name for an attribute is called a(n) :

In the figure below, what type of relationship do the relations depict?

In the figure below, what type of key is depicted?

A nonkey attribute is also called a(n) :

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.

A candidate key must satisfy all of the following conditions EXCEPT:

Two or more attributes having different names but the same meaning are called:

A constraint between two attributes is called a(n) :

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?

The normal form which deals with multivalued dependencies is called:

The need to ________ relations commonly occurs when different views need to be integrated.

In the figure below, what is depicted?

The attribute on the left-hand side of the arrow in a functional dependency is the:

An attribute that may have more than one meaning is called a(n) :

In the figure below, what type of relationship do the relations depict?

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

When a regular entity type contains a multivalued attribute, one must: