Question 1

Which of the following is a true statement?

Accepted Answer

A)  The goal of conceptual data modeling is to capture as much of the meaning of data as is possible. 
B)  The efficiencies gained by maintaining systems at the rule rather than code level drastically reduce cost. 
C)  If a thorough repository of data descriptions is kept, the system can be regenerated as the business rules change. 
D)  The more details about data that we can model, the better the system we can design and build. 
E)  All of the above are true statements.

Question 2

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 3

An association between the instances of one or more entity types that is of interest to the organization best defines:

Accepted Answer

A)  occurrence. 
B)  relationship. 
C)  natural connection. 
D)  cardinality. 
E)  entity link.

Question 4

The characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports.

Accepted Answer

A) True 
 B)False

Question 5

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship

Question 7

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 8

A candidate key that has been selected as the unique, identifying characteristic for an entity type is called a(n):

Accepted Answer

A)  attribute. 
B)  identifier. 
C)  secondary key. 
D)  gerund. 
E)  index.

Question 9

Which of the following is a true statement?

Accepted Answer

A)  A data model explains what the organization does and what rules govern how work is done in the organization. 
B)  To construct a data model, you need to know how data are processed. 
C)  To construct a data model, you need to know when data are processed. 
D)  A data flow diagram graphically illustrates the structure and relationships among data items. 
E)  During conceptual data modeling, the preparation of a Network diagram is necessary.

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

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

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship

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

Match each of the following terms with its corresponding definition.
-A set of two or more multivalued attributes that are logically related

Accepted Answer

A) Unary relationship 
B) Ternary relationship 
C) Binary relationship 
D) Relationship 
E) Repeating group
F)Associative entity

Question 14

Vehicle identification number, color, weight, and horsepower best exemplify:

Accepted Answer

A)  entities. 
B)  entity types. 
C)  data markers. 
D)  identifiers. 
E)  attributes.

Question 15

Which of the following is a true statement?

Accepted Answer

A)  Mandatory features screen out possible solutions; essential features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
B)  Essential features screen out possible solutions; mandatory features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
C)  Mandatory features screen out possible solutions; essential features are those that users could live without. 
D)  Essential features screen out possible solutions; mandatory features are those that users could live without. 
E)  Desired features screen out possible solutions; mandatory features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies.

Question 16

During systems implementation and operation:

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 17

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 18

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

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship

Question 19

Shaping alternative system design strategies involves:

Accepted Answer

A)  enumerating different potential implementation environments. 
B)  proposing different ways to source or acquire the various sets of capabilities for the different implementation environments. 
C)  dividing requirements into different sets of capabilities. 
D)  all of the above. 
E)  none of the above.

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 7: Structuring System Requirements: Conceptual Data Modeling

Which of the following is a true statement?

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.

An association between the instances of one or more entity types that is of interest to the organization best defines:

The characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports.

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

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

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 candidate key that has been selected as the unique, identifying characteristic for an entity type is called a(n) :

Which of the following is a true statement?

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

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

During systems analysis:

Match each of the following terms with its corresponding definition. -A set of two or more multivalued attributes that are logically related

Vehicle identification number, color, weight, and horsepower best exemplify:

Which of the following is a true statement?

During systems implementation and operation:

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.

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

Shaping alternative system design strategies involves:

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