Question 1

Features that everyone agrees are necessary to solve the problem or meet the opportunity are called:

Accepted Answer

A)  desired features. 
B)  essential features. 
C)  mandatory features. 
D)  minimum features. 
E)  requested features.

Question 2

A unary relationship is the most common type of relationship encountered in data modeling.

Accepted Answer

A) True 
 B)False

Question 3

In theory, if there are four sources of application software, two implementation environments, and three sets of requirements, how many design strategies are possible?

Accepted Answer

A)  4 
B)  24 
C)  9 
D)  2 
E)  27

Question 4

A repeating group is a set of two or more multivalued attributes that are logically related.

Accepted Answer

A) True 
 B)False

Question 5

In theory, if there are six sets of requirements, four implementation environments, and five sources of application software, then there would be one hundred twenty possible design strategies.

Accepted Answer

A) True 
 B)False

Question 6

A good number of alternatives to generate is five.

Accepted Answer

A) True 
 B)False

Question 7

A ternary relationship occurs when a simultaneous relationship exists among instances of:

Accepted Answer

A)  the same entity. 
B)  two entity types. 
C)  three entity types. 
D)  four entity types. 
E)  nine entity types.

Question 8

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository.

Accepted Answer

A) True 
 B)False

Question 9

The most common format used for data modeling is:

Accepted Answer

A)  state-transition diagramming. 
B)  entity-relationship diagramming. 
C)  process modeling. 
D)  logic modeling. 
E)  a flowchart.

Question 10

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)  associative entity. 
E)  data flow.

Question 11

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

Accepted Answer

A) True 
 B)False

Question 12

During systems analysis:

Accepted Answer

A)  a conceptual data model (E-R with attributes) is prepared. 
B)  a logical model (relational) is prepared. 
C)  physical files and database designs are prepared. 
D)  an enterprise-wide data model is prepared. 
E)  database and file definitions are prepared.

Question 13

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

Accepted Answer

A) True 
 B)False

Question 14

When referencing an employee entity, an employee's skills are an example of a multivalued attribute.

Accepted Answer

A) True 
 B)False

Question 15

A single occurrence of an entity type defines:

Accepted Answer

A)  entity instance. 
B)  entity appearance. 
C)  attribute. 
D)  data element. 
E)  multivalued attribute.

Question 16

A True data entity will have many possible instances, each with a distinguishing characteristic, as well as one or more other descriptive pieces of data.

Accepted Answer

A) True 
 B)False

Question 17

During the designing the human interface step of the design phase, you would enumerate different potential implementation environments that could be used to deliver the different sets of capabilities.

Accepted Answer

A) True 
 B)False

Question 18

Relationships are labeled with verb phrases.

Accepted Answer

A) True 
 B)False

Question 19

Identifying mandatory features by surveying users and other stakeholders who have been involved in requirements determination would occur:

Accepted Answer

A)  near the end of the analysis phase, after all requirements have been structured and analyzed. 
B)  near the end of the project identification and selection phase, after a formal request to conduct a project to design and develop an information systems solution has been approved. 
C)  during the logical design phase, while detailed function specifications of all data, forms, reports, screens, and processing rules for all aspects of the system are prepared. 
D)  during systems planning and selection. 
E)  during systems implementation and operation.

Question 20

A primary key should be null.

Accepted Answer

A) True 
 B)False

Exam 7: Structuring System Requirements: Conceptual Data Modeling

Features that everyone agrees are necessary to solve the problem or meet the opportunity are called:

A unary relationship is the most common type of relationship encountered in data modeling.

In theory, if there are four sources of application software, two implementation environments, and three sets of requirements, how many design strategies are possible?

A repeating group is a set of two or more multivalued attributes that are logically related.

In theory, if there are six sets of requirements, four implementation environments, and five sources of application software, then there would be one hundred twenty possible design strategies.

A good number of alternatives to generate is five.

A ternary relationship occurs when a simultaneous relationship exists among instances of:

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository.

The most common format used for data modeling is:

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

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

During systems analysis:

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

When referencing an employee entity, an employee's skills are an example of a multivalued attribute.

A single occurrence of an entity type defines:

A True data entity will have many possible instances, each with a distinguishing characteristic, as well as one or more other descriptive pieces of data.

During the designing the human interface step of the design phase, you would enumerate different potential implementation environments that could be used to deliver the different sets of capabilities.

Relationships are labeled with verb phrases.

Identifying mandatory features by surveying users and other stakeholders who have been involved in requirements determination would occur:

A primary key should be null.