Question 1

A primary key whose value is unique across all relations is called a(n):

Accepted Answer

A)  global primary key. 
B)  inter-table primary key. 
C)  enterprise key. 
D)  foreign global key. 
A)  global primary key. 
B)  inter-table primary key. 
C)  enterprise key. 
D)  foreign global key. C

Question 2

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

Question 3

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

Accepted Answer

A)  functional relation. 
B)  attribute dependency. 
C)  functional dependency. 
D)  functional relation constraint. 
A)  functional relation. 
B)  attribute dependency. 
C)  functional dependency. 
D)  functional relation constraint. C

Question 4

A foreign key is a primary key of a relation that also is a primary key in another relation.

Accepted Answer

A) True 
 B)False

Question 5

Discuss the various relational keys.

Accepted Answer

A primary key uniquely identifies each r

Question 6

An enterprise key is a foreign key whose value is unique across all relations.

Accepted Answer

A) True 
 B)False

Question 7

Explain how subtype/supertype relationships are converted to relations.

Accepted Answer

When we have a supertype/subtype relatio

Question 8

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.

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

A synonym is an attribute that may have more than one meaning.

Accepted Answer

A) True 
 B)False

Question 12

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 13

What is an anomaly, and what are the three types of anomalies?

Accepted Answer

An anomaly is an error or inconsistency

Question 14

Anomalies do not generally arise out of transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 15

View integration is the process of merging relations together.

Accepted Answer

A) True 
 B)False

Question 16

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Accepted Answer

A)  column. 
B)  foreign field. 
C)  primary key. 
D)  duplicate key. 
A)  column. 
B)  foreign field. 
C)  primary key. 
D)  duplicate key.

Question 17

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

Accepted Answer

A) True 
 B)False

Question 18

Data integrity consists of powerful operations to manipulate data stored in relations.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

A primary key whose value is unique across all relations is called a(n):

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

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

A foreign key is a primary key of a relation that also is a primary key in another relation.

Discuss the various relational keys.

An enterprise key is a foreign key whose value is unique across all relations.

Explain how subtype/supertype relationships are converted to relations.

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.

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

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

A synonym is an attribute that may have more than one meaning.

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

What is an anomaly, and what are the three types of anomalies?

Anomalies do not generally arise out of transitive dependencies.

View integration is the process of merging relations together.

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

Data integrity consists of powerful operations to manipulate data stored in relations.

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?

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 4: Logical Database Design and the Relational Model

A primary key whose value is unique across all relations is called a(n):

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

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

A foreign key is a primary key of a relation that also is a primary key in another relation.

Discuss the various relational keys.

An enterprise key is a foreign key whose value is unique across all relations.

Explain how subtype/supertype relationships are converted to relations.

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.

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

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

A synonym is an attribute that may have more than one meaning.

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

What is an anomaly, and what are the three types of anomalies?

Anomalies do not generally arise out of transitive dependencies.

View integration is the process of merging relations together.

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

Data integrity consists of powerful operations to manipulate data stored in relations.

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?

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters