Question 1

A transversal dependency is a functional dependency between two or more nonkey attributes.

Accepted Answer

A) True 
 B)False

Question 2

Discuss how to map a unary one-to-many relationship.

Accepted Answer

The entity type in the unary relationshi

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A)  candidate key. 
B)  determinant. 
C)  foreign key. 
D)  primary key. 
A)  candidate key. 
B)  determinant. 
C)  foreign key. 
D)  primary key.

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A form of database design which maps conceptual requirements is called:

Accepted Answer

A)  logical designs. 
B)  response designs. 
C)  security design. 
D)  physical design. 
A)  logical designs. 
B)  response designs. 
C)  security design. 
D)  physical design.

Question 7

CASE tools can model more complex data relationships, such as ternary relationships.

Accepted Answer

A) True 
 B)False

Question 8

The columns of a relation can be interchanged without changing the meaning or use of the relation.

Accepted Answer

A) True 
 B)False

Question 9

A nonkey attribute is also called a(n):

Accepted Answer

A)  column. 
B)  unimportant datum. 
C)  descriptor. 
D)  address. 
A)  column. 
B)  unimportant datum. 
C)  descriptor. 
D)  address.

Question 10

Sample data are useful for developing prototype applications and for testing queries.

Accepted Answer

A) True 
 B)False

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  partial functional dependency. 
B)  partial nonkey dependency. 
C)  transitive dependency. 
D)  partial transitive dependency. 
A)  partial functional dependency. 
B)  partial nonkey dependency. 
C)  transitive dependency. 
D)  partial transitive dependency.

Question 13

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

Accepted Answer

A) True 
 B)False

Question 14

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?

Accepted Answer

A)  First 
B)  Second 
C)  Third 
D)  Fourth 
A)  First 
B)  Second 
C)  Third 
D)  Fourth

Question 15

The entity integrity rule states that:

Accepted Answer

A)  no primary key attribute can be null. 
B)  referential integrity must be maintained across all entities. 
C)  each entity must have a primary key. 
D)  a primary key must have only one attribute. 
A)  no primary key attribute can be null. 
B)  referential integrity must be maintained across all entities. 
C)  each entity must have a primary key. 
D)  a primary key must have only one attribute.

Question 16

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

Accepted Answer

A)  Identifying entity/weak entity 
B)  Multivalued 
C)  Composite foreign key 
D)  One-to-many 
A)  Identifying entity/weak entity 
B)  Multivalued 
C)  Composite foreign key 
D)  One-to-many

Question 17

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

Accepted Answer

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. 
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.

Question 18

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

Accepted Answer

A)  Sample data can be used to improve user communications. 
B)  Sample data can be used for prototype generation. 
C)  Sample data can reverse database implementation errors. 
D)  Sample data provide a convenient way to check the accuracy of your design. 
A)  Sample data can be used to improve user communications. 
B)  Sample data can be used for prototype generation. 
C)  Sample data can reverse database implementation errors. 
D)  Sample data provide a convenient way to check the accuracy of your design.

Question 19

Which of the following violates the atomic property of relations?

Accepted Answer

A)  Sam 
B)  Hinz 
C)  Sam Hinz 
D)  Atomic 
A)  Sam 
B)  Hinz 
C)  Sam Hinz 
D)  Atomic

Question 20

________ problems are encountered when removing data with transitive dependencies.

Accepted Answer

A)  Insertion 
B)  Modification 
C)  Deletion 
D)  Merging 
A)  Insertion 
B)  Modification 
C)  Deletion 
D)  Merging

A transversal dependency is a functional dependency between two or more nonkey attributes.

Discuss how to map a unary one-to-many relationship.

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

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

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

A form of database design which maps conceptual requirements is called:

CASE tools can model more complex data relationships, such as ternary relationships.

The columns of a relation can be interchanged without changing the meaning or use of the relation.

A nonkey attribute is also called a(n):

Sample data are useful for developing prototype applications and for testing queries.

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.

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

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

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 entity integrity rule states that:

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

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

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

Which of the following violates the atomic property of relations?

________ problems are encountered when removing data with transitive dependencies.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 4: Logical Database Design and the Relational Model

A transversal dependency is a functional dependency between two or more nonkey attributes.

Discuss how to map a unary one-to-many relationship.

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

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

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

A form of database design which maps conceptual requirements is called:

CASE tools can model more complex data relationships, such as ternary relationships.

The columns of a relation can be interchanged without changing the meaning or use of the relation.

A nonkey attribute is also called a(n):

Sample data are useful for developing prototype applications and for testing queries.

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.

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

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

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 entity integrity rule states that:

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

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

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

Which of the following violates the atomic property of relations?

________ problems are encountered when removing data with transitive dependencies.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Introduction to SQL

Advanced SQL

Databases in Applications

Physical Database Design and Database Infrastructure

Data Warehousing and Data Integration

Big Data Technologies

Analytics and Its Implications

Data and Database Administration With Focus on Data Quality

Distributed Databases

Object-Oriented Data Modeling

Filters