Question 1

A ternary relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling.

Accepted Answer

A) True 
 B)False

Question 2

A(n)________ is a concise statement of the business rule to be enforced by the triggering operation.

Accepted Answer

A) Event 
B) User rule 
C) Action 
D) Condition

Question 3

On what basis are objects referenced,selected,qualified,sorted,and categorized?

Accepted Answer

A) Attributes and secondary keys 
B) Entities 
C) Primary keys 
D) Index

Question 4

A(n)________ is a person,place,object,event,or concept in the user environment about which the organization wishes to maintain data.

Accepted Answer

A) Dimension 
B) Attribute 
C) Object 
D) Entity

Question 5

Explain the concept of cardinality.Give an example.

Accepted Answer

The answer of Explain the concept of cardinality.Give an example....

Question 6

What are the benefits of beginning an operation with a packaged logical data model?

Accepted Answer

The answer of What are the benefits of beginning an...

Question 7

A(n)________ is a specification that indicates how many objects participate in a given relationship.

Accepted Answer

A) Association role 
B) Multiplicity 
C) Association 
D) Object class

Question 8

Event entity types should be named for the result of the ________,not the activity or process of the event.

Accepted Answer

A) Event 
B) Class 
C) Entity 
D) Object

Question 9

The most common format used for data modeling is ________ diagramming.

Accepted Answer

A) Entity-class 
B) Entity-object 
C) Entity-subject 
D) Entity-relationship

Question 10

An entity type that associates the instances of only one type and contains attributes that are peculiar to the relationship between those entity instances.

Accepted Answer

A) True 
 B)False

Question 11

Why do some systems developers believe the data model is the most important part of IS requirements?

Accepted Answer

The answer of Why do some systems developers believe the...

Question 12

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 13

One situation in which a relationship must be turned into an associative entity is when the associative entity has other relationships with entities besides the relationship that caused its creation.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ is the data manipulation operation (insert,delete,or update)that initiates the operation.

Accepted Answer

A) Event 
B) User rule 
C) Action 
D) Condition

Question 15

A(n)________ is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.

Accepted Answer

A) Relationship 
B) Associative entity 
C) Identifier 
D) Cardinality

Question 16

The primary deliverable from the physical data modeling step within the analysis phase is an E-R diagram.

Accepted Answer

A) True 
 B)False

Question 17

A primary key is an attribute (or combination of attributes)that uniquely identifies each instance of an entity type.

Accepted Answer

A) True 
 B)False

Question 18

A(n)________ is an attribute that may not have a value forevery entity instance.

Accepted Answer

A) Required attribute 
B) Derived attribute 
C) Composite attribute 
D) Optional attribute

Question 19

Define triggering operation.Provide an example and include the components.

Accepted Answer

The answer of Define triggering operation.Provide an example and include...

Question 20

A(n)________ is an attribute that must have a value forevery entity instance.

Accepted Answer

A) Derived attribute 
B) Composite attribute 
C) Required attribute 
D) Optional attribute

Exam 8: Structuring System Data Requirements

A ternary relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling.

A(n) ________ is a concise statement of the business rule to be enforced by the triggering operation.

On what basis are objects referenced,selected,qualified,sorted,and categorized?

A(n) ________ is a person,place,object,event,or concept in the user environment about which the organization wishes to maintain data.

Explain the concept of cardinality.Give an example.

What are the benefits of beginning an operation with a packaged logical data model?

A(n) ________ is a specification that indicates how many objects participate in a given relationship.

Event entity types should be named for the result of the ________,not the activity or process of the event.

The most common format used for data modeling is ________ diagramming.

An entity type that associates the instances of only one type and contains attributes that are peculiar to the relationship between those entity instances.

Why do some systems developers believe the data model is the most important part of IS requirements?

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.

One situation in which a relationship must be turned into an associative entity is when the associative entity has other relationships with entities besides the relationship that caused its creation.

A(n) ________ is the data manipulation operation (insert,delete,or update) that initiates the operation.

A(n) ________ is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.

The primary deliverable from the physical data modeling step within the analysis phase is an E-R diagram.

A primary key is an attribute (or combination of attributes)that uniquely identifies each instance of an entity type.

A(n) ________ is an attribute that may not have a value forevery entity instance.

Define triggering operation.Provide an example and include the components.

A(n) ________ is an attribute that must have a value forevery entity instance.