Question 1

Anomalies do not generally arise out of transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 2

All of the following are the main goals of normalization EXCEPT:

Accepted Answer

A)  minimize data redundancy. 
B)  simplify the enforcement of referential integrity. 
C)  maximize storage space. 
D)  make it easier to maintain data. 
A)  minimize data redundancy. 
B)  simplify the enforcement of referential integrity. 
C)  maximize storage space. 
D)  make it easier to maintain data.

Question 3

An identifier assigned to an associative entity is also called a cross-relation key.

Accepted Answer

A) True 
 B)False

Question 4

The normal form which deals with multivalued dependencies is called:

Accepted Answer

A)  fifth normal form. 
B)  fourth normal form. 
C)  Boyce-Codd normal form. 
D)  sixth normal form. 
A)  fifth normal form. 
B)  fourth normal form. 
C)  Boyce-Codd normal form. 
D)  sixth normal form.

Question 5

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

Accepted Answer

A)  Primary 
B)  Recursive primary 
C)  Composite 
D)  Recursive foreign 
A)  Primary 
B)  Recursive primary 
C)  Composite 
D)  Recursive foreign

Question 6

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.

Question 7

A primary key that consists of more than one attribute is called a:

Accepted Answer

A)  foreign key. 
B)  composite key. 
C)  multivalued key. 
D)  cardinal key. 
A)  foreign key. 
B)  composite key. 
C)  multivalued key. 
D)  cardinal key.

Question 8

The relational data model does, at this time, directly support subtype/supertype relationships.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

An anomaly is an error or inconsistency

Question 11

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

Accepted Answer

A) True 
 B)False

Question 12

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Accepted Answer

A)  referential integrity constraint. 
B)  key match rule. 
C)  entity key group rule. 
D)  foreign/primary match rule. 
A)  referential integrity constraint. 
B)  key match rule. 
C)  entity key group rule. 
D)  foreign/primary match rule.

Question 13

The figure below is an example of mapping which type of relationship?

Accepted Answer

A)  First 
B)  Second 
C)  Unary 
D)  Ternary 
A)  First 
B)  Second 
C)  Unary 
D)  Ternary

Question 14

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

Accepted Answer

A)  Composite 
B)  Foreign 
C)  Standard 
D)  Grouped 
A)  Composite 
B)  Foreign 
C)  Standard 
D)  Grouped

Question 15

There can be multivalued attributes in a relation.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

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

Discuss the properties of relations.

Accepted Answer

Each relation (or table) has a unique na

Question 20

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

Accepted Answer

A) True 
 B)False

Anomalies do not generally arise out of transitive dependencies.

All of the following are the main goals of normalization EXCEPT:

An identifier assigned to an associative entity is also called a cross-relation key.

The normal form which deals with multivalued dependencies is called:

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

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

A primary key that consists of more than one attribute is called a:

The relational data model does, at this time, directly support subtype/supertype relationships.

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

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

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

The figure below is an example of mapping which type of relationship?

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

There can be multivalued attributes in a relation.

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

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

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

Discuss the properties of relations.

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

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

Anomalies do not generally arise out of transitive dependencies.

All of the following are the main goals of normalization EXCEPT:

An identifier assigned to an associative entity is also called a cross-relation key.

The normal form which deals with multivalued dependencies is called:

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

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

A primary key that consists of more than one attribute is called a:

The relational data model does, at this time, directly support subtype/supertype relationships.

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

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

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

The figure below is an example of mapping which type of relationship?

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

There can be multivalued attributes in a relation.

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

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

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

Discuss the properties of relations.

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

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