Question 1

Domains are constraints on valid values for attributes.

Accepted Answer

A) True 
 B)False

Question 2

An attribute (or combination of attributes)that uniquely identifies each instance of an entity type defines:

Accepted Answer

A) data element occurrence 
B) trigger 
C) candidate key 
D) gerund

Question 3

An entity instance is a single occurrence of an entity type.

Accepted Answer

A) True 
 B)False

Question 4

A ternary relationship is the equivalent of three binary relationships.

Accepted Answer

A) True 
 B)False

Question 5

If STUDENT and COURSE participate in a relationship,their relationship is a(n):

Accepted Answer

A) unary relationship 
B) binary relationship 
C) ternary relationship 
D) extraordinary relationship

Question 6

For each entity,the name of the identifier is:

Accepted Answer

A) identified by using a double-lined ellipse 
B) underlined on an E-R diagram 
C) bold on an E-R diagram 
D) written in all capital letters on an E-R diagram

Question 7

A concise statement of the business rule to be enforced by the triggering operation refers to:

Accepted Answer

A) user rule 
B) condition 
C) action 
D) event

Question 8

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

Accepted Answer

A) True 
 B)False

Question 9

A named property or characteristic of an entity that is of interest to the organization defines:

Accepted Answer

A) attribute 
B) relationship 
C) instance 
D) gerund

Question 10

Which of the following specifies that an entity instance of the supertype is allowed not to belong to any subtype?

Accepted Answer

A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule

Question 11

The primary deliverable from the conceptual modeling step within the analysis phase is a(n):

Accepted Answer

A) state-transition diagram 
B) E-R diagram 
C) context data flow diagram 
D) decision tree

Question 12

A relationship that the data modeler chooses to model as an entity type best defines:

Accepted Answer

A) recursive relationship 
B) associative entity 
C) domain 
D) complex relationship

Question 13

A ________ is a generic entity type that has a relationship with one or more subtypes.

Accepted Answer

The answer of A ________ is a generic entity type...

Question 14

Universal data models and industry-specific data models are two types of packaged conceptual data models.

Accepted Answer

A) True 
 B)False

Question 15

A join is an association between the instances of one or more entity types that is of interest to the organization.

Accepted Answer

A) True 
 B)False

Question 16

Business rules are specifications that preserve the integrity of the physical data model.

Accepted Answer

A) True 
 B)False

Question 17

Book,supplier,and state are entity types.

Accepted Answer

A) True 
 B)False

Question 18

The condition that causes the operation to be triggered:

Accepted Answer

A) condition 
B) action 
C) entity name 
D) user rule

Question 19

Referencing an employee entity,an employee's skills are a multivalued attribute.

Accepted Answer

A) True 
 B)False

Question 20

A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings best defines:

Accepted Answer

A) child node 
B) disjoined entity 
C) subtype 
D) supertype

Exam 8: Structuring System Data Requirements

Domains are constraints on valid values for attributes.

An attribute (or combination of attributes) that uniquely identifies each instance of an entity type defines:

An entity instance is a single occurrence of an entity type.

A ternary relationship is the equivalent of three binary relationships.

If STUDENT and COURSE participate in a relationship,their relationship is a(n) :

For each entity,the name of the identifier is:

A concise statement of the business rule to be enforced by the triggering operation refers to:

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

A named property or characteristic of an entity that is of interest to the organization defines:

Which of the following specifies that an entity instance of the supertype is allowed not to belong to any subtype?

The primary deliverable from the conceptual modeling step within the analysis phase is a(n) :

A relationship that the data modeler chooses to model as an entity type best defines:

A ________ is a generic entity type that has a relationship with one or more subtypes.

Universal data models and industry-specific data models are two types of packaged conceptual data models.

A join is an association between the instances of one or more entity types that is of interest to the organization.

Business rules are specifications that preserve the integrity of the physical data model.

Book,supplier,and state are entity types.

The condition that causes the operation to be triggered:

Referencing an employee entity,an employee's skills are a multivalued attribute.

A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings best defines: