Question 1

A relationship between instances of two entity types is a:

Accepted Answer

A)  unary relationship. 
B)  binary relationship. 
C)  ternary relationship. 
D)  multiple occurrence. 
E)  partnership occurrence.

Question 2

Cardinality is the number of instances of entity B that can (or must) be associated with each instance of entity A.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following types of alternatives represent compromise solutions?

Accepted Answer

A)  Low-end alternatives 
B)  High-end alternatives 
C)  Midrange alternatives 
D)  Requirements-dependent alternatives 
E)  Constraints-dependent alternatives

Question 4

Match each of the following alternatives with its corresponding description.(Answers may occur more than once.)
-These alternatives are the most conservative in terms of the effort, cost, and technology involved in developing a new system.

Accepted Answer

A) High-end alternatives 
B) Midrange alternatives 
C) Low-end alternatives

Question 5

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Accepted Answer

A) True 
 B)False

Question 6

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-A recursive relationship is a relationship between the instances of two entity types.

Accepted Answer

The answer of For each of the following statements, answer...

Question 7

During the alternative generation and selection step of the analysis phase, you would propose different ways to source or acquire the various sets of capabilities for the different implementation environments.

Accepted Answer

A) True 
 B)False

Question 8

When generating alternative design strategies, a high-end alternative will provide all desired features using advanced technologies that often allow the system to expand to meet future requirements.

Accepted Answer

A) True 
 B)False

Question 9

Match each of the following terms with its corresponding definition.
-An attribute that can have more than one value for each entity instance

Accepted Answer

A) Entity 
B) Entity type 
C) Attribute 
D) Multivalued attribute 
E) Entity instance

Question 10

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

Accepted Answer

A)  investigative approach. 
B)  business approach. 
C)  bottom-up approach. 
D)  top-down approach. 
E)  conceptual approach.

Question 11

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false.
-Many instances of an entity type may be represented by data stored in the database.

Accepted Answer

The answer of For each of the following statements, answer...

Question 12

Some systems developers believe that a data model is the most important part of the statement of information system requirements because:

Accepted Answer

A)  the characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports. 
B)  data rather than processes are the most complex aspects of many modern information systems and thus require a central role in structuring system requirements. 
C)  the characteristics about data are reasonably permanent. 
D)  structural information about data is essential to generate programs automatically. 
E)  of all of the above.

Question 13

An analyst would ask "What must we know about each object in order to run a business?" in order to determine relationships, their cardinality, and degrees.

Accepted Answer

A) True 
 B)False

Question 14

What are multivalued attributes and repeating groups? Provide an example of each.

Accepted Answer

The answer of What are multivalued attributes and repeating groups?...

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

During alternative generation and selection, management may decide to end the project for a variety of reasons, including the fact that the needs of the organization have changed.

Accepted Answer

A) True 
 B)False

Question 17

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false.
-Upper- and lowercase letters are used in naming an entity type.

Accepted Answer

The answer of For each of the following statements, answer...

Question 18

In order to determine attributes and secondary keys, an analyst might ask, "What characteristics describe each object?"

Accepted Answer

A) True 
 B)False

Question 19

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.)
-sale

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship

Question 20

Briefly discuss generating alternative design strategies.

Accepted Answer

The answer of Briefly discuss generating alternative design strategies....

Exam 7: Structuring System Requirements: Conceptual Data Modeling

A relationship between instances of two entity types is a:

Cardinality is the number of instances of entity B that can (or must) be associated with each instance of entity A.

Which of the following types of alternatives represent compromise solutions?

Match each of the following alternatives with its corresponding description.(Answers may occur more than once.) -These alternatives are the most conservative in terms of the effort, cost, and technology involved in developing a new system.

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -A recursive relationship is a relationship between the instances of two entity types.

During the alternative generation and selection step of the analysis phase, you would propose different ways to source or acquire the various sets of capabilities for the different implementation environments.

When generating alternative design strategies, a high-end alternative will provide all desired features using advanced technologies that often allow the system to expand to meet future requirements.

Match each of the following terms with its corresponding definition. -An attribute that can have more than one value for each entity instance

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false. -Many instances of an entity type may be represented by data stored in the database.

Some systems developers believe that a data model is the most important part of the statement of information system requirements because:

An analyst would ask "What must we know about each object in order to run a business?" in order to determine relationships, their cardinality, and degrees.

What are multivalued attributes and repeating groups? Provide an example of each.

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

During alternative generation and selection, management may decide to end the project for a variety of reasons, including the fact that the needs of the organization have changed.

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false. -Upper- and lowercase letters are used in naming an entity type.

In order to determine attributes and secondary keys, an analyst might ask, "What characteristics describe each object?"

For each of the examples listed below, indicate if it is a relationship, an entity, or an attribute.(Answers may occur more than once.) -sale

Briefly discuss generating alternative design strategies.