Question 1

Discuss when it is best to create a surrogate key for an associative entity.

Accepted Answer

A surrogate key should be created when a

Question 2

All values that appear in a column of a relation must be taken from the same domain.

Accepted Answer

A) True 
 B)False

Question 3

A relation in fifth normal form may not contain any anomalies.

Accepted Answer

A) True 
 B)False

Question 4

How do you convert weak entities to relations?

Accepted Answer

A weak entity becomes a relation. Howeve

Question 5

When transforming a one-to-one relationship, a new relation is always created.

Accepted Answer

A) True 
 B)False

Question 6

Discuss how you would map a regular entity to a relation.

Accepted Answer

Each regular entity is transformed into

Question 7

Discuss the types of integrity constraints.

Accepted Answer

The three major types of integrity const

Question 8

List and explain 1ˢᵗ, 2ⁿᵈ, 3ʳᵈ, BCNF, 4ᵗʰ, and 5ᵗʰ normal forms.

Accepted Answer

There are six different normal forms, al

Question 9

Referring to the figure below, which of the following is NOT true?

Accepted Answer

A)  A component is part of an item. 
B)  A component is always used in only one item. 
C)  A component can be part of an item. 
D)  A component may be used in many items. 
A)  A component is part of an item. 
B)  A component is always used in only one item. 
C)  A component can be part of an item. 
D)  A component may be used in many items.

Question 10

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

Accepted Answer

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

Question 11

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 12

________ 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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A co-dependency is a constraint between two attributes or two sets of attributes.

Accepted Answer

A) True 
 B)False

Question 15

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

Which of the following are properties of relations?

Accepted Answer

A)  Each attribute has the same name. 
B)  No two rows in a relation are identical. 
C)  There are multivalued attributes in a relation. 
D)  All columns are numeric. 
A)  Each attribute has the same name. 
B)  No two rows in a relation are identical. 
C)  There are multivalued attributes in a relation. 
D)  All columns are numeric.

Question 18

A relation that contains minimal redundancy and allows easy use is considered to be:

Accepted Answer

A)  clean. 
B)  simple. 
C)  complex. 
D)  well-structured. 
A)  clean. 
B)  simple. 
C)  complex. 
D)  well-structured.

Question 19

________ are anomalies that can be caused by editing data in tables.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Discuss when it is best to create a surrogate key for an associative entity.

All values that appear in a column of a relation must be taken from the same domain.

A relation in fifth normal form may not contain any anomalies.

How do you convert weak entities to relations?

When transforming a one-to-one relationship, a new relation is always created.

Discuss how you would map a regular entity to a relation.

Discuss the types of integrity constraints.

List and explain 1ˢᵗ, 2ⁿᵈ, 3ʳᵈ, BCNF, 4ᵗʰ, and 5ᵗʰ normal forms.

Referring to the figure below, which of the following is NOT true?

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

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

________ problems are encountered when removing data with transitive dependencies.

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

A co-dependency is a constraint between two attributes or two sets of attributes.

Which of the following violates the atomic property of relations?

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

Which of the following are properties of relations?

A relation that contains minimal redundancy and allows easy use is considered to be:

________ are anomalies that can be caused by editing data in tables.

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

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

Discuss when it is best to create a surrogate key for an associative entity.

All values that appear in a column of a relation must be taken from the same domain.

A relation in fifth normal form may not contain any anomalies.

How do you convert weak entities to relations?

When transforming a one-to-one relationship, a new relation is always created.

Discuss how you would map a regular entity to a relation.

Discuss the types of integrity constraints.

List and explain 1ˢᵗ, 2ⁿᵈ, 3ʳᵈ, BCNF, 4ᵗʰ, and 5ᵗʰ normal forms.

Referring to the figure below, which of the following is NOT true?

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

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

________ problems are encountered when removing data with transitive dependencies.

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

A co-dependency is a constraint between two attributes or two sets of attributes.

Which of the following violates the atomic property of relations?

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

Which of the following are properties of relations?

A relation that contains minimal redundancy and allows easy use is considered to be:

________ are anomalies that can be caused by editing data in tables.

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

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