Question 1

The top-down approach to data modeling derives a data model from an intimate understanding of the nature of the business.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship 
A) Attribute 
B) Entity 
C) Relationship

Question 3

Match each of the following terms with its corresponding definition.
-A single occurrence of an entity type

Accepted Answer

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

Question 4

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

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship 
A) Attribute 
B) Entity 
C) Relationship

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A ternary relationship is a relationship between instances of one entity type.

Accepted Answer

A) True 
 B)False

Question 7

An attribute that can have more than one value for each entity instance is referred to as:

Accepted Answer

A)  a gerund. 
B)  a multivalued attribute. 
C)  a nonexclusive attribute. 
D)  a data replica. 
E)  none of the above. 
A)  a gerund. 
B)  a multivalued attribute. 
C)  a nonexclusive attribute. 
D)  a data replica. 
E)  none of the above.

Question 8

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

Accepted Answer

A) Attribute 
B) Entity 
C) Relationship 
A) Attribute 
B) Entity 
C) Relationship

Question 9

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false.
-The goal of conceptual data modeling is to identify as much of the processing activity as possible.

Accepted Answer

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

Question 10

When selecting an identifier, one should choose a candidate key that will not change its value over the life of each instance of the entity type.

Accepted Answer

A) True 
 B)False

Question 11

A renewal is an example of a(n):

Accepted Answer

A)  data element. 
B)  attribute. 
C)  entity. 
D)  relationship. 
E)  action stub. 
A)  data element. 
B)  attribute. 
C)  entity. 
D)  relationship. 
E)  action stub.

Question 12

The number of entity types that participate in a relationship refers to:

Accepted Answer

A)  cardinality. 
B)  association. 
C)  count. 
D)  degree. 
E)  normalization. 
A)  cardinality. 
B)  association. 
C)  count. 
D)  degree. 
E)  normalization.

Question 13

If entity B is a mandatory participant, then:

Accepted Answer

A)  the minimum cardinality of the relationship is two. 
B)  the minimum cardinality of the relationship cannot be defined. 
C)  the minimum cardinality of the relationship is one. 
D)  the minimum cardinality of the relationship is optional. 
E)  the join level is not null. 
A)  the minimum cardinality of the relationship is two. 
B)  the minimum cardinality of the relationship cannot be defined. 
C)  the minimum cardinality of the relationship is one. 
D)  the minimum cardinality of the relationship is optional. 
E)  the join level is not null.

Question 14

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false.
-A singular noun is used to name an entity type.

Accepted Answer

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

Question 15

Which of the following is a true statement regarding high-end alternatives?

Accepted Answer

A)  High-end alternative design strategies often do not involve computer technology; instead they focus on making paper flows more efficient or reducing redundancies in current processes. 
B)  High-end alternative design strategies represent compromise solutions. 
C)  Functionality is the primary focus of high-end alternative design strategies. 
D)  High-end alternative design strategies provide all the required functionality users demand with a system that is minimally different from the current system. 
E)  None of the above is correct. 
A)  High-end alternative design strategies often do not involve computer technology; instead they focus on making paper flows more efficient or reducing redundancies in current processes. 
B)  High-end alternative design strategies represent compromise solutions. 
C)  Functionality is the primary focus of high-end alternative design strategies. 
D)  High-end alternative design strategies provide all the required functionality users demand with a system that is minimally different from the current system. 
E)  None of the above is correct.

Question 16

Which of the following includes statements on the system's functionality, hardware and system software platform, and method for acquisition?

Accepted Answer

A)  Problem statement 
B)  Requirements statement 
C)  Design strategy 
D)  Systems service request 
E)  Statement of work 
A)  Problem statement 
B)  Requirements statement 
C)  Design strategy 
D)  Systems service request 
E)  Statement of work

Question 17

In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"

Accepted Answer

A) True 
 B)False

Question 18

Constraints on systems development include time, finances, and legal and contractual restrictions.

Accepted Answer

A) True 
 B)False

Question 19

Match each of the following terms with its corresponding definition.
-A relationship between instances of two entity types

Accepted Answer

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

Question 20

The minimum number of instances of entity B that may be associated with each instance of entity A defines the:

Accepted Answer

A)  degree of the relationship. 
B)  minimum cardinality of the relationship. 
C)  maximum cardinality of the relationship. 
D)  domain of the relationship. 
E)  join level. 
A)  degree of the relationship. 
B)  minimum cardinality of the relationship. 
C)  maximum cardinality of the relationship. 
D)  domain of the relationship. 
E)  join level.

The top-down approach to data modeling derives a data model from an intimate understanding of the nature of the business.

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

Match each of the following terms with its corresponding definition. -A single occurrence of an entity type

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

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

A ternary relationship is a relationship between instances of one entity type.

An attribute that can have more than one value for each entity instance is referred to as:

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

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -The goal of conceptual data modeling is to identify as much of the processing activity as possible.

When selecting an identifier, one should choose a candidate key that will not change its value over the life of each instance of the entity type.

A renewal is an example of a(n):

The number of entity types that participate in a relationship refers to:

If entity B is a mandatory participant, then:

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false. -A singular noun is used to name an entity type.

Which of the following is a true statement regarding high-end alternatives?

Which of the following includes statements on the system's functionality, hardware and system software platform, and method for acquisition?

In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"

Constraints on systems development include time, finances, and legal and contractual restrictions.

Match each of the following terms with its corresponding definition. -A relationship between instances of two entity types

The minimum number of instances of entity B that may be associated with each instance of entity A defines the:

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Designing the Human Interface

Designing Databases

Systems Implementation and Operation

object-Oriented Analysis and Design

Agile Methodologies

Filters

Exam 7: Structuring System Requirements: Conceptual Data Modeling

The top-down approach to data modeling derives a data model from an intimate understanding of the nature of the business.

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

Match each of the following terms with its corresponding definition. -A single occurrence of an entity type

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

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

A ternary relationship is a relationship between instances of one entity type.

An attribute that can have more than one value for each entity instance is referred to as:

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

For each of the following statements, answer "a" if it is a true statement or answer "b" if the statement is false. -The goal of conceptual data modeling is to identify as much of the processing activity as possible.

When selecting an identifier, one should choose a candidate key that will not change its value over the life of each instance of the entity type.

A renewal is an example of a(n):

The number of entity types that participate in a relationship refers to:

If entity B is a mandatory participant, then:

For each of the following statements, answer "a" if it is a true statement, or answer "b" if the statement is false. -A singular noun is used to name an entity type.

Which of the following is a true statement regarding high-end alternatives?

Which of the following includes statements on the system's functionality, hardware and system software platform, and method for acquisition?

In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"

Constraints on systems development include time, finances, and legal and contractual restrictions.

Match each of the following terms with its corresponding definition. -A relationship between instances of two entity types

The minimum number of instances of entity B that may be associated with each instance of entity A defines the:

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Designing the Human Interface

Designing Databases

Systems Implementation and Operation

object-Oriented Analysis and Design

Agile Methodologies

Filters