Question 1

Data structures include data organized in the form of tables with rows and columns.

Accepted Answer

A) True 
 B)False

Question 2

A composite key consists of only one attribute.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)   synonym.
B)   alias.
C)   alternate attribute.
D)   related characteristic.E) B) and C)
F) None of the above

Question 4

Physical database design decisions must be made carefully because of impacts on:

Accepted Answer

A)   data accessibility.
B)   response times.
C)   security.
D)   all of the above.E) A) and B)
F) A) and C)

Question 5

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Accepted Answer

A)   link attribute.
B)   link key.
C)   foreign key.
D)   foreign attribute.E) C) and D)
F) A) and B)

Question 6

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

Accepted Answer

Each regular entity is transformed into ...

Question 7

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 8

There can be multivalued attributes in a relation.

Accepted Answer

A) True 
 B)False

Question 9

An alternative name for an attribute is a(n)________.

Accepted Answer

The answer of An alternative name for an attribute is...

Question 10

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

Accepted Answer

A) True 
 B)False  True

Question 11

When all multivalued attributes have been removed from a relation,it is said to be in:

Accepted Answer

A)   first normal form.
B)   second normal form.
C)   Boyce-Codd normal form.
D)   third normal form.E) B) and C)
F) A) and D)

Question 12

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

Accepted Answer

A surrogate key should be created when any of the following conditions hold: there is a composite primary key,the natural primary key is inefficient (such as a long name)or if the natural primary key is recycled.When you have an associative entity,it is often best to use a surrogate key when you have more than two relations that the associative entity is related to,since the primary key would be a composite of the primary keys of all entities related to the associative entity.

Question 13

Discuss the two possible scenarios when mapping an associative entity.

Accepted Answer

There are two possible cases for associa...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)   Primary
B)   Recursive primary
C)   Composite
D)   Recursive foreignE) C) and D)
F) B) and D)

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ is a set of values that may be assigned to an attribute.

Accepted Answer

The answer of A(n)________ is a set of values that...

Question 18

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.E) None of the above
F) All of the above

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)   FourthE) A) and C)
F) None of the above B

Question 20

The process of decomposing relations with anomalies to create smaller,well-structured relations is called ________.

Accepted Answer

The answer of The process of decomposing relations with anomalies...

Exam 4: Logical Database Design and the Relational Model

Data structures include data organized in the form of tables with rows and columns.

Correct Answer
verified

A composite key consists of only one attribute.

Correct Answer
verified

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

Correct Answer
verified

Physical database design decisions must be made carefully because of impacts on:

Correct Answer
verified

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Correct Answer
verified

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

Correct Answer
verified
Each regular entity is transformed into ...
View Answer

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.

Correct Answer
verified

There can be multivalued attributes in a relation.

Correct Answer
verified

An alternative name for an attribute is a(n)________.

Correct Answer
verified

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

Correct Answer
verified
True

When all multivalued attributes have been removed from a relation,it is said to be in:

Correct Answer
verified

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

Discuss the two possible scenarios when mapping an associative entity.

Correct Answer
verified
There are two possible cases for associa...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

A(n)________ is a set of values that may be assigned to an attribute.

Correct Answer
verified

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

Correct Answer
verified

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?

Correct Answer
verified
B

The process of decomposing relations with anomalies to create smaller,well-structured relations is called ________.

Correct Answer
verified

Exam 4: Logical Database Design and the Relational Model

Data structures include data organized in the form of tables with rows and columns.

Correct AnswerverifiedShow Answer

A composite key consists of only one attribute.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Physical database design decisions must be made carefully because of impacts on:

Correct AnswerverifiedShow Answer

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedEach regular entity is transformed into ...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

There can be multivalued attributes in a relation.

Correct AnswerverifiedShow Answer

An alternative name for an attribute is a(n)________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

When all multivalued attributes have been removed from a relation,it is said to be in:

Correct AnswerverifiedShow Answer

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

Discuss the two possible scenarios when mapping an associative entity.

Correct AnswerverifiedThere are two possible cases for associa...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n)________ is a set of values that may be assigned to an attribute.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedB

The process of decomposing relations with anomalies to create smaller,well-structured relations is called ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Each regular entity is transformed into ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
There are two possible cases for associa...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified