Question 1

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 2

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 B

Question 3

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 4

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 5

A composite key consists of only one attribute.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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. 
A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form.

Question 8

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

Accepted Answer

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

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Discuss the two possible scenarios when mapping an associative entity.

Accepted Answer

There are two possible cases for associa

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

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

Accepted Answer

Each regular entity is transformed into

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

There can be multivalued attributes in a relation.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

A)  synonym. 
B)  alias. 
C)  alternate attribute. 
D)  related characteristic. 
A)  synonym. 
B)  alias. 
C)  alternate attribute. 
D)  related characteristic.

Question 18

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

Question 19

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. 
A)  link attribute. 
B)  link key. 
C)  foreign key. 
D)  foreign attribute.

Question 20

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. 
A)  data accessibility. 
B)  response times. 
C)  security. 
D)  all of the above.

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

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?

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

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

A composite key consists of only one attribute.

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

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

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

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.

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

Discuss the two possible scenarios when mapping an associative entity.

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

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

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

There can be multivalued attributes in a relation.

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

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

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

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

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 4: Logical Database Design and the Relational Model

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

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?

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

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

A composite key consists of only one attribute.

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

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

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

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.

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

Discuss the two possible scenarios when mapping an associative entity.

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

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

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

There can be multivalued attributes in a relation.

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

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

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

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

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

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters