Question 1

In the following diagram,which of the answers below is true?

Accepted Answer

A)  Each patient has one or more patient histories. 
B)  Each patient has one and only one visit. 
C)  Each patient history belongs to one and only one patient. 
D)  Both A and C 
A)  Each patient has one or more patient histories. 
B)  Each patient has one and only one visit. 
C)  Each patient history belongs to one and only one patient. 
D)  Both A and C

Question 2

A logical representation of the data for an organization or for a business area is called a(n)________.

Accepted Answer

entity-rel

Question 3

Which of the following is NOT a characteristic of a good business rule?

Accepted Answer

A)  Declarative 
B)  Atomic 
C)  Inconsistent 
D)  Expressible 
A)  Declarative 
B)  Atomic 
C)  Inconsistent 
D)  Expressible

Question 4

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

Accepted Answer

A)  composite attribute. 
B)  composite identifier. 
C)  identifying attribute. 
D)  relationship identifier. 
A)  composite attribute. 
B)  composite identifier. 
C)  identifying attribute. 
D)  relationship identifier.

Question 5

A relationship between the instances of a single entity type is called a(n)________ relationship.

Accepted Answer

A)  ternary 
B)  primary 
C)  binary 
D)  unary 
A)  ternary 
B)  primary 
C)  binary 
D)  unary

Question 6

A fact is an association between two or more:

Accepted Answer

A)  words. 
B)  terms. 
C)  facts. 
D)  nuggets. 
A)  words. 
B)  terms. 
C)  facts. 
D)  nuggets.

Question 7

It is not permissible to associate attributes with relationships.

Accepted Answer

A) True 
 B)False

Question 8

The degree of a relationship is the number of attributes that are associated with it.

Accepted Answer

A) True 
 B)False

Question 9

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

Accepted Answer

An associative entity is an entity type

Question 10

A multivalued attribute may take on more than one value for a particular entity instance.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following criteria should be considered when selecting an identifier?

Accepted Answer

A)  Choose an identifier that is stable. 
B)  Choose an identifier that will not be null. 
C)  Choose an identifier that doesn't have large composite attributes. 
D)  All of the above. 
A)  Choose an identifier that is stable. 
B)  Choose an identifier that will not be null. 
C)  Choose an identifier that doesn't have large composite attributes. 
D)  All of the above.

Question 12

An example of a term would be the following sentence: "A student registers for a course."

Accepted Answer

A) True 
 B)False

Question 13

A time stamp is a time value that is associated with a data value.

Accepted Answer

A) True 
 B)False

Question 14

The E-R model is used to construct a conceptual model.

Accepted Answer

A) True 
 B)False

Question 15

Participation in a relationship may be optional or mandatory.

Accepted Answer

A) True 
 B)False

Question 16

In the figure below,one might want to create a single-attribute surrogate identifier to substitute for the composite identifier.

Accepted Answer

A) True 
 B)False

Question 17

The relationship between a weak entity type and its owner is an identifying relationship.

Accepted Answer

A) True 
 B)False

Question 18

A ternary relationship is equivalent to three binary relationships.

Accepted Answer

A) True 
 B)False

Question 19

An attribute that can be calculated from related attribute values is called a(n)________ attribute.

Accepted Answer

A)  simple 
B)  composite 
C)  multivalued 
D)  derived 
A)  simple 
B)  composite 
C)  multivalued 
D)  derived

Question 20

The relationship between the instances of two entity types is called a binary relationship.

Accepted Answer

A) True 
 B)False

In the following diagram,which of the answers below is true?

A logical representation of the data for an organization or for a business area is called a(n)________.

Which of the following is NOT a characteristic of a good business rule?

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

A relationship between the instances of a single entity type is called a(n)________ relationship.

A fact is an association between two or more:

It is not permissible to associate attributes with relationships.

The degree of a relationship is the number of attributes that are associated with it.

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

A multivalued attribute may take on more than one value for a particular entity instance.

Which of the following criteria should be considered when selecting an identifier?

An example of a term would be the following sentence: "A student registers for a course."

A time stamp is a time value that is associated with a data value.

The E-R model is used to construct a conceptual model.

Participation in a relationship may be optional or mandatory.

In the figure below,one might want to create a single-attribute surrogate identifier to substitute for the composite identifier.

The relationship between a weak entity type and its owner is an identifying relationship.

A ternary relationship is equivalent to three binary relationships.

An attribute that can be calculated from related attribute values is called a(n)________ attribute.

The relationship between the instances of two entity types is called a binary relationship.

The Database Environment and Development Process

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

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 2: Modeling Data in the Organization

In the following diagram,which of the answers below is true?

A logical representation of the data for an organization or for a business area is called a(n)________.

Which of the following is NOT a characteristic of a good business rule?

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

A relationship between the instances of a single entity type is called a(n)________ relationship.

A fact is an association between two or more:

It is not permissible to associate attributes with relationships.

The degree of a relationship is the number of attributes that are associated with it.

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

A multivalued attribute may take on more than one value for a particular entity instance.

Which of the following criteria should be considered when selecting an identifier?

An example of a term would be the following sentence: "A student registers for a course."

A time stamp is a time value that is associated with a data value.

The E-R model is used to construct a conceptual model.

Participation in a relationship may be optional or mandatory.

In the figure below,one might want to create a single-attribute surrogate identifier to substitute for the composite identifier.

The relationship between a weak entity type and its owner is an identifying relationship.

A ternary relationship is equivalent to three binary relationships.

An attribute that can be calculated from related attribute values is called a(n)________ attribute.

The relationship between the instances of two entity types is called a binary relationship.

The Database Environment and Development Process

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

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